populate field with autosequence in landmark

Legacy Contributor

I added a custom business class in landmark v11.  Is it possible on create record to populate a field with an auto sequence?  It looks like the LPL documentation says maybe.  See snipit below.  How do I implement this?  Are there other ways to do this through a default value or a "get sequence" button click?  Thank you for any information even if it is "that's impossible!"

 

FieldCreateRule ::= // valid in Field context with Create action

                   autosequence [using ( | )]

                                 [minimize contention [and gaps]]

// if no field specified find last instance in context and increment by 1 – field must be either symbolic or relative key

// if SetName specified then find last instance using SetName – SetName must contain this field

// if RelatedField specified then increment RelatedField by 1 and use that value

// minimize contention is not valid with a RelatedField –this option can result in gaps in the numerical sequence

// typically ‘minimize contention’ will retrieve a block of numbers, when gaps are minimized as well, it retrieves one at a time

andy

This appears to be possible by modifying the LPL of your User Business Class.



For example, if your User Business Class is called Printers, and the Key Field is Printers...



1) Click the pencil icon to edit the LPL

2) Add the LPL below to the Key Field window.



Field Rules



Printers

autosequence

minimize contention

3) Save



When you create a new record in the Business Class, the Key Field will be auto incremented with a Numeric.



I'm not sure if you can extend it to Persistent Fields, because I've only tested with the Business Classes Key Field, but that might be possible too.









Example Key Field LPL.....





Printers is a KeyField



Representation

type is Numeric size 10



Ontology

business class is Printers



Field Rules



Printers

autosequence

minimize contention