Question about search. How can I search for d...

(Michael Serafini) #1

Question about search. How can I search for data in Yes/No Columns?

I’ve made the column searchable. The goal is to find all rows that have False in the PAID column.

Thanks in advance

Michael

(Steven Coile) #2

The Searchable option determines whether the column content is searchable from the search bar in the user interface. The phrasing of your question suggests you’re interested in searching from an expression instead. To search from an expression…

This will return a List containing the values of the [DesiredColumn] in MyTable for rows where [PAID] is TRUE:

select(MyTable[DesiredColumn], ([PAID] = true))

Since [PAID] is a Yes/No column, you can simplify the above slightly:

select(MyTable[DesiredColumn], [PAID])

(Michael Serafini) #3

Thanks.

I found using a slice then adding to a UX as a button at the bottom works great.

(Steven Coile) #4

The Searchable option determines whether the column content is searchable from the search bar in the user interface. The phrasing of your question suggests you’re interested in searching from an expression instead. To search from an expression…

This will return a List containing the values of the [DesiredColumn] in MyTable for rows where [PAID] is TRUE:

select(MyTable[DesiredColumn], ([PAID] = true))

Since [PAID] is a Yes/No column, you can simplify the above slightly:

select(MyTable[DesiredColumn], [PAID])

(Michael Serafini) #5

Thanks.

I found using a slice then adding to a UX as a button at the bottom works great.