on 08-20-2009 12:12 AM
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.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
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)
User | Count |
---|---|
95 | |
11 | |
11 | |
10 | |
9 | |
7 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.