Skip to main content

DBO function to return lookup maintenance client code from field name with lookup values

DBO.EQ_STD_CLASSIFICATION_CLIENT_CODE_FROM_DESCRIPTION_UNIQUE_NAME(Parameter1, Parameter2) This function will accept the display value of a classification lookup and the unique name of the field. It w

Updated over 2 weeks ago

DBO.EQ_STD_CLASSIFICATION_CLIENT_CODE_FROM_DESCRIPTION_UNIQUE_NAME(Parameter1, Parameter2)

This function will accept the display value of a classification lookup and the unique name of the field. It will return the Client Code as listed on the Lookup Maintenance page. This may be useful for systems integration.

Parameter(s)

Parameter1: classification lookup display value e.g. [Employee: Gender]

Parameter2: field unique name e.g. 'EMPLOYEE!GENDER' - this can be found using the DDMO function

Example(s)

Example 1: Return the Client Code as shown on the Lookup Maintenance screen for the display value of a classification lookup and the unique name of the field.

  • DBO.EQ_STD_CLASSIFICATION_CLIENT_CODE_FROM_DESCRIPTION_UNIQUE_NAME([Employee: Gender], 'EMPLOYEE!GENDER')

Client_Code.png
Did this answer your question?