M.App Enterprise Discussions

Discuss topics with other M.App Enterprise Product pioneers and experts to get the most out of it.
Showing results for 
Search instead for 
Do you mean 
Reply
Highlighted
Contributor
Posts: 27
Registered: ‎05-11-2018

Display lookup value in a list

Hi,

 

I want to display a lookup value within a list workflow.

 

The list is showing a numberic value from the table but I want it to show a value from a lookup table based on the numberic value.

 

My FormField looks like this:

 

<FormField name="OVERALL_GRADE" label="GRADE" editable="true" visible="list,filter" 
defaultvalue="SQL[SELECT LTRIM(RTRIM(GRADE)) from WMS_GRADE WHERE id = LTRIM(RTRIM((SELECT OVERALL_GRADE FROM WMS_STREET_SURVEY WHERE ID = {ROW.ID}))]" 
datatype="string" 
lov="SQL[SELECT LTRIM(RTRIM(ID)), LTRIM(RTRIM(GRADE)) from WMS_GRADE]" 
required="true" persisted="true" saveinsession="false" type="combobox" />

The defaultvalue above is what I would like to show in my list but the list is not picking this up.

Is it possible to have defaultvalue work within a list?

Or is there an alternative method I can use to display the correct value in the list?

 

DisplayLookupValue.png

 

Thanks

Ciaran