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

[Astrid Emde (WhereGroup)]

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 
https://github.com/mapbender/data-manager#form-input-fields

https://doc.mapbender.org/en/functions/editing/digitizer/digitizer_configuration.html#selectbox-selectbox-or-multiselect-type-select
https://github.com/mapbender/mapbender-workshop/blob/release/3.2/MIGRATION_GUIDE.md

See digitize demo for an example 
https://github.com/mapbender/mapbender-workshop/blob/release/3.2/app/config/applications/mapbender_digitize_demo.yml

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
           attr:
             required: required # if it is a mandatory field

           options:
             - 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 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
> _______________________________________________
> Mapbender_users mailing list
> Mapbender_users at lists.osgeo.org
> https://lists.osgeo.org/mailman/listinfo/mapbender_users

-- 
Mit freundlichen Grüßen

Astrid Emde
GIS-Consultant

---------------------------------------------
FOSSGIS Konferenz
09.-12. März 2022 online
https://www.fossgis-konferenz.de/
---------------------------------------------

   Astrid Emde
   WhereGroup GmbH
   Eifelstraße 7
   53119 Bonn
   Germany

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

   astrid.emde at wheregroup.com
   www.wheregroup.com

   Meinen PGP Public-Key können Sie unter pgp.mit.edu herunterladen:
   
https://keys.openpgp.org/vks/v1/by-fingerprint/01F8152D36FC07C25EADDE86C5084ACC1C287CCB
   Signierte und/oder verschlüsselte Nachrichten sind sehr willkommen

   Folgen Sie der WhereGroup auf twitter:
   http://twitter.com/WhereGroup_com

   Geschäftsführer:
   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>