I am trying to accomplish something similar to the following:

INNER JOIN
Database.Name_Tbl a
ON
a.idName_Tbl = Database.User_Tbl.Name_Tbl_idUser_Tbl

However, when I use Revert it throws the following error:

"ARI Smart Content - Data Table: It is not possible to use server side pagination with the selected source"

But, if I turn off Revert Data it throws an error of unknown parameter "#" for row 0. When I click ok it provides the table, but the column number it is referring to has "null".

How do I alias a table without getting these errors? I looked at other posts, but did not see anything similar.

Could you provide a link to a page where the problem occurs and a temporary access to your Joomla! backend by email so we can investigate the problem?

Regards,
ARI Soft

This is in an internal system that I cannot provide access to. Is there something you can think of that I might try in lieu of access?

Could you send an SQL dump of table(s) which are used in the query and send screenshots of module settings page and data source settings page by email so we can reproduce the problem on our test server?

PS: The source with enabled "Revert data" parameter can be used with "Server side pagination" because the extension retrieve all data and then reverts it.

Regards,
ARI Soft

Can you elaborate a little more on your PS: so I can compare to what I have done here. Are you saying that the Revert Data parameter should be used with Server Side Pagination enabled?

Unfortunately the SQL Tables are very large and not releasable.

Thank you for your assistance.