I have a table with 14 columns with column ZBNr as primary key.
The table displays nicely in the ARI Data Tables module in an article.
Because the table is too wide to fit on a page, I make the ZBNr field into a link. When clicked the one record should be displayed in a format where the database columns are displayed as rows in the ARI table. Since the whole page is available for this one record, the user has a better overview.

I based myself on an earlier post in the forum where Link to another ARI Table is explained (www.ari-soft.com/ARI-Data-Tables/29303-Link-to-another-ari-data-table.html#29344).
The only difference is that the primary and secondary table are the same.

So, I did the following:
1. Duplicate the module.
2. Create a new article with the second module instance.
3. Set the parameter Fixed ID to No for both module instances. Is this good or bad????
4. In Column settings for the primary table, I have a column with ID = ZBNr and Format = <a href="index.php?option=com_content&view=article&id=68&ZBNr={$value}">{$value}</a>
(Note: I first followed your instructions to put only the index.php?option...={value} part in the Format field and set Recognize links to Yes, but that simply displayed the text "index.php?option..." in the table for column ZBNr. So I put the full link syntax in the Format field).
5. In the parameter settings for the secondary module, I set the SQL query to: SELECT * From #__archiefindex WHERE ZBNr={$REQUEST:ZBNr}

The website now shows the primary table nicely with each ZBNr as a link. Clicking any such link displays the secondary article, but shows the following error message:

DataTables warning (table id = 'at_51ece9d8d2604'): DataTables warning: JSON data from server could not be parsed. This is caused by a JSON formatting error.

The secondary module is stuck on displaying "Processing ..."
I suppose it must have something to do with the WHERE ZBNr={$REQUEST:ZBNr} syntax in the second module, since when I change it to WHERE ZBNr=10001, it does what is then expected.

Here is where I need your help since I am not a programming expert.

I also have the following questions:
1. I want the secondary table to display the database columns as rows in the ARI table. I thought the parameter "Revert data" was doing exactly that. However when I set it, the query does not find any results (with the test query WHERE ZBNr=10001).
2. Can I avoid the second database access? I address the same table twice and the content of all the records (including the selected one) is still available in a variable.
3. My final solution would be to display the secondary table preferably in a tooltip or else in an ARI shadowbox instead of a seperate article. But I first must clear the error case.

My overall impression on this module is very good and I do appreciate your prompt response to customer's questions!
Chris

Hello,

Could you provide a link to a page where we can see the problem? If if it is private, you can send it by email.

Regarding the questions:

1. It should do what you need. If it doesn't work, could you send a link to a page where we can see the problem and screenshots of module settings page by email so we can investigate the problem?

2. The extension doesn't provide this ability.

3. It is possible to show article with secondary table into the lightbox using "System - ARI Sexy Lightbox" plugin from ARI Sexy Lightbox extension.

Regards,
ARI Soft

Set "Server side pagination" parameter to "No" for "ARI Data Tables" module instance which is used to show secondary table.

Regards,
ARI Soft

It works!!
Thank you very much for the prompt support.

A point of detail: the key value passed from the primary table is shown in bold above the table, without the column header. I expected that this column would also be shown in the table (header + content). Is this by design?

A satisfied customer.
Chris

I see, the column settings parameters are not effective when in Revert data mode.
Column settings become actually "row settings" in that case.
I can work around that.
Great product.
Chris

1. "Data transformation" is used to prepare data from a database for graph and charts. In you case, you can modify modify your SQL query in the following. For example if original query is:

SELECT
*
FROM
tbl T
WHERE
id = {$REQUEST:id}

use the following query:

SELECT
'' AS fake_column,
T.*
FROM
tbl T
WHERE
id = {$REQUEST:id}


2. Columns settings is applied for reverted data (when column keys are values).

Regards,
ARI Soft