1
ThumbsPlus v7-v9 Questions / Re: ThumbsPlus 7 - List of all user defined field entries
« on: 2019-08-08 07:36:57 »
Thanks for the suggestion to view the database directly. This indeed worked fine.
In our case we have a MySQL database and I used HeidiSQL to view the entries and some MySQL magic to extract the user field entries.
The SQL command to get each entry of a user defined field once and in ascending order is:
SELECT DISTINCT uf_keyword FROM UserFields ORDER BY uf_keyword ASC,
where _keyword is the actual name of your user defined field.
Just in case anyone else has this problem .
In our case we have a MySQL database and I used HeidiSQL to view the entries and some MySQL magic to extract the user field entries.
The SQL command to get each entry of a user defined field once and in ascending order is:
SELECT DISTINCT uf_keyword FROM UserFields ORDER BY uf_keyword ASC,
where _keyword is the actual name of your user defined field.
Just in case anyone else has this problem .