Web AppBuilder Query Widget Wildcard

Question

Hi,

I have configured a Web Mapping Application using Web AppBuilder. I would like to define a multi-attribute query where the user can use an existing value but with the possibility to use a wildcard for some of the attributes.From the test I did with the Query Widget, I cannot find a way of doing this pretty basic query.

Did anyone was successful doing something similar?

Thank you,

Line Champagne

RobertScheitlin__GISP · Answer

Larry,

Yep, Thanks for catching that. I have fixed my post.

LarryStout · Answer

Robert,

I think you got the "Starts With" and "Ends With" reversed.

Larry

RobertScheitlin__GISP · Answer

Olivia,

The option "Contains" looks like this in SQL "YourField like %[value]%"

The Option "Ends With" looks like this "YourField like %[value]"

The Option "Starts With" looks like this "YourField like [value]%"

So one of these should work for you as all three use wildcards.