Using a Geodatabase Sequence With a Multi-Record Append

Question

Is it possible to get an attribute rule to fire sequentially as records are appended to a feature class?

As a test I set a geodatabase sequence in a file geodatabase with a start value of 100 and increment value of 1.  I then added a standard return NextSequenceValue rule to a field, UniqueID:

return "Prefix-" + NextSequenceValue ("SequenceName")

Then I appended several hundred records from another feature class.  All of the appended records have a UniqueID value of Prefix-100.

I was hoping they would have Prefix-100, Prefix-101, Prefix-102 and so on.

Is there a way to write a rule that uses a database sequence and will assign incremental values with a multi-record append?

@XanderBakker

JoeBorgione · Answer

I'll give it a second try then; maybe it's 2.6 thing.  I'm late in updating...

HusseinNasser2 · Answer

Just did a quick test on 2.7 and seems to be working

created two point classes testfrom and test

created a bunch of features in testfrom

created a sequence + AR above on Test class

executed an append from testfrom-> test and the resulting AR got executed as expected.

XanderBakker · Answer

Hi @JoeBorgione , happy New Year to you too.

I think the desired functionality of an attribute rule would be that it would be triggered by the newly appended features. Might be good to register this with support, since I don't think this is correct behavior.