https://antibiotiqueaugmentin.com/surdosage-augmentin-bebe/

Unique Value Filter in Tools JX

  • ScubaGuy
  • ScubaGuy's Avatar Topic Author
  • Offline
  • New Member
  • New Member
More
7 years 11 months ago #3535

Hi there,
This is likely a stupid question, but is it possible to show unique values if there are several lines with identical identifiers? What I mean is: I have a table for which I'm not showing all information, so several lines are shown with the same exact values (because the column with the different values isn't shown). What I'd like to see is that the lines with the same data show only once.
Is there a setting for this?
Thanks in advance!
Regards, Roger

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

More
7 years 10 months ago #3536

Hi,

there is not a direct setting like this in Tools JX. However you can create a database view with CREATE VIEW and SELECT DISTINCT, and than use this view with Table JX.

toolsjx.com/faq/3-how-to-create-a-databa...use-it-with-tools-jx

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

Moderators: tomaz
Time to create page: 0.148 seconds

Contact Us

Contact us on Discord

Contact us on Facebook