Welcome, Guest
Username: Password: Remember me
This is the optional Forum header for the Suggestion Box.

TOPIC: Filter

Filter 4 years 10 months ago #199

  • signaal
  • signaal's Avatar
  • OFFLINE
  • Fresh Boarder
  • Posts: 4
  • 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
The administrator has disabled public write access.

Re:Filter 4 years 10 months ago #201

  • tomaz
  • tomaz's Avatar
  • OFFLINE
  • Administrator
  • Posts: 730
  • Thank you received: 50
  • Karma: 8
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┼ż
How about posting a review on JED? Table JX, Card View JX, Paid Downloads JX
Last Edit: 4 years 10 months ago by tomaz.
The administrator has disabled public write access.

Re:Filter 4 years 10 months ago #203

  • signaal
  • signaal's Avatar
  • OFFLINE
  • Fresh Boarder
  • Posts: 4
  • 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..
The administrator has disabled public write access.

Re:Filter 4 years 10 months ago #206

  • Bostjan
  • Bostjan's Avatar
  • OFFLINE
  • Senior Boarder
  • Posts: 45
  • 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
The administrator has disabled public write access.

Re:Filter 4 years 5 months ago #512

  • greenkoi
  • greenkoi's Avatar
  • OFFLINE
  • Fresh Boarder
  • Posts: 8
  • Karma: 0
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
The administrator has disabled public write access.

Re:Filter 4 years 5 months ago #513

  • signaal
  • signaal's Avatar
  • OFFLINE
  • Fresh Boarder
  • Posts: 4
  • Karma: 0
hi.. just give me your e-mail and i will send you the full .php
The administrator has disabled public write access.
Time to create page: 0.169 seconds