topic Re: Web AppBuilder Query Widget Wildcard in ArcGIS Web AppBuilder Questions

Web AppBuilder Query Widget Wildcard

Anonymous User — Wed, 11 Mar 2015 17:49:43 GMT

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

Re: Web AppBuilder Query Widget Wildcard

StanMcShinsky — Thu, 12 Mar 2015 02:24:43 GMT

Line Champagne,

When you set up the query widget you have the option to create a filter expression. When you do that you can have the expression be a "contains". This acts like a wild card and looks for anything in that search that has the input value as part of the result. I hope this helps.

-Stan

Re: Web AppBuilder Query Widget Wildcard

OliviaDeSimone — Mon, 17 Aug 2015 15:46:26 GMT

I am having the same issue. "Contains" does not work for in my case because I expect my users will be searching the layer using leading zeros which are not included in the layer's attribute records.

Is there any way to use wildcard in the current Web App Builder query widget? My organization is able to do so with our Flex applications, but we want to move away from that since Flex isn't going to be supported for much longer.

Re: Web AppBuilder Query Widget Wildcard

RobertScheitlin__GISP — Mon, 17 Aug 2015 15:51:45 GMT

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.

Re: Web AppBuilder Query Widget Wildcard

LarryStout — Tue, 18 Aug 2015 18:00:36 GMT

Robert,

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

Larry

Re: Web AppBuilder Query Widget Wildcard

RobertScheitlin__GISP — Tue, 18 Aug 2015 18:06:10 GMT

Larry,

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