I would like to know the solution for the below question
I have a single query which could be filtered with two different set of prompts depending on the value selected by the user in one of the prompt
For example: We have a prompt named status, which has LOV of All and Active only.
If the user select ‘all’ the query needs to be filtered based on below list of prompts
effective date between start and end date entered by the use
status is = y
If the user selects ‘active only’ then the query needs to be filtered based on below list of prompts
effective date less than or equal to date entered by user
expiration date greater than or equal to date entered by user.
Status is = x
Now All and active only values do not exist in the database, please give me a solution without case when conditions.
I am in Business Objects XI R2 and I donÂ’t need to provide optional prompts, I only need to provide the logic for the optional prompts.
suddhalaasi (BOB member since 2009-09-25)
(BOB member since 2007-12-06)