topic Unique Value Error - Esearch in Web AppBuilder Custom Widgets Questions

Unique Value Error - Esearch

MelissaMeneghetti — Mon, 26 Oct 2015 20:39:54 GMT

Hi Robert,

I am not sure if this may be a bug in the widget but when I try and access the unique values for a data layer that has many unique values present (i.e. over 100), in the 'Add Expression' dialogue the window just seems to spin on the 'Retrieving unique values' (see attached print screen). Have you encountered any other problems with this or is the number of unique values present a problem? Thanks

Re: Unique Value Error - Esearch

RobertScheitlin__GISP — Mon, 26 Oct 2015 20:43:40 GMT

Melissa,

Could you post again with the developer tools on the console tab (instead of the network tab)?

Re: Unique Value Error - Esearch

MelissaMeneghetti — Mon, 26 Oct 2015 20:52:18 GMT

Ok just reposted with a different screen shot:)

Re: Unique Value Error - Esearch

RobertScheitlin__GISP — Mon, 26 Oct 2015 20:57:52 GMT

OK,
that helps. Can you attach your config_Enhanced Search.json file?

Re: Unique Value Error - Esearch

MelissaMeneghetti — Mon, 26 Oct 2015 21:12:59 GMT

Ok done..but for some reason, when I access the config.json under the server apps (i.e. C:\WAB\arcgis-web-appbuilder-1.2\arcgis-web-appbuilder-1.2\server\apps\2\widgets\eSearch), the config file seems to show only the layers that were downloaded with the esearch zip file...it doesn't seem to be updated with my data layers?

Re: Unique Value Error - Esearch

RobertScheitlin__GISP — Mon, 26 Oct 2015 21:15:30 GMT

Melissa,

That is because that file is not the one that is updated and used by the widget you will find the one that I need is located here: C:\WAB\arcgis-web-appbuilder-1.2\arcgis-web-appbuilder-1.2\server\apps\2\configs\eSearch\config_Enhanced Search.json

Re: Unique Value Error - Esearch

MelissaMeneghetti — Mon, 26 Oct 2015 21:21:36 GMT

Thanks Robert that makes better sense...I have attached the file!

Re: Unique Value Error - Esearch

RobertScheitlin__GISP — Mon, 26 Oct 2015 21:32:28 GMT

Melissa,

Have updated my help documentation to help people understand that using "definitionexpression": "1=1", is not necessary and will cause issues. Remove 1=1 from the definition expression field in the widgets UI for all your layers.

Web AppBuilder for ArcGIS | Help - Enhanced Search widget | Definition Expression

Re: Unique Value Error - Esearch

MelissaMeneghetti — Mon, 26 Oct 2015 21:44:04 GMT

Ok I removed it (see attached) but it still spins with the 'Retrieving Unique Values'.

Re: Unique Value Error - Esearch

RobertScheitlin__GISP — Mon, 26 Oct 2015 22:34:42 GMT

Melissa,

This is the query that is being sent to your service and it is failing.

http://www.mapservices.ca:6080/arcgis/rest/services/Fairwinds/Base_Data/MapServer/3/query?where=1%3D1&text=&objectIds=&t…

So I did some testing using a small integer field with one of my map services and it work fine with almost identical query parameters.

I am concerned about the use of "Unique" as a field name in your data (as that would seem to be a reserved keyword in many databases). I would suggest a test by renaming or recreating the field in your data with a underscore (i.e. _unique) or some other more meaningful name and re-testing.

Re: Unique Value Error - Esearch

MelissaMeneghetti — Tue, 27 Oct 2015 16:04:55 GMT

Thanks Robert for the suggestion. I did what you suggested and called the field 'Pipe_ID'. I tested again and unfortunately it is still getting hung up on the unique values (just spins repeatedly). I tried this on another computer using another dataset with more than 100 records and get the same thing. I am using esearch version 1.2.0.3. Any other suggestions?

Re: Unique Value Error - Esearch

RobertScheitlin__GISP — Tue, 27 Oct 2015 16:19:30 GMT

Melissa,

OK, now I see the issue is you are still using ArcGIS Server 10.11. My code is using orderByFields parameter in the query and there is a bug in ArcGIS Server 10.11 with this. I would have to re-code some to check for old versions of server like this and if found not use the orderByFields parameter.

Re: Unique Value Error - Esearch

RobertScheitlin__GISP — Tue, 27 Oct 2015 16:29:53 GMT

Melissa,

It is actually a one line fix in the code. If you open your apps [install dir]\\server\apps\[app #]\widgets\eSearch\PaginingQueryTask.js file and find these lines:

if (this.version >= 10.1) {

this.query.orderByFields = [this.fieldName];

}

And change it to:

if (this.version > 10.11) {

this.query.orderByFields = [this.fieldName];

}

You will be in business

Re: Unique Value Error - Esearch

MelissaMeneghetti — Tue, 27 Oct 2015 16:55:34 GMT

Robert you are a wizard...this worked like a charm!! Thank you so much for working this out for me.