Skip to Content

Why is [lov] used in Prompt in Universe?

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?



Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • 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.


    Add comment
    10|10000 characters needed 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.

    Add comment
    10|10000 characters needed characters exceeded

    • 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.