Need unique value in a pick list

Bobby Jo Close

12. September 2014 07:29

I am building a workflow to return a list of unique values in a field and once the user picks one, all of the features with that value are selected.

My workflow uses QueryTask, DisplayResultsPicker, SelectFeatures.  I setup the QueryTask to "Return Distinct Values" = True hoping this would give me what I want, but the workflow still returned all of the features that were called by the Where clause. Possibly I need to use some other container to get a unique list . Any thoughts would be helpful. 

Note: I am a GIS person, not a programmer.....

Thanks, Bobby Jo

0

• 

  Nico Burgerhart

  12. September 2014 20:48

  Is your ArcGIS server 10.1 or higher? (requirement to use the Return Distinct Values property)

  Is your field the only field in the "Out Fields" property?

  0
• 

  Bobby Jo Close

  12. September 2014 23:11

  We are at ArcGIS Server 10.2.

  I have set up the workflow with one or many fields in the "Out Fields" property with no success either way. I would prefer to have all of the fields in the "Out Fields" that I need for the Selection.

   

  0
• 

  Permanently deleted user

  18. Mai 2016 15:36

  In my workflows I built a lookup table and published those with the map layers.  I built it pretty easy with running statistics on that particular column and then deleting the erroneous fields.  Works fabulous!   There were a few lookup tables that also existed already in the database I was able to export right into my SDE as well to save me the hassle.

  0
• 

  Permanently deleted user

  23. Juni 2020 13:17

  Hi Bobby Jo, did you figure this out? Setting Distinct Values to True isn't working for me either. I can make a long workaround, but I wish the activity would work as intended.

  0
• 

  Nico Burgerhart

  23. Juni 2020 17:42

  Limit the Out Fields to the single field you want to get distinct values for, set Return Geometry to False, configure a valid Where Clause (or 1 = 1) and set Return Distinct Values to True.

  0
• 

  Permanently deleted user

  23. Juni 2020 18:10

  Thanks Nico, I think the return geometry to false was my issue (been working on it for a few hours and have made lots of changes since I posted). It made me rethink how I use the Picker since it can't return geometry. I ended up using a GetAttributeValue on the feature they picked from the Picker to then use it to query the layer for all features with that value.

  0

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