Skip to Content
author's profile photo Former Member
Former Member

Capturing constant value data entered at query filter


I have two tables one is Customertab and other

is Customerver.

Customertab has two columns customerid and customer address

customerver has two columns customerid and customer version

For example in customer version table Customerid 100 has 2 versions 1 and 2

customerid 200 has 3 versions 1,2 and 3

customerid 300 has 4 versions 1,2,3 and 4

when ever iam developing the report in query panel filter the first

condition i select is customer id=100 and in the second filter condition i

am giving condition as verid= and select the version from LOVS. but if i

select the lovs iam seeing all versions.

My requirement is like as i have selected 100 in the first

filtercondition i have to see only 2 versions 1 and 2 in LOVS when

selecting the

2nd condition.

i dont want to use prompts. So can you please let me know is there any

possibility to capture the 100 some where and use the condition to restrict

the LOV's in the next filter condition

Add a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • Posted on Jul 01, 2011 at 04:47 AM


    You can achieve this by creating cascading list of values in the universe.Then depending upon the object selection associate LOV users can see and enter.

    Universe designer : Tools/List of Values/Crate a Cascading Lists of Values.



    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member AMIT KUMAR


      I dont want to create the prompts.But in Cascading prompts i need to create the prompts right.

      My requirement is like as part of the report i have condition with customer_id=100 where 100 is the constant value and its not a prompt. So now in the next filter condition i have the prompt for selecting the versions. at the time of selecting the LOV for version then i need to consider the versions only for customerid 100 and display the available versions for the particular customerid 100.

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.