Page 1 of 1
unique values from tiggzi database to populate selection list?
Posted: Mon Feb 18, 2013 7:22 pm
by 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?
unique values from tiggzi database to populate selection list?
Posted: Mon Feb 18, 2013 7:59 pm
by 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.
unique values from tiggzi database to populate selection list?
Posted: Mon Feb 18, 2013 8:37 pm
by 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
unique values from tiggzi database to populate selection list?
Posted: Tue Feb 19, 2013 4:42 pm
by Maryna Brodina
Hi, I've reported about this problem. We'll add this possibility.
unique values from tiggzi database to populate selection list?
Posted: Tue Feb 19, 2013 4:50 pm
by Sean Kelley
thank you 
unique values from tiggzi database to populate selection list?
Posted: Wed May 15, 2013 8:08 pm
by 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?
unique values from tiggzi database to populate selection list?
Posted: Wed May 15, 2013 8:23 pm
by maxkatz