I need to create a universe prompt that will enable the user to enter one or more values by which to filter, or to return all records (ie no filter). I have seen this done, where the word ALL was entered.
Help would be appreciated.
Thanks
cheers JD
jitesh (BOB member since 2005-05-20)
ok here you go…
Alter the LOV of the object to look like this
SELECT 'ALL' UNION SELECT distinct ....
Then your filter definition should be along the following lines…
table.col IN @PROMPT('<message>','A','LOV PATH',MULTI,FREE/CONSTRAINED) OR 'ALL' IN @PROMPT('<message>','A','LOV PATH',MULTI,FREE/CONSTRAINED)
Prateek Shah (BOB member since 2005-07-24)
Designer FAQ 8)
Dave Rathbun (BOB member since 2002-06-06)