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]’]
+11Could 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
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
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
