Ability to search on criteria in prompts

building reports webintelligence
9

Dear TSR_BO,

There are multiple links available in this forum already explaining the process of including “ALL” values,
You may refer the following link for same:
[list]https://bobj-board.org/t/15227/2
https://bobj-board.org/t/15227/9[/list]
I am just giving you a quick summary of same as below:

  1. Create a universe object for CustName prompt
    Sample code for Cust Name prompt: 
@Select(Class Name\Cust Name) IN 
@Prompt('CustName','A', ‘Class Name\CustName’, Multi,Free,Not_Persistent) or 'NoSearchRequired' in @Prompt('CustName','A', ‘Class Name\Cust Name’,Multi,Free,,Not_Persistent)
  1. Include ‘NoSearchRequired’ values in the LOV of Cust Name object as follows:
    [list]-- Click on the Cust Name object in universe
    – Press the SQL button in the query panel of the LOV
    – Add the phrase UNION SELECT ‘NoSearchRequired’ FROM DUAL. Final SQL code for LOV would be like:
SELECT Cust Name from <Table> UNION SELECT NoSearchRequired' from DUAL

– Please check the “Do not generate SQL before running” checkbox.[/list]
3. Please repeat the steps 1& 2 for Cust Number too with required changes in code as per cust Number

Please let us know if you face any issues.

All The Best!!

adhow (BOB member since 2006-08-08)