How do I set up the query required to select a feature from an item list and have the Geometry of that feature passed into the workflow?

Permanently deleted user

3. September 2021 17:53

Background:

I am building a workflow that will walk a user through a simple review process and allows an update of the geometry of the queried feature. I will be adding attribute updates next as well. Near the beginning of the workflow early in the forms, I present the user with a list of features that will be ultimately moved on the map one at a time through a series of steps. The user should click one of the items in the "item list" to review and then it steps the user through finding the proper location for the point. This is because the layer will receive regular updates of features without reliable address information to geocode initially and the user will ensure the updated points are positioned correctly before another process grabs the updated layer with updated geometry. (Not yet set up - Empty attributes for Lat, Lon, and MapAddress will be populated from geocode service that the user invokes while choosing the new location for the geometry.)

 

At the moment, the app is nearly functional, form navigation is good, it can perform the geometry modifications the way I want it to near the end of the workflow.

 

The Problem I'm Having:

I don't know how to select a feature from the item box and pass the selected feature to the workflow. I am assuming I have to set up a query that gets the geometry and attribution. (For testing so far, the query that gets the feature is an SQL statement that just returns a single record OBJECTID = "value". I did this so that I could test the movement of the geometry further in the workflow.)

 

Thanks in advance for help on this,

 

Kris

 

 

0

• 

  Brian Cunningham

  14. September 2021 16:11

  Hi @Kris Knowles? ,

   

  If I'm understanding your issue properly, it sounds like you need to utilize a Query Layer task to retrieve the feature, rather than a Run SQL Query task. You can either provide a URL to an ArcGIS Server REST endpoint, or you can reference a layer that exists in the map if you want to maintain any formatting to display the features later in the workflow.

   

  If you utilize a Query Layer task, and set the Return Geometry property to True (default is False), and then specify which attributes you want returned in the Output Fields property (use * to retrieve all attributes, or use a comma separated string to specify certain fields), you will then be able to access the geometry and attributes for the feature(s) that match your query parameters from the output of that Query Layer task.

   

  Hope this helps!

  Brian

  0
• 

  Lisa Pierce

  14. September 2021 21:37

  Thanks Brian – That is very helpful. Much appreciated. Lisa A. Pierce GIS Analyst City of Riverside Innovation and Technology Division 951-826-5159 Office 951-560-0615 Cell lpierce@riversideca.gov

  0
• 

  Permanently deleted user

  14. September 2021 22:10

  Thank you for your replies. I thought I’d circle back now that I managed to get this working.

  In the end, I used a drop down box, queried the item.current in the drop down box in a sub workflow as a change event to get the index number. I create a value using the selected index number inside that change subworkflow. Using the same sort attribute, I query the feature a second time outside of the form using the index value as the start value on the query and the count set to 1.

   

  This gets me the selected feature that I can then send through all the other “ins and outs” that I mentioned further along in the workflow.

   

  Kris

  0

Bitte melden Sie sich an, um einen Kommentar zu hinterlassen.