I am attempting to display a list of users in an ARI datatable with the following SQL
statement:

SELECT id as "User ID",
name as "Name",
username as "Username",
FROM #__users

I included this in the settings' SQL query textarea which allows SQL to be added to the component (image attached).

However, whenever I press save, the query is removed and I'm left with no SQL. This means my page using the table returns an error since it's set to use SQL but is returning no results on account of an empty SQL statement.

How should I go about solving this?

Thanks,
Dave

I also tried selecting CSV as the source and adding a path to a CSV of the users table instead, but my settings for that were also overwritten.

Other settings seem to be saving just fine.

Hello,

Make sure "System - ARI Extensions" plugin is enabled. If it doesn't help, could you provide a temporary access to your J! backend by email so we can investigate the problem?

Regards,
ARI Soft