Sorting by DISTINCT field values ...
I have a few comments/questions.
1) I belong to the forum but can't see any buttons that allow me to post questions. How do I do that?
2) I would like to be able to enter SQL queries that would run against my library. Is there any way to do that?
For example, I have a library called 'Tiffany Lamp Flowers' that has a field called "Flower Type" and that field can contain duplicate entries. I want to return only the DISTINCT values when running a sort. So, in essence, I want to run the following SQL query:
SELECT DISTINCT "Flower Type" FROM "Tiffany Lamp Flowers"
To get only the unique Flower values entered. I can setup the SORT to show the existing records in sorted order but I can't ask for sorted DISTINCT records. I think that would be a useful addition to the SORT and/or FILTER dialog(s).
A more useful option would be to provide some type of SQL entry capability so users can run their own queries when needed.
Maybe I could do this with the reporting system but I generally run Memento on my Android phone and I don't believe there's a reporting option. If I'mjust missing it, could you please let me know how I can do this on Android? And how this would be done using Memento on Win10.
Appreciate any help you can provide.