topic Re: Erroneous results produced by 'Query widget' in ArcGIS Online Questions

Erroneous results produced by 'Query widget'

SimonCrutchley — Thu, 20 May 2021 16:11:35 GMT

I am using Portal 10.8 and Web App builder to create a simple app for viewing and accessing heritage data. One query I need to run relates to the period of the various features, many of which are multiple e.g. BRONZE AGE\IRON AGE\ROMAN. I have tried using the filter with 'CONTAINS' and multiple defined options (see attached 1 & 2). When I select BRONZE AGE the query correctly finds those features that include BRONZE AGE, but when I select ROMAN, the query finds almost all the records (attached 3), although there are only 5 ROMAN records.

Using a single search and entering ROMAN as a defined entry, finds the correct 5 records (attached 4).

Can anyone think why this might be happening, and what I can do to resolve it?

Thanks

Re: Erroneous results produced by 'Query widget'

jcarlson — Thu, 20 May 2021 17:40:14 GMT

It's hard to know what's going on without seeing the full details. Can you get the query widget to display the actual SQL that's being sent to the service? From the first picture, it looks like there's a "contains" and a "does not contain" statement in the same query?

Re: Erroneous results produced by 'Query widget'

SimonCrutchley — Fri, 21 May 2021 08:34:13 GMT

Is that better? Sorry I tend to turn off the SQL, so as not to confuse my users.

As you can see it's looking for %ROMAN%, but for some reason finding it in 'BRONZE AGE\IRON AGE'.

It may, or may not be relevant, but elsewhere I'm using the standard abbreviations to link to other URLs, and for ROMAN the abbreviation is RO, which does occur in both IRON and BRONZE. However, as I say, this is a totally separate field which is not being queried.

I'm stumped.

As far as the 'contain', 'doesn't contain' goes, this is because two of the PERIODs are 'MEDIEVAL' and 'POST MEDIEVAL', so I figure if you want to find just MEDIEVAL, and not also POST MEDIEVAL, you need to search contains 'MEDIEVAL', but doesn't contain 'POST MEDIEVAL'. happy to know if there's a better way when dealing with multiple entries like 'BRONZE AGE\IRON AGE\ROMAN\MEDIEVAL'.

Cheers

Re: Erroneous results produced by 'Query widget'

jcarlson — Fri, 21 May 2021 14:13:53 GMT

I've been puzzling this one out for a while and still can't quite understand what might be going on here. Any chance this web app is public? Being able to fiddle around with it might help.

Re: Erroneous results produced by 'Query widget'

SimonCrutchley — Fri, 21 May 2021 14:41:44 GMT

Hi Josh,

This is a sample of data, so I guess I could make another copy, to see what's going wrong.

https://englishheritage.maps.arcgis.com/home/item.html?id=fcfdf176f1fb438c93b16ae86ba58f4d

Does this link work?

Re: Erroneous results produced by 'Query widget'

jcarlson — Fri, 21 May 2021 15:46:30 GMT

It does not, it prompts me to sign into your org.

Re: Erroneous results produced by 'Query widget'

SimonCrutchley — Fri, 21 May 2021 15:56:59 GMT

Hmm. I'm not sure how I can get it out of my work account. I'll look at this next week, though that's looking very busy, so we'll have to see.

Thanks for looking at this.

Re: Erroneous results produced by 'Query widget'

SimonCrutchley — Mon, 24 May 2021 08:50:19 GMT

Hi Josh,

I don't seem to have permissions to use Web AppBuilder on my personal account, so can't share that. I could share the underlying map and data, and you could try to replicate the error using the screen shots I sent, if that's possible?

Re: Erroneous results produced by 'Query widget'

jcarlson — Mon, 24 May 2021 15:05:37 GMT

I could certainly give it a try!

Re: Erroneous results produced by 'Query widget'

SimonCrutchley — Tue, 25 May 2021 09:52:02 GMT

Hi Josh,

This seems determined not to work. I've got the 'map' in, but the layer won't read as a 'feature layer' and the map isn't picking up the shapefile. I'll keep trying.

Sorry

Re: Erroneous results produced by 'Query widget'

SimonCrutchley — Wed, 02 Jun 2021 13:14:13 GMT

As noted before, this is data that is meant for the public domain in the long term, so I'm wondering whether I might share the shapefile and get you to load it and build the query? I realise that's asking rather a lot, but I just don't seem to be able to add feature layers with my personal account, and we've already established that you can't access my work account, even when shared with the world. What do you say? Thanks

Re: Erroneous results produced by 'Query widget'

jcarlson — Wed, 02 Jun 2021 13:24:10 GMT

Go ahead and send it, I'll see what I can do.

Re: Erroneous results produced by 'Query widget'

SimonCrutchley — Wed, 02 Jun 2021 13:25:47 GMT

Thanks very much. Let me know if anything doesn't make sense.