how to use SQL Chart? can u make a toturial for these element for easy learning.. :) and where i can find the Target DB Url in these element... and please give me example for the query in SQL chart...  

  • No labels

1 Comment

  1. N. Hafizi Kamaruzzaman

    This post is quite old but for future references, I will try to answer my best.

    For target DB, you can select 'System Settings>Datasource & Profile' and copy the value

    For the SQL Query, try the this:

    SELECT <column name1>, COUNT(*) FROM <table name> GROUP BY <column name1>;

    I got the information from here : http://jogetworkflow-tutorial.blogspot.com/2013/06/userview-sql-chart-tutorial.html

    Hope this helps =)

    P/S: I'm using Joget V3 and V4.