How to pass dynamic where clause to IR report from application item.Can you please suggest.
Example
select col1,colo2 from table where col1 in(:P1_ITEM)
P1_ITEM contains in clause select query
Lost your password? Please enter your email address. You will receive a link and will create a new password via email.
OrclQA Wiki
To pass a dynamic WHERE clause in an Interactive Report, you can use the following steps:
a. Navigate to the Page Designer in APEX. b. Under "Items," click "Create" (the "+" icon) and choose "Hidden." c. Set the "Name" property for the hidden item, for example, "P1_DYNAMIC_WHERE." d. Save the changes.
a. Navigate to the Page Designer in APEX. b. Under "Regions," click "Create" (the "+" icon) and choose "Interactive Report." c. Set the "Title" property for the Interactive Report region. d. In the "Source" section, set the "Type" property to "SQL Query." e. Write your SQL query, using the hidden page item to represent the dynamic WHERE clause. For example:
You can set the value of the hidden page item (P1_DYNAMIC_WHERE) using a Dynamic Action, PL/SQL code, or JavaScript. Here's an example of setting the value using JavaScript:
Replace "your_interactive_report_static_id" with the actual Static ID of your Interactive Report region.
This should allow you to pass a dynamic WHERE clause in your Interactive Report in Oracle APEX.
shashi
Hi ,
Thanks but i need to pass the condition in IN clause can you please suggest.