User Organization Hierarchy Based Login

Cyrille Saulnier-Oracle

Summary:

 I am trying to fix a report and it looks like the Hierarchy is broken (Sales - CRM Resource subject area):

Content (required):

1. when using User Organization Hierarchy Based Login is equal to / is in @{NQ_SESSION.USER_PARTY_ID}, the data for the user reporting to the manager is not coming back
2. when adding Manager of Employee is equal to / is in Cyrille Saulnier, the data is showing

The report used to work so it looks like something got broken on the way. Can anybody help?

Version (include the version you are using, if applicable):

Code Snippet (add any code snippets that support your topic, if applicable):

ravikiran goda-Oracle

Can you please provide screenshots and the log file of the report

Cyrille Saulnier-Oracle

Hi,

Basically, the following query only returns the employee data not the users in the hierarchy

Employee Login is equal to / is in  @{NQ_SESSION.USER_PARTY_ID}

OR User Organization Hierarchy Based Login is equal to / is in  @{NQ_SESSION.USER_PARTY_ID}

If we have the below query then you see the team data:

Manager of Employee is equal to / is in  Cyrille Saulnier

Thanks in advance