10-06-2019 11:03 PM
Hello, Everybody !
I am wondering how to refer to rowid in Formfield Sqlselect for LIST controller. My task is to DECODE attachement existence to "Yes" or "No" if photo field is filled with some string. At the same time it is necessary to enable LIST filters.
GMSC FormField Sqlselect sample refers only to FORM.FIELD but I am lokking for FORM.FIELD.ID or similar syntax working in LIST.
<FormGroup name="SIGN_GROUP" label="SIGN" >
<FormField name="FOTO" label="Foto_EXISTS" maxlength="6" datatype="string" required="false" persisted = "false" type="textfield" sqlselect="SQL[DECODE({FORMFIELD.FOTO}, null, 'NO', 'YES']" filter="ISLIKE" visible="list,filter" />
Thanks!
Regards,
Ervins
10-16-2019 04:45 AM
Hi Ervins,
Similar case was discussed in Developer Discussions in past and judging by your description here the information there should be helpful to your case.
HTH