Click HERE to see how Saviynt Intelligence is transforming the industry. |
04/12/2022 12:56 PM
I am creating interactive report which will take endpointname from user , where user can select value from dropdown or multiselect
Can you provide syntax for SQL Query & Multi select Query in Interactive report.
Version 5.5
Below option is tried but not working
Solved! Go to Solution.
04/12/2022 01:56 PM
Here is a sample for both
SQL Query - Using this you can provide the SQL query as an input at runtime.
Sample query - select username, firstname, owner from users where owner in (${owner})
Sample default Value - select username from users where userkey between 1 and 10
Once you click on Run Now, this is what will come up
Multiple Select from List - this is more of a static selection of values
Sample Query - select username, firstname, owner from users where city in (${city})
Sample values - Bangalore,London,Mumbai,Houston
Sample Default Value - Houston
04/12/2022 01:56 PM
Hi Saparja ,
In Your example also its not showing username same as Multi select but its directly showing query input box.
expected that - it should show username
04/12/2022 01:56 PM
It seems it will not execute query on click but Query will be executed after Run Control. Please confirm this
04/12/2022 01:56 PM
Yes Rushikesh, the query will be executed only on click of Run Control.
That is the expected behavior.