Filter - Kunena

Welcome, Guest
Please Login or Register. Lost Password?

Filter

(1 viewing) (1) Guest

This is the optional Forum header for the Suggestion Box.

Page: 1

TOPIC: Filter

Forum Tools

#199

Filter 1 Month, 2 Weeks ago	Karma: 0
Hi, I am a new user and like the way TableJX is working.. super! I am using it to pull the companyname and webaddress out of the contact-detail database. I like to know if there is a possibility to filter duplicated companynames and also that only published recordes are being showed... It would be a great item if so... thanks

signaal

Fresh Boarder

Posts: 2

The administrator has disabled public write access.

#201

Re:Filter 1 Month, 2 Weeks ago	Karma: 0
Hi, To show only published, you can use additional where condition in advanced section. You should write something like: my_published_field = '1' For filtering duplicated names it would be the easiest way to create a view in your database with select distinct, and then display a view on your page. Regards, Tomaž

tomaz

Senior Boarder

Posts: 45

Last Edit: 2010/01/23 06:19 By tomaz.

The administrator has disabled public write access.

#203

Re:Filter 1 Month, 2 Weeks ago	Karma: 0
Hi Tomaz, thanks for the tip and quick repsons.. i found a usefull workaround for anyone and maybe for a newer version? Just alterd in the file "GridBuilder.php" on line 205 $query = "SELECT DISTINCT ".$this->colList; and it works like a charme..

signaal

Fresh Boarder

Posts: 2

The administrator has disabled public write access.

#206

Re:Filter 1 Month, 1 Week ago	Karma: 0
Nice solution, Signaal You may also consider first creating a view in your database and then displaying a view with TableJX... Regards, Bostjan

Bostjan

Senior Boarder

Posts: 41

The administrator has disabled public write access.

Page: 1