Issue in using @Variable('BOUSER') at LOV

building reports webintelligence
1

Hi All,

I am using @variable(‘BOUSER’) in LOV query to filter out LOV based on User ID, when the main prompt is displaying BOUSER also displaying as prompt below the main prompt. LOV’s are getting refreshed only when User ID is entered as prompt input.

If I have 5 prompts like this then BOUSER prompt appearing for each main prompt. Obviously its painful to enter the User ID for each prompt

Someone please help to get rid of this

bolead (BOB member since 2007-04-19)

2

I have no idea exactly how you are trying to use this or what version you are on.

Theres a couple of good posts on row level restrictions here:-
https://bobj-board.org/t/159828
https://bobj-board.org/t/134014

Mak 1 :uk: (BOB member since 2005-01-06)

3

Did you happen to freeze your LOV object’s SQL ? @variable will behave like an @prompt if you do so.

Shobhit_Acharya (BOB member since 2005-08-11)

4

Shobhit_Acharya,

By Freeze your LOV do you mean check the box “Do not generate SQL before running”? or are you referring to something else?

tmcd :us: (BOB member since 2005-10-02)