Attribute Assistant-Dynamic Value Table-TableName Values Expressions

Question

I am having a problem populating an ID attribute "GISOBJID" which is a string in a versioned SDE data set. The AUTONUMBER I want to combine "ASSETNUM" works fine for everything , but I want to combine that with an ALPHA prefix (FM-123) into the "GISOBJID" attribute. I have tried several ways and no success. Only the AUTONUMBER works. I have tried using the full SDE name "UTILITIES2.CCU.ssPressurizedMain" in the DynamicValue Table and the shortened version "ssPressurizedMain" with no results. I have also tried an EXPRESSION "FM-" & Str( [ASSETNUM] ) and GenerateID with SSPRESSURIZEDMAIN|0|FM-[seq] still no success. Any help with this would be greatly appreciated. Thanks in advance!

1.

2.

3.

DavidCain · Answer

Thanks for the reply Cort. Yes the GISOBJID is a text value. Neither of the DynamicValue or GenerateID tables are versioned and they reside in the SDE dataset. I've been racking my brain trying combinations with no success.

CortWilson · Answer

I know this is possible using GENERATEID, because I did the EXACT same thing you are trying to do.... but I'm using a SQL SP for my asset id assignment now, so I don't have the method in my dynamic value table anymore!  Let me try to rack my brain.  The field type of your GISOBJID field is text right?