[Mapbender-users] Get the options for the selectbox via SQL not working Mapbender 3.3.0

[Gal Zsolt]

Hello List!

I try to migrate on application from Mapbender 3.0.8.5 to Mapbender 3.3.0.

I have a Selectbox in Digitizer where I get the options for the selectbox via SQL, the select box don't display any value. When I click the arrow apear a list with indeces. I attach image.

type: select
title: Viabilitate
name: id_n_viabilitate
connection: myconnection
sql: 'SELECT DISTINCT cod, descriere FROM nomenclator_viabilitate Order By cod'



A workout is to not to use SQL, but I have 130 options (tree species).

Please suggest other solution, if are any.


Thanks

Zsolt



-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/mapbender_users/attachments/20220308/1fa03469/attachment.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: selectboxerror.png
Type: image/png
Size: 7552 bytes
Desc: not available
URL: <http://lists.osgeo.org/pipermail/mapbender_users/attachments/20220308/1fa03469/attachment.png>