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

Astrid Emde (WhereGroup) astrid.emde at wheregroup.com
Tue Mar 8 01:40:48 PST 2022

Hello Gal,

the behaviour of digitizer changed.

It is not fully documented yet but will be soon.

Here is a developer docu for the digitizer/data-manager 


See digitize demo for an example 

The changes are:
- the order is the other way round - first value, then key (this chenged 
in Symfony)
- an empty value can be generated see example

This is how it could look like

           type: select
           title: Jahr
           name: jahr
             required: required # if it is a mandatory field

             - label: 'Plese select a value'
               value: ''
           connection: myconnection
           sql: 'SELECT DISTINCT descriere, cod FROM 
nomenclator_viabilitate Order By cod;'

Hope the information helps

See you Astrid

Am 2022-03-08 10:07, schrieb Gal Zsolt:
> Hello List!
> I try to migrate on application from Mapbender 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
> _______________________________________________
> Mapbender_users mailing list
> Mapbender_users at lists.osgeo.org
> https://lists.osgeo.org/mailman/listinfo/mapbender_users

Mit freundlichen Grüßen

Astrid Emde

FOSSGIS Konferenz
09.-12. März 2022 online

   Astrid Emde
   WhereGroup GmbH
   Eifelstraße 7
   53119 Bonn

   Tel: +49(0)228 90 90 38 - 22
   Fax: +49(0)228 90 90 38 - 11

   astrid.emde at wheregroup.com

   Meinen PGP Public-Key können Sie unter pgp.mit.edu herunterladen:
   Signierte und/oder verschlüsselte Nachrichten sind sehr willkommen

   Folgen Sie der WhereGroup auf twitter:

   Olaf Knopp, Peter Stamm
   Amtsgericht Bonn, HRB 9885
-------------- next part --------------
A non-text attachment was scrubbed...
Name: 0x1C287CCB.asc
Type: application/pgp-keys
Size: 1574 bytes
Desc: not available
URL: <http://lists.osgeo.org/pipermail/mapbender_users/attachments/20220308/8ed945af/attachment.key>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 228 bytes
Desc: OpenPGP digital signature
URL: <http://lists.osgeo.org/pipermail/mapbender_users/attachments/20220308/8ed945af/attachment.sig>

More information about the Mapbender_users mailing list