How to include list of values in filter

[Former Member]

Hello Friends I am new to Universe design, I want to create a filter on field and filter should display multiple list of values like

phone,cell,email etc for the end user so that he can select one. Or else If he select '* 'he should get data for all LOV. * should be deault for all values. Thanks so much,

Toby.

[Former Member · Accepted solution]

Hi Toby,

When you create your reports in Web-I or Desk-I from Universe and use any of the object in filter. You should choose prompt and while running the report you will see the list of values.

These options are available in reporting tool .

At universe level you can also use @prompt function

For multiple values you can use operator "in list"

You can also use operator match patter to enter % (in oracle ) to select all values.

You have have choice to make your prompt optional which mean all values will be selected.

Best Regards,

Chetan

[Former Member · Accepted solution]

Hello thanks for the answer I am creating prompt in UNiverse XI R2 and DB2

W026DTI1.LIHEA_RECIPIENTS.LAST_NAME IN @Prompt('Enter Name','A',,MULTI,FREE) this way, but I want to modify this in a way that when user run report it asks for prompt and it has drop down list with LOV's how can i do that? By Classname is Office and object name is NAME do i need to use Office\Name? please advice

[anupkumar_rai · Accepted solution]

Hi,

Yes you have to add the classname/objectname to get the LOV from the object. Your filter will look like this

W026DTI1.LIHEA_RECIPIENTS.LAST_NAME IN @Prompt('Enter Name','A','Office\Name',MULTI,FREE)

Thanks

-Anup-

[Former Member · Accepted solution]

Hi,

Try the below.

W026DTI1.LIHEA_RECIPIENTS.LAST_NAME IN @Prompt('Enter Name','A',Classname/Objectname,MULTI,FREE)

Class name/Object Name is optional but if you used it then the prompt is efined for a particular object.

Cheers,

Suresh A.

[Former Member · Accepted solution]

Hi,

W026DTI1.LIHEA_RECIPIENTS.LAST_NAME IN @Prompt('Enter Name','A','Classname/Objectname',MULTI,FREE)

This 'Classname/Objectname' gives you the LOV of Objectname from which you can select the values.

While for having * in place of any values you need to add an OR condition while defining the prompt defition as

'*' IN @Prompt('Enter Name','A','Classname/Objectname',MULTI,FREE)

So, The complete definiton will be as:

 W026DTI1.LIHEA_RECIPIENTS.LAST_NAME IN @Prompt('Enter Name','A','Classname/Objectname',MULTI,FREE) OR '*' IN @Prompt('Enter Name','A','Classname/Objectname',MULTI,FREE)