Skip to Content
0
Former Member
May 10, 2018 at 03:48 PM

Business View Manager DF command with Where clause

62 Views

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