User Role Lookup
Feature
In order to comprehensively understand which segments of an organization are impacted by an issue, Germain has the capability to automatically identify the role of a user who encountered a UX problem. While this feature has been available since 2014, the 2023.3 Release introduces refinements to offer greater flexibility. Understanding that a user's role may vary across applications like Salesforce, Siebel, Shopify, etc., and can sometimes be complex, Germain has enhanced its functionality.
To expand on this, we’ve introduced support for Key Expressions with multiple values. The Key Expression uses the existing key property, now allowing you to specify multiple fields, such as user
and system.environment
. This generates a key in the format of: <username>|<environment>
.
Example (for Oracle Siebel CRM)
In this case for Oracle Siebel CRM:
select u.LOGIN, p.POSTN_TYPE_CD "Primary Role"
from siebel.s_contact e, siebel.S_USER u, siebel.S_POSTN p
where 1=1
and e.pr_held_postn_id = p.par_row_id
and e.par_row_id = u.par_row_i
