Welcome, Guest
Please Login or Register.    Lost Password?
Kunena
Table JX
Suggestions

Filter
(1 viewing) (1) Guest
This is the optional Forum header for the Suggestion Box.
Go to bottomPage: 123
TOPIC: Filter
#199
Filter 6 Months, 1 Week ago Karma: 1
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: 4
graphgraph
User Offline Click here to see the profile of this user
The administrator has disabled public write access.
 
#201
Re:Filter 6 Months, 1 Week ago Karma: 1
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
Expert Boarder
Posts: 82
graphgraph
User Offline Click here to see the profile of this user
Last Edit: 2010/01/23 06:19 By tomaz.
The administrator has disabled public write access.
 
#203
Re:Filter 6 Months, 1 Week ago Karma: 1
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: 4
graphgraph
User Offline Click here to see the profile of this user
The administrator has disabled public write access.
 
#206
Re:Filter 6 Months 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: 45
graphgraph
User Offline Click here to see the profile of this user
The administrator has disabled public write access.
 
#512
Re:Filter 2 Months ago Karma: 1
Hi -

Could you elaborate - and maybe provide a fuller example of what you edited?

I'm trying to get a filter applied, and editing the GridBuilder.php with WHERE statements isn't working for me.

Thanks in advance,

mm
greenkoi
Fresh Boarder
Posts: 8
graphgraph
User Offline Click here to see the profile of this user
The administrator has disabled public write access.
 
#513
Re:Filter 2 Months ago Karma: 1
hi.. just give me your e-mail and i will send you the full .php
signaal
Fresh Boarder
Posts: 4
graphgraph
User Offline Click here to see the profile of this user
The administrator has disabled public write access.
 
Go to topPage: 123
Kunena
Table JX
Suggestions
Powered by Kunenaget the latest posts directly to your desktop
Tools JX, Powered by Joomla!; Joomla templates by SG web hosting