Join us on May 14-15, 2019 at Forrester Digital Transformation & Innovation 2019 in Chicago, USA.

Skip to end of metadata
Go to start of metadata

SQL Chart equips you with another medium of reporting by using charts. You are given the flexibility of defining your own SQL query to determine the charts that you would like to generate, ranging from a number of graph types.

Sample SQL Query

Userview Key Usage
Within the SQL query

Userview Key can be used as part of the SQL string itself.

Sample SQL Query usage with Userview Key
Setting the Userview Key Name attribute

One may also define the filter name in Advanced > Userview Key Name which Joget will then take in account as part of the original query set earlier when fetching the dataset.

You may expect to get the same result regardless of methods used above.

  • No labels