Hi,
I'm using ARI Data tables and "ARI GChart" as table type, with SQL as a source type. And I'm using module id for placement in the articles. I have a couple of queries:

1. Can I get a label option for each data point, when I hover over it in the graph. Right now, it shows the value based on x-axis and y-axis. Instead, I need to show another database value that acts as a tag for each data point. Please see the attached file for more info.

2. Right now, I'm displaying data based on {$UserId}, the currently logged in user. Can this UserId be fed to the module on the fly as a variable. Example: I have a dropdown with list of userids. When I select one from the list, I need to feed the selected userid into the ARI DataTable module and display the data only for the selected userid.

Thanks in advance!

Hello,

1. The extension doesn't support this ability.

2. It is possible to use request variable in "WHERE" clauses of SQL query. It looks like:

SELECT
*
FROM
#__users
WHERE
id = {$REQUEST:selUserId}

so it is possible to load the module into an article and create a HTML form outside the module in the article where will be possible to select a user and then send ID of selected user to the module.

Regards,
ARI Soft

Thank you for the quick response! Will check out the solution for Q2.