Solved

Report rule for current user

  • 17 April 2024
  • 3 replies
  • 22 views
C
Rank
Userlevel 3
Badge +8

Good afternoon everybody,

We are trying to select a specific crystal report within the material requisition picklist print dialog, and we want one of the crystal reports to be the default one when the user is part of the Logistics department, and we are able to get this through a query.

How can we add a query in the expression and filter the query by the current user, so that if it gives back values, it is TRUE?

Thanks in advance for your help.
Carlos Mendes
 

 

icon

Best answer by carlosfmendes 17 April 2024, 18:02

View original

3 replies

Technical Outlaws
Rank
Userlevel 5
Badge +11

Could you not use IDENTITY = Fnd_Session_API.Get_Fnd_User in the SELECT statement?

C
Rank
Userlevel 3
Badge +8

Ok, after some tests, was able to get it working.

I leave here the solution if others need something similar.

[&SELECT something FROM somewhere WHERE somefield=’[#IFSVariable]’]

 

C
Rank
Userlevel 3
Badge +8

Could you not use IDENTITY = Fnd_Session_API.Get_Fnd_User in the SELECT statement?

Hi @Technical Outlaws ,

That is also a possibility, however it wasn’t working beforehand because I had no quotes for the variable and I also had an error within the query filtering a field.

Thanks for your feedback.
Carlos Mendes

Reply


Terms & ConditionsCookie settings