topic Re: How to filter data on arcgis layer in Javascript in ArcGIS Server with JavaScript API Questions

How to filter data on arcgis layer in Javascript

KamalMittal — Wed, 07 Jun 2017 03:24:59 GMT

Hi,

I want to filter data on feature layer when user select value from dropdown.

On my feature layer, I have showed 25 locations with a pin symbol and there is dropdown which contains all these 25 locations. Now what I want is when user select value from dropdown then map will show and zoomin that location only and rest of the locations will disappear. So how do I achieve that?

Thanks,

Kamal

Re: How to filter data on arcgis layer in Javascript

RobertScheitlin__GISP — Wed, 07 Jun 2017 13:47:57 GMT

Kamal,

When the user selects from the dropdown you apply a definitionexpression to the layer.

https://developers.arcgis.com/javascript/3/jsapi/featurelayer-amd.html#setdefinitionexpression

Re: How to filter data on arcgis layer in Javascript

KamalMittal — Thu, 08 Jun 2017 13:51:02 GMT

Thanks Robert for your reply.

Here setDefinitionExpression taking exact data to search but I want to search based on substring. Can we achieve that thing?

Thanks,

Kamal

Re: How to filter data on arcgis layer in Javascript

RobertScheitlin__GISP — Thu, 08 Jun 2017 14:09:38 GMT

Kamal,

Not sure what you mean. If the user selects an item from the drop down do you not know the exact value?...

Re: How to filter data on arcgis layer in Javascript

KamalMittal — Thu, 08 Jun 2017 15:22:59 GMT

Yes, with dropdown there is also textbox for searching. When user type into textbox then I want to search from textbox value also.

Thanks,

Kamal

Re: How to filter data on arcgis layer in Javascript

RobertScheitlin__GISP — Thu, 08 Jun 2017 15:28:35 GMT

Kamal,

Then you just formulate your SQL String for the defintion expression from the textbox input (i.e. "field1 LIKE '%" + textbox.value + "'")

Re: How to filter data on arcgis layer in Javascript

KamalMittal — Thu, 08 Jun 2017 16:08:31 GMT

Thanks Robert. Below is the code which i am using but searching is not working:

featureLayer.setDefinitionExpression("street_name LIKE % 'ORCHARD'");

Here street_name is field and ORCHARD is the textbox value.

Can you please confirm that is SQL string is correct ?

Thanks,

Kamal

Re: How to filter data on arcgis layer in Javascript

RobertScheitlin__GISP — Thu, 08 Jun 2017 16:20:56 GMT

Kamal,

No the correct code would be:

featureLayer.setDefinitionExpression("street_name LIKE '%ORCHARD%'");

Re: How to filter data on arcgis layer in Javascript

KamalMittal — Fri, 16 Jun 2017 02:27:56 GMT

Thanks Robert.