Hi,

Can I set column filter with Ari Data Tables as for smart.ari-soft.com/ari-mootable.html ?

See the image file include.

I would like set by default a value for column1, column2 and column3 (in the image is blank by default) and also associate a lists of values to each column.

I would like associate to each column a SQL Query (List of values).

Thank you,

Benoit L.

Hi,

I have used this examples from Ari-Soft, but it's not completely what I have need.

A) How set default value ?
How associate list of values by using a SQL Query ?

"ARI Data Tables" supports ability to use request variables in SQL query. For example you can embed "ARI Data Tables" module into an article and add the next HTML code to add filter (for example by "price" column in "products" table) in your Article :

Use this code in article content :
-----------------------------------------------------------------
<form method="post">
Min price: <input type="text" size="10" name="dtMinPrice" />
<br/><br/>
<input type="submit" value="Search" />
</form>

{aridatatables moduleId="104"}{/aridatatables}
------------------------------------------------------------------


and use the next SQL query in Ari Data Tables module:
-----------------------------------------------------------------
SELECT
*
FROM
products
WHERE
price > {$REQUEST:dtMinPrice}
-----------------------------------------------------------------

Benoit L.

Hi,

I have replaced dtMinPrice by Portfolio. Portfolio column is a string of characters.

My problem is when the column is empty. {$REQUEST:Portfolio} return a comma <,>

If we put a value {$REQUEST:Portfolio} return 'value' with single quote.

I would like {$REQUEST:Portfolio} return nothing '' when the column is empty.

I can't use in the SQL where clause {$REQUEST:Portfolio} MySQL give syntax error.

because we have ft.portfolio = , when the column is empty
and we have ft.portfolio = 'value' when the column has data

Thank,

Benoit L.

Hello,

What SQL query do you use?

Regards,
ARI Soft

This is the code used in the Article content

<form method="post">Portfolio: <input name="Portfolio" size="10" type="text" /> <br/><br/> <input value="Search" type="submit" /></form>

{aridatatables moduleId="104"}{/aridatatables}

This is the code used in the module mod_aridatatables

SELECT distinct
ft.portfolio as "Portfolio",
ft.market as "Market",
ft.name as "Name",
fms.full_name as "Full name"
FROM benoitle_stock.fin_portfolio fp, benoitle_stock.fin_my_stocks fms, benoitle_stock.fin_transaction ft
LEFT JOIN benoitle_stock.fin_stock fs ON (ft.market = fs.market and ft.name = fs.name)
LEFT JOIN benoitle_stock.fin_scenario fsc ON (ft.market = fsc.market and ft.name = fsc.name)
WHERE ft.market = fms.market
AND ft.name = fms.name
and ft.market = fp.market
and ft.name = fp.name
and ft.portfolio = fp.portfolio
and fp.portfolio like concat({$REQUEST:Portfolio},'%')

It is not clear what error occurs in this query. Is it possible to provide a link to a page where we can see a problem and a temporary access to your J! backend by email so we can investigate it?

Regards,
ARI Soft