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

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ž

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

Nice solution, Signaal

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

Regards,
Bostjan

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

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