I have tried this with server side pagination turned off. The user input does not appear to be working. When I first go to the page with the search code the table initially populates with all records from my database. When I enter user input and click on search it retrieves all records in the database. It does not appear that variable in $REQUEST is being populated. Any thoughts?

Hello,

Could you send screenshots of module and data source settings pages by email and specify how you send request variable(s)? Is it possible to see the problem anywhere?

Regards,
ARI Soft

I have tried using many variations of the following:

table.field = {$REQUEST:searchStr|empty:''}

and

table.field LIKE CONCAT ("%", {$REQUEST:searchStr|empty:''}, "%")

however, I have not been able to successfully get them to work with User input. Every time I click on the search button, nothing is returned from the database. When I hard code an element I know is in the table, it is returned correctly.

Any thoughts as to why this is the case? I created a php script on my webserver and it shows that $_POST and $_REQUEST are both being populated and retrieved during the test.

Any other thoughts? Thank you.

What is "searchStr" variable, where it is populated?

If you use "ARI Smart Content - DataTable" application and what to use search string from search input which is shown by this application, use {$REQUEST:search:value} variable. Your code will look like:

field LIKE CONCAT('%',{$REQUEST:search:value|empty:''},'%')

Regards,
ARI Soft

I have tried the latest syntax you provided

field LIKE CONCAT('%',{$REQUEST:search:value|empty:''},'%')

for "ARI Smart Content - DataTable" which is what I am using, but this doesn't seem to work either. I noticed a syntax difference in the above query from what was in other posts in the forum. There is also a difference in this syntax from what is in the help link. Is there another document showing the proper syntax to use with "ARI Smart Content - DataTable"? Also, when I created the my Article in Joomla I used the following datatable module tag syntax:

{aridatatable id="89"}{/aridatatable}

is this the correct syntax for "ARI Smart Content - DataTable"? I tried using the +Module button in the edit Article screen to place the tag for the datatable Module. When the dialog opened I selected my datatable module, but the tag that was placed in the Article did not produce a table. I could only get a table by using the syntax shown above. Any insight would be great.

PS: Using your syntax for the query and turning off Server Side Pagination, the Article page will not display and shows that the page cannot be reached. When I turn on Server Side Pagination I can get to the Article, the table is there, but it displays all records in the database on initial visit. When I query the database using the HTML search form I use POST and my variable is searchStr. The query appears to query the database, but all records are retrieved and not the specific ones which are being queried for.

Thank you.

It seems you use code for "ARI Data Tables" extension. "ARI Data Tables" and "ARI Smart Content" are two different extension. Documentation for "ARI Smart Content" is available here.

Modules from "ARI Smart Content" can be loaded with help of "System - ARI Smart Content - Load Module" plugin. The documentation is here. Check that the plugin is enabled.

The solution which provides works 100% for "ARI Smart Content - Data Table" with enabled "Server side pagination". If it doesn't work, your query or configuration are wrong. We can investigate the problem if you reproduce the problem on a public server and provide a link to a page where the problem occurs and a temporary access to J! backend by email.

Regards,
ARI Soft