Hi,
We have one of Dynamic LOV prompt which is created in Business view manager. DF command pull all users related data which is nearly 16 Lakhs records. Instead of letting to run for all users data, I would like to run query for logged in user data some thing like where username = {CurrentCEUserName}. How can I implement this? I tried to add this where clause but SQL validation is getting failed.
Appreciate your inputs.
Thanks
Narendar M