nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Attribute Rules: NextSequenceValue in a file database environment.

Anonymous User

Attempting to create sequential IDs for managing above ground assets.

I successfully create the database sequence and have been working with two scripts.

1.) Returns zeros in the FID field

--------------------------------------------------------------------------------------

var FID = $feature.FID;
($feature.FID == 1)
return "SP-" + NextSequenceValue("Traffic_SignalPole_ID")

--------------------------------------------------------------------------------------

2.) The FID values remain Null

----------------------------------------------------------------------------------------

var FID = $feature.FID;
(FID == 1)
return "SP-" + NextSequenceValue("Traffic_SignalPole_ID")

----------------------------------------------------------------------------------------

If is put an "if" before the second line regardless, the field value will be null.

Also when I check the table in arc catalog is shows that the sequence is adding to the database table, but is still not being appended to the feature its self.

Capture.PNG

タグ付けされた投稿をもっと見る

Accepted answers

rkrisher

I'll make some assumptions about the questions you didn't answer (it's an immediate calculation rule configured to fire on insert). Does your feature have a default value set on the field? Try adding logic to the check so it looks for empty OR your default value.

if(isempty($feature.FID) || $feature.FID=="0") //If the field is empty or has the default value
return concatenate("SP-",nextsequencevalue("Traffic_SignalPole_ID")); //calculate a new id
else //otherwise
return $feature.FID //return the original value

All comments

Anonymous User

1.)

-------------------------------------------------------------------------------------------------------------------------------

if(isempty($feature.FID)) //If the field is empty
return concatenate("SP-",nextsequencevalue("Traffic_SignalPole_ID")); //calculate a new id
else //otherwise
return $feature.FID //return the original value

--------------------------------------------------------------------------------------------------------------------------------

2.)

--------------------------------------------------------------------------------------------------------------------------------

if(isempty($feature.FID)) //If the field is empty
return "SP-"+nextsequencevalue("Traffic_SignalPole_ID"); //calculate a new id
else //otherwise
return $feature.FID //return the original value

----------------------------------------------------------------------------------------------------------------------------------

The field is: FID

Only assigned to fire on insert.

The rules is an immediate calculation.

rkrisher

Let's just focus on the geodatabase testing first, that way you can work out all the issues locally before pushing it all to enterprise.

Can you include the new expressions you're now using (with your field / sequence names) along with additional information about how the rule is configured? It is just assigned to fire on insert? update?

Anonymous User

Would I need to create a new database sequence, since I have made many attempts as shown in the ArcCatalog table screenshot.

After using the script you proved I am still getting "0" in the FID field, but the sequence counter in the catalog table continues to increase?

rkrisher

Let's take a look at the expression. I'm assuming this is some kind of immediate or batch calculation rule, which means that every time this expression fires the value returned from it will replace the value in your ID field.

It looks like you're trying to add in a test to see if the value is already populated, but because the statement isn't included in an if statement that means that it isn't controlling logic at all. Here is an example of an expression that will only calculate a new sequence value if the field is empty. In this case I assigned it as an immediate calculation rule on the "my_id" field.

if(isempty($feature.my_id)) //If the field is empty
return concatenate("SP-",nextsequencevalue("Test")); //calculate a new id
else //otherwise
return $feature.my_id //return the original value

Here's a screenshot of a few features I created using this rule.

Features Creating Using Expression

会話に参加する

サインインしたメンバーは投稿、更新のフォローなどができます。初めてですか？無料アカウントを登録してください。

クイックリンク

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.