AndrewW.50890 (AppFolio) asked a question.
I am trying to use a workflow to audit values in a workflow table (specifically checking to see where there is no email listed in a specific column). To do this, I assume the easiest way is to search the table with criteria of email = "".
To do this, I have attempted to leave the corresponding value empty, use "", and use NULL. All of which have failed for various reasons. When I used "" and NULL, it would actually search for those values on the list, thus returning nothing. When I leave the value empty, I get the error "HTTP Error: Invalid value for search query: the 'userEmail' input is an empty string"
I also on a whim attempted to use a compose tile to just raw input the NULL value in the request (without quotes), but ended up with an Invalid Input error.
Is there a better way to do thi
Unfortunately, I haven't found it possible to use the Search Expression within the Search Rows card to find blank/null values.
It's a bit hacky, but you could return all the rows, then use a List - Filter card... set the path to the column name you're checking for blank values (userEmail in this case), and set the operator to is empty.
Hope this helps,
Bryan
I also need a != Null or "is not blank" option to filter out rows where that particular field isn't defined, so as a workaround ended up using >= !
When I returned multiple results and sorted alphabetically ! was returned before letters or numbers. I didn't specifically test against whitespace or empty strings, so you may want to do further testing depending upon your needs.
>= ! for non-blank rows
< ! for blank rows