Hexagon Geospatial

GMSC Discussions

GeoMedia Smart Client community discussion board is where you can create, contribute and share information and knowledge in regards to configuring as well as working with GeoMedia Smart Client. Find your answers, share your knowledge and help build a strong GeoMedia Smart Client community.
Turn on suggestions Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Do you mean 
Reply
Highlighted
Occasional Contributor
Ervins
Posts: 13
Registered: ‎07-09-2019

FormField Sqlselect in LIST

‎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

 

Report Inappropriate Content
Message 1 of 2 (333 Views)
Reply
0 HexPoints
Highlighted
Technical Evangelist
Technical Evangelist
sclow
Posts: 816
Registered: ‎11-12-2015

Re: FormField Sqlselect in LIST

‎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

Report Inappropriate Content
Message 2 of 2 (308 Views)
Reply
0 HexPoints