Home News Contact Us Forum About Us Demos Products F.A.Q.
Shopping Cart
You currently have 0 items in your cart.


Recent Events
  • 23/11/2024 Black Friday 2024

    BIG SALE, 30% discount for all our extensions. Use BF24 coupon code. Hurry up the discount is valid till 3 December.

  • 31/12/2023 New Year SALE

    We are glad to announce New Year SALE. 25% discount for all our extensions. Use NY24 coupon code. Hurry up the discount is valid till 7 January.


2Checkout.com, Inc. is an authorized retailer of goods and services provided by ARI Soft. 2CheckOut




Follow us on twitter



Welcome, Guest
Please Login or Register.    Lost Password?

Is it possible to filter on multiple columns
(1 viewing) (1) Guest
Go to bottomPage: 123
TOPIC: Is it possible to filter on multiple columns
#44401
Is it possible to filter on multiple columns 11 Years, 2 Months ago Karma: 0
Hi,

I need to be able to filter my table using more than one column, is this possible?

For example I might want to filter by Country in one column then apply a further filter of Male or Female for the second column, then by Age Range for the third, so that ultimately I end up with a list that just meets that criteria. I need to be able to do this on the front end (or at least my users do).

Is there a way of achieving this with Ari Data Tables? I also have smart content.

Kind regards
The administrator has disabled public write access.
 
#44404
Re:Is it possible to filter on multiple columns 11 Years, 2 Months ago Karma: 760
Hello,

"ARI Data Tables" supports ability to use request variables in "WHERE" clause of "SELECT" SQL query so it is possible to create a HTML form with search parameter outside the module and send search parameter to the module. Request variables are used in the following way:

{$REQUEST:VAR_NAME}

Where VAR_NAME is a name of request variable.

Regards,
ARI Soft
The administrator has disabled public write access.
 
#44406
Re:Is it possible to filter on multiple columns 11 Years, 2 Months ago Karma: 0
Hi,
thank you for responding. I am not sure where to start with that. This is basically all I am after:

jquery-datatables-column-filter.googlecode.com/svn/trunk/default.html

and a similar question was asked in this thread with an answer that might suit me, however i am not sure how I go about adding a basic call as the admin mentioned in that thread. www.ari-soft.com/ARI-Data-Tables/18943-DataTables-individual-column-filtering/Page-2.html
Is there a step by step guide anywhere which will show me how make my aridata table work like that? It would be perfect
The administrator has disabled public write access.
 
#44407
Re:Is it possible to filter on multiple columns 11 Years, 2 Months ago Karma: 760
It requires custom modification of the extension and it will not work if "Server side pagination" is used.

Regards,
ARI Soft
The administrator has disabled public write access.
 
#44408
Re:Is it possible to filter on multiple columns 11 Years, 2 Months ago Karma: 0
I am sorry, I don't quite understand. Does this mean that ari data tables can't do this kind of filter? It is a shame as it is otherwise perfect.
The administrator has disabled public write access.
 
#44409
Re:Is it possible to filter on multiple columns 11 Years, 2 Months ago Karma: 760
If you want to add addon for DataTable jQuery plugin, it requires to modify "ARI Data Tables" code and it will not work if "Server side pagination" parameter is set to "Yes" in module settings.

Regards,
ARI Soft
The administrator has disabled public write access.
 
Go to topPage: 123