× This is the optional Forum header for the Suggestion Box.

Filter

signaal
Topic Author
Offline
New Member

14 years 3 months ago #199

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

Please Log in or Create an account to join the conversation.

tomaz
Offline
Administrator

14 years 3 months ago #201

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ž

Last edit: 14 years 3 months ago by tomaz.

Please Log in or Create an account to join the conversation.

signaal
Topic Author
Offline
New Member

14 years 3 months ago #203

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..

Please Log in or Create an account to join the conversation.

Bostjan
Offline
Administrator

14 years 3 months ago #206

Nice solution, Signaal :-)

You may also consider first creating a view in your database and then displaying a view with TableJX...

Regards,
Bostjan

Please Log in or Create an account to join the conversation.

greenkoi
Offline
New Member

13 years 11 months ago #512

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

Please Log in or Create an account to join the conversation.

signaal
Topic Author
Offline
New Member

13 years 11 months ago #513

hi.. just give me your e-mail and i will send you the full .php

Please Log in or Create an account to join the conversation.

Moderators: tomaz

Time to create page: 0.204 seconds

Filter

Contact Us

Contact us on Discord

Contact us on Facebook