Contact Report Prompts — Cloud Customer Connect
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Contact Report Prompts

Summary:

Criteria

  • When a user launches the Contact Report the default Contact Owner should be based on the user's role (AM see their contacts) 
  • When the Regional Manager launches the Contact Report the default would be their entire team selected.

I was trying to fulfill the criteria using the query below, but it is not returning any results in the report:

SELECT
"Contact"."Contact Name",
"Employee"."Employee Name",
"Employee"."Employee Job Title"
FROM
"EMPLOYEE_TABLE"
WHERE
(
-- Account Manager sees only their own contacts
("Employee"."Employee Job Title" = 'ACCOUNT_MANAGER'
AND "Employee"."Employee Login Name" = VALUEOF(NQ_SESSION."USERGUID"))
OR

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!