DBO.EQ_STD_CUSTOM_FIELD_CODE_FROM_UNIQUE_NAME(Parameter1, Parameter2, Parameter3)
This function will accept the display value of the custom field, the unique name of the custom field, and the company id. It will return the Code as listed on the Custom Field detail screen, Lookup Values section. The company id is required if the custom field is defined at a company level. This may be useful for systems integration.
Parameter(s)
Parameter1: Custom field display value e.g. [Assignment (Custom Fields): Large List]
Parameter2: Custom field unique name e.g. ASSIGNMENT_CF!CF_TEXT032 - this can be found using the DDMO function
Parameter3: [Company: Id] required if Custom Field is defined at a company level or NULL if not/
Example(s)
Example 1: Return the Code as listed on the Custom Field detail screen, Lookup Values Section using the Custom Field display value and the Custom Field unique name.
DBO.EQ_STD_CUSTOM_FIELD_CODE_FROM_UNIQUE_NAME([Assignment (Custom Fields): Large List], 'ASSIGNMENT_CF!CF_TEXT032', NULL)
