ARI Soft - DataTable with a search/selection per column?

Home

News

Forum

About Us

Demos

Products

F.A.Q.

Featured Demos

ARI Smart Content demo

ARI Quiz demo

WordPress Quiz plugin

WordPress Lightbox plugin

e-mail: info@ari-soft.com

Shopping Cart

You currently have 0 items in your cart.

Show Cart

Recent Events

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.

more...
21/11/2023 BLACK FRIDAY 23 is coming

BIG SALE, 35% discount for all our extensions. Use BF23 coupon code. Hurry up the discount is valid till 27 November.

more...

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

Welcome, Guest
Please Login or Register. Lost Password?

ARI Soft Forum

Joomla components

ARI Smart Content

DataTable with a search/selection per column?

(1 viewing) (1) Guest

Page: 1

TOPIC: DataTable with a search/selection per column?

Forum Tools

#62268

DataTable with a search/selection per column? 6 Years, 10 Months ago

Karma: 0

Dear all,

I'm very happy with all my solutions based on ARI Smart Content. My standard case is to display different views of an annual programme of clubs! The search function across all (permitted) fields is very attractive. But now I have the need to search per column (and not as a whole) to select existing values depending on other values in supported columns.

Is there any solution available for such a select like:
- column 1: job title; search with a part of the text
- column 2: category; selection out of the list of existing categories
- column 3: region; selection out of the list of used regions
- and more like 2 and 3.

Thanks for any hint to solve this challenge.

Best regards,
Heinz

HeinzP

Don't believe everything you think!

The administrator has disabled public write access.

#62285

Re:DataTable with a search/selection per column? 6 Years, 10 Months ago Karma: 760

Hello,

It is only possible if create a search form outside "ARI Smart Data - DataTable" module and use request variables (from the search form) in SQL query. Something like this:

Code:



<form action="">

 Job title: <input type="text" name="job_search" />

 <br />

 <input type="submit" value="Search" />

</form>

... DataTable module goes here ...

and SQL query will look like:

Code:



SELECT

 id,

 job_title

FROM

 tbl

WHERE

 job_title LIKE CONCAT({$REQUEST:job_search},'%')

Regards,
ARI Soft

admin

The administrator has disabled public write access.

#62293

Re:DataTable with a search/selection per column? 6 Years, 10 Months ago	Karma: 0
Thank you very much for your advice! Have a nice day Heinz

HeinzP

Don't believe everything you think!

The administrator has disabled public write access.

Page: 1

Useful Links