unique values from tiggzi database to populate selection list?

[Sean Kelley]

I have a tiggzi database which has duplicate values in field
CA
OR
OR
TX
which I would like to use to populate a selection list. Seems like I should be able to run a query on the database for unique values of the field but I did not see that type of option in query doc page.
http://docs.tiggzi.com/documentation/...

How do I get this list?

[Maryna Brodina]

Hello! There is no way to do that using query. As a workaround you could use JS to filter results you get and form the select.

[Sean Kelley]

thanks- its seems like that this would be valuable to add to database query capability because to return the entire result of the database to build menu would be quite expensive

[Maryna Brodina]

Hi, I've reported about this problem. We'll add this possibility.

[Sean Kelley]

thank you

[Nate Snyder]

Hello, Marina. I'm trying to do the same thing as Sean mentioned above. Has there been any progress on adding the ability to only query unique values? If not, do you have any suggestions or links for what the JS might look like?

[maxkatz]

http://docs.appery.io/documentation/b...