So you want to narrow down the results when querying data in Ninox?
There are two ways you can achieve this, either using the word “where” followed by your criteria, or you can put your criteria within square brackets.
Personally, I like to use square brackets as it looks clearer, plus you can use this concept when filtering values in directly linked subtables in addition to when using select queries.
Something else to note, you must extract the values you want to query into variables before including them within your query line.
Example
In this example, you have a table called “Orders”. Each order is linked to a “Customer” (a separate table). Every order has a status choice field with options 1: Draft, 2: Processing and 3: Completed options.
In this example, we want to only show Completed orders for Customer #25.
select Orders[Customer = 25 and Status = 3]as mentioned above, you could also write it as follows:
select Orders where Customer = 25 and Status = 3
Recent Comments