Using 'Matches Pattern' and 'Inlist' in one prompt.

[system]

@Dan_Morgan

I’ve created a report that contains many report prompts, one of which being the following:

PLANT_MATERIALS.MRP_CONTROLLER IN @variable(‘2. Select ‘‘MRP Controller/s’’ for analysis’)

However rather than just being able to pick from the LOV or enter the values required, how can I modify the prompt so that the user can pick from the list of values or enter a wildcard; eg, % so that the report returns all values.

You need to create a predefined condition at the Universe which makes either user enter some value or type %. Have a look at this thread.

Click Here

@Dan_Morgan

Whilst I here I’ll ask another question: What determines the maximum number of values you can select when using the ‘Inlist’ prompt funtion?

There is a setting in the corresponding PRM file. If I remember properly it is MAX_INLIST_VALUES. You’ve gotta modify that.

Sri

---

Sridharan (BOB member since 2002-11-08)