Skip to main content
Solved

Report rule for current user


Forum|alt.badge.img+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
 

 

Best answer by carlosfmendes

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]’]

 

View original
Did this topic help you find an answer to your question?

3 replies

Technical Outlaws
Hero (Employee)
Forum|alt.badge.img+11

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


Forum|alt.badge.img+8
  • Author
  • Hero (Customer)
  • 31 replies
  • Answer
  • April 17, 2024

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]’]

 


Forum|alt.badge.img+8
  • Author
  • Hero (Customer)
  • 31 replies
  • April 17, 2024
Technical Outlaws wrote:

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


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings