Skip to Content

Why is [lov] used in Prompt in Universe?

Aug 04, 2017 at 05:20 AM


avatar image

Hi All,

Can anyone help me in understanding what is the use of [lov] in a prompt function?

What is the advantage of using it in the prompt? And can you explain for both optional and mandatory prompts?



10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

2 Answers

Abhilasha Patil Aug 04, 2017 at 09:45 AM


The [lov] is one of the parameters in @prompt. You can leave it blank by just entering a comma.
You can provide static list of values like - {'val1','val2','val3'}. Or you can also specify - 'class\objectname'.
This would depend upon your requirement. And this is same for both optional and mandatory prompt.

I would request you to go through the universe design guide for more details on @prompt. All the parameters of @prompt are explained in very detail.


Show 1 Share
10 |10000 characters needed characters left characters exceeded

I understood the syntax and how to put in the lov.

I wanted to understand how the defined lov effects the prompt. So, for example, does the value specified in the lov are the only one that show up in the prompt list?

If I have specified 'class\objectname' as lov, will it pick all the values associated with this object? In that case, what is the difference between this and not having an lov defined? Because either way I can see all the values associated with an object showing up in the prompt list.

Aug 04, 2017 at 10:50 AM

LOV's are helpful for everyone to run the reports.let say If you have defined the Prompt on Product without LOV's then either everyone to remember the product name for which report needs to run otherwise you can not run the report.

If LOV's are associated then it's easy for everyone to pick the values form the list without remembering the values.

Yes 'class\objectname will show all values associated with object.

Show 2 Share
10 |10000 characters needed characters left characters exceeded

So, what is the difference if I don't specify the [lov] portion in the prompt function? I can still see all the data associated with the object if i simply check the option of pick from list in Prompt options. In the syntax @Prompt('message','type','lov',Mono|Multi,free|constrained|primary_key ,persistent|not_persistent,{'default value'}) even if 'lov' is blank, I will still see the values of the object, so why to define it at all?


Yes, so this is now upto your requirement. Not specifying any lov suffices your requirement.
But just in case, if you dont want to show all the values in lov then in that case you can specify a static list of desired values. Also there will be cases where you would like to use index awareness, primary key etc..

Apart from, displaying the list of values for the user to select, there isnt any special reason as such. You just need to define the syntax that gives you the desired output.