Skip to main content

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
 

 

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

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

 

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