Select Distinct for a workflow combobox

Permanently deleted user

20 Maj 2011 00:36

I have a simple workflow that queries rail crossings where the operator code equals a selected combobox value from a form.  For the Query Where Clause I have the value 1=1.  This produces a list of all the records operator codes.  The list needs to only show distinct values. 

I tried this, but it didn't work: 

SELECT DISTINCT MAIN_RR_OPERATOR_CODE FROM SDW_TRANS.RAIL_CROSSING_ACTIVE WHERE 1=1

Any ideas?

Thanks, Sonia

0

• 

  Permanently deleted user

  20 Maj 2011 20:08

  Hi Sonia,

                 It seems like you’re trying to get a list of lookup values from an operational layer (the reason you’re using DISTINCT). You should get lookup values from a domain table (ArcGIS allows you to publish tables through map services, please refer to the Esri documentation).

                 If you don’t have access to the domain table, you may consider adding the items manually to the combobox.

  Cheers,

  Christian.

  0
• 

  Marc Rempel

  25 April 2013 23:59

  Hi,

  I would like to see the combobox/autocomplete box query task parameters include the option to select distinct values that is available with 10.1 layers. 

  I have a scenario that has a cascading combobox pulling topics and attributes from two query layer tables in my dynamic map service.   I need to filter the queries to display topics that vary depending on user selected years/geography type in a preceding form (would prefer the same form, but that is a different issue).  A topic may have many attributes, so there is a one to many relationship.  From my AGS rest endpoint I can create the needed query with the returning distinct values from the attribute table that has my topic names joined to the attribute table.  If there was a way to append the returnDistinctValues=true to the query task parameters, then I would be set.

  Marc

  0

Du måste logga in om du vill lämna en kommentar.