Hi

With Ari Smart Content Datatable I want to use the SQL query $REQUEST to select some records.
I would like to pass a parameter from one joomla article page1 to another, page2 containing
{arimodule id="xx"}{/arimodule}

example:
<a href="index.php/page2?code=YYYYY>List</a>

in page2
{arimodule id="xx"}{/arimodule}

and the SQL query has
{$REQUEST:code}

It is possible?
What is the exact syntax?

another question

I may use?
{arimodule id="xx" code="YYYYY"}{/arimodule}

I'm no expert. Please, I would like, if possible, an explanation for dummies.

Thank You

Hello,

You can read how to use request variables in SQL query here (see description of "Query" parameter).

For example if you want to convert values of "title" column to hyperlinks, open SQL query settings page, set "Columns settings -> ID" parameter to title value and "Columns settings -> Format" parameter to the following value:



If you want to send value from "code" column, use the following code in "Columns settings -> Format" parameter:



Regards,
ARI Soft

I think I have not explained well.

The hyperlink that calls page2 is fixed and is handwritten by creating joomla article. It is not from a Datatable

for example

on page X I have
<a href="index.php/page2?code=XXXXX> TextX </a>

on page Y I have
<a href="index.php/page2?code=YYYYY> texty </a>

and on page Z I have
<a href="index.php/page2?code=ZZZZZ> TextZ </a>

Datatable is in page2
And I want to write the SQL query

SELECT 'id','title','date' FROM 'mytable' WHERE 'id'={$REQUEST:code}

What is the exact syntax in the url parameter and 'id'={$REQUEST:code} to work well?

Thanks

If you are working with MySQL database, use the following query:



Regards,
ARI Soft

This syntax is to try to use, but I get the following error:

DataTables warning: table id = dt_137 - Ajax error. For more information about this error, please see datatables.net/tn/7

If I use SELECT 'id', 'title', 'date' FROM 'mytable' WHERE 1

Datatable works Ok but, logically, with all records.

Why?

Thanks

Currently the extension doesn't support ability to use request variable when server side pagination is enabled. Set "Server side pagination" parameter to "No" in module settings.

Regards,
ARI Soft