Workflow auto-generate id

Bill Everingham

25. Juni 2020 14:14

Any ideas on what workflow function would be used to auto-generate an ID number for a feature layer when the user needs to add a new feature?  (next number available) 

0

• 

  Tom Neer

  25. Juni 2020 15:11

  You could use a SQL query using something like MAX(ROW_NUMBER() OVER (ORDER BY objected)) then increment it from the front end. Or from the backend use a sequencer.

   

   

  However, we have found the easiest is to publish a table in a feature service that handles all our sequencers. We generally call ours "sequencer" with the following fields seqname, seqcounter, seqinterval. The "seqname" name is generally a feature layer name/id. We then query the table by the layer name, add together the "seqcounter" and "seqinterval" fields. Write your new record. If it writes, then update the sequencer "seqcounter" with the new value. This also allows us to build complex alphanumeric ids (e.g. RCL-08023-00002356). RCL stands for "Road  Centerline", 08023 is the FIPS code and the last is a zero-padded sequence

  0
• 

  Bill Everingham

  9. Oktober 2020 15:21

  Any Chance you have an example workflow to share?  I've just circled back to this.

  0

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