AnsweredAssumed Answered

How to handle query results from multiple fields

Question asked by mbakerDPS on Jul 9, 2014
Latest reply on Jul 10, 2014 by JGravois-esristaff

Hi all,

 

With thanks to John Gravois, I've been able to pass geometry from the result of a geocoder, along with a field name, to a spatial intersection query to run against a school boundary layer.

 

What I'd like to do is pull the school boundary number from the corresponding field the user chooses - that is - the user chooses Grade 6 from the drop down, which means I want the value from the SCHOOL_6 field in the boundary layer I'm querying.

 

So I'm wondering how I should do this:

 

1) Do I use the SCHOOL_6 value in the outfields query parameter and pull that value, which yields this result:

singleFieldResult.PNG

additionally - how do I pull that value 416 if there is only ever 1 feature returned, but the field name could always change based on the drop-down?

 

or ...

 

2) Pull all the fields from the query layer, and select the attribute from the field that matches the value of the drop-down (ie. SCHOOL_6), and sift through the results that way. Here's what the results look like from pulling all the fields:

 

multipleFieldResults.PNG

@

The purpose of pulling this boundary number is that it will go into the last query, which will pull all the schools belonging to that boundary number.

 

UPDATE: I have added the code I am working on. cc Jake Skinner

 

Any thoughts appreciated.

 

 

Message was edited by: Matthew Baker

Outcomes