WAB filter widget - strings w/ special characters

89
0
05-14-2019 09:33 AM
JimmyKnowles
Occasional Contributor II

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

0 Kudos
0 Replies