foto1
Make it simple to transparently display data on a website. Tools JX is a set of database reporting tools for Joomla! All of them are made to be very intuitive and as simple to use as possible.
foto1
Paid Downloads is a solution for you! It is a lightweight and simple-to-use extension, that makes your e-commerce simple and manageable. It uses PayPal's service to execute transactions.


Tools JX

Joomla plugins


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

Filter

  • signaal
  • signaal's Avatar Topic Author
  • Offline
  • Fresh Boarder
  • Fresh Boarder
More
7 years 1 day ago #199 by signaal
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.

More
7 years 1 day ago - 7 years 1 day ago #201 by tomaz
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: 7 years 1 day ago by tomaz.

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

  • signaal
  • signaal's Avatar Topic Author
  • Offline
  • Fresh Boarder
  • Fresh Boarder
More
7 years 13 hours ago #203 by signaal
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.

More
6 years 11 months ago #206 by Bostjan
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.

More
6 years 7 months ago #512 by greenkoi
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
  • signaal's Avatar Topic Author
  • Offline
  • Fresh Boarder
  • Fresh Boarder
More
6 years 7 months ago #513 by signaal
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.180 seconds