In Database Configuration, add this relationship to the CLASSSTRUCTURE object:
- Name: OTCFIRSTCLASS
- Where: parent is null and classstructureid in (select ancestor from classancestor where classstructureid = :classstructureid)
- Child: CLASSSTRUCTURE
- Remarks: Top level classification above this one. First classification in the path to this one. Ancestor classification that has no parent.
Put a textbox in the Classifications application and set the Attribute property to OTCFIRSTCLASS.CLASSIFICATIONID.
Note: Following good practice, I prefixed the name of this custom relationship on an OOTB object with OTC for Ontracks Consulting. I expect you would adjust to suit your situation.
------------------------------
Blessings,
Jason Uppenborn
Sr. Technical Maximo Consultant
Ontracks Consulting
------------------------------