Trying to use the WAB filter widget for strings that begin with a space or a tab. I tried several different ways of doing this and none worked. Things I tried
- space in single quotes ' '
- space in double quotes " "
- %20
- %20 in single quotes
- %20 in double quotes
I know this is possible because I can use the REST API to query for strings that begin with a space, but could not find a way to do this in the filter widget. Any ideas? This sounds like something that could be implemented pretty easily.
Using a URL, for finding records that begin with a space, I use the following where clause
where=survey_key%20LIKE%20%27%20%25%27
When I use the query web form at the REST endpoint, I use the following for my where clause
survey_key LIKE ' %'
When I hit the Query (GET) button, the URL has the following where clause
where=survey_key+LIKE+%27+%25%27