https://antibiotiqueaugmentin.com/surdosage-augmentin-bebe/
× This is the optional Forum header for the Suggestion Box.

only display unique records (DISTINCT)?

  • markusbohu
  • markusbohu's Avatar Topic Author
  • Offline
  • New Member
  • New Member
More
10 years 1 week ago #3038

Is there any way to instruct the table display to only display unique records? Basically adding the word "DISTINCT" right after the SELECT statement?

Adding it into the field for the "WHERE" statement obviously does not work, as it adds it in the wrong place in the SQL statement.

Thanks,
Markus

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

More
10 years 4 days ago #3041

Hi

Look at the /components/com_grid/GridBuilder.php file. This is where the sql statement is generated.

The following user(s) said Thank You: markusbohu

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

Moderators: tomaz
Time to create page: 0.139 seconds

Contact Us

Contact us on Discord

Contact us on Facebook