Interactive Report using Runtime Analytics

[Community_User]

Originally posted on May 26 2020 at 10:31 UTC

Hi,

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

[Community_User]

Originally posted on May 27 2020 at 07:26 UTC

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

Once you click on Run, this is what comes up and you can perform a multi-selection

[Community_User]

Originally posted on May 27 2020 at 11:07 UTC

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

[Community_User]

Originally posted on May 27 2020 at 11:27 UTC

It seems it will not execute query on click but Query will be executed after Run Control. Please confirm this

[Community_User · Accepted solution]

Originally posted on May 27 2020 at 15:57 UTC

Yes Rushikesh, the query will be executed only on click of Run Control.
That is the expected behavior.