Get Items Filter Query for null Note

[enswitzer]

Is there a way to get around this? I'd like to filter for anything that has a null objective field:

[tom_riha · Accepted solution]

Hello @enswitzer ,

the Filter Query won't allow you to use some column types, e.g. multiple lines of text columns (as the error message says). You'll need to split the filtering into 2 parts:

1. Filter Query in 'Get items' to check the columns that can be used in Filter Query
2. 'Filter array' after the 'Get items', take the output array from 'Get items' and filter it again using the remaining columns