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

Filter
(1 viewing) (1) Guest
This is the optional Forum header for the Suggestion Box.
Go to bottom
Post Reply
Post New Topic
Page: 123
TOPIC: Filter
#199
Filter 2 Years 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
Enter code here   
Please note: although no board code and smiley buttons are shown, they are still usable.
signaal
Fresh Boarder
Posts: 4
graphgraph
User Offline Click here to see the profile of this user
Reply Quote
 
#201
Re:Filter 2 Years ago Karma: 5
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ž
Enter code here   
Please note: although no board code and smiley buttons are shown, they are still usable.
tomaz
Moderator
Posts: 282
graph
User Offline Click here to see the profile of this user
Last Edit: 2010/01/23 06:19 By tomaz.
Reply Quote
 
#203
Re:Filter 2 Years 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..
Enter code here   
Please note: although no board code and smiley buttons are shown, they are still usable.
signaal
Fresh Boarder
Posts: 4
graphgraph
User Offline Click here to see the profile of this user
Reply Quote
 
#206
Re:Filter 2 Years 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
Enter code here   
Please note: although no board code and smiley buttons are shown, they are still usable.
Bostjan
Senior Boarder
Posts: 46
graphgraph
User Offline Click here to see the profile of this user
Reply Quote
 
#512
Re:Filter 1 Year, 8 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
Enter code here   
Please note: although no board code and smiley buttons are shown, they are still usable.
greenkoi
Fresh Boarder
Posts: 8
graphgraph
User Offline Click here to see the profile of this user
Reply Quote
 
#513
Re:Filter 1 Year, 8 Months ago Karma: 1
hi.. just give me your e-mail and i will send you the full .php
Enter code here   
Please note: although no board code and smiley buttons are shown, they are still usable.
signaal
Fresh Boarder
Posts: 4
graphgraph
User Offline Click here to see the profile of this user
Reply Quote
 
Go to top
Post Reply
Post New Topic
Page: 123
Tools JX
Table JX
Suggestions
Moderators: tomaz
Powered by Kunenaget the latest posts directly to your desktop
Tools JX, Powered by Joomla!; Joomla templates by SG web hosting