<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<meta name="Generator" content="Microsoft Word 15 (filtered medium)">
<!--[if !mso]><style>v\:* {behavior:url(#default#VML);}
o\:* {behavior:url(#default#VML);}
w\:* {behavior:url(#default#VML);}
.shape {behavior:url(#default#VML);}
</style><![endif]--><style><!--
/* Font Definitions */
@font-face
{font-family:Wingdings;
panose-1:5 0 0 0 0 0 0 0 0 0;}
@font-face
{font-family:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
@font-face
{font-family:Aptos;}
@font-face
{font-family:Webdings;
panose-1:5 3 1 2 1 5 9 6 7 3;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0cm;
font-size:11.0pt;
font-family:"Aptos",sans-serif;
mso-ligatures:standardcontextual;
mso-fareast-language:EN-US;}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:#0563C1;
text-decoration:underline;}
p.MsoListParagraph, li.MsoListParagraph, div.MsoListParagraph
{mso-style-priority:34;
margin-top:0cm;
margin-right:0cm;
margin-bottom:0cm;
margin-left:36.0pt;
font-size:11.0pt;
font-family:"Aptos",sans-serif;
mso-ligatures:standardcontextual;
mso-fareast-language:EN-US;}
span.EmailStyle19
{mso-style-type:personal-compose;
font-family:"Aptos",sans-serif;
color:windowtext;}
.MsoChpDefault
{mso-style-type:export-only;
font-size:11.0pt;
mso-ligatures:none;
mso-fareast-language:EN-US;}
@page WordSection1
{size:612.0pt 792.0pt;
margin:72.0pt 72.0pt 72.0pt 72.0pt;}
div.WordSection1
{page:WordSection1;}
/* List Definitions */
@list l0
{mso-list-id:991565643;
mso-list-type:hybrid;
mso-list-template-ids:1994002526 74317825 74317827 74317829 74317825 74317827 74317829 74317825 74317827 74317829;}
@list l0:level1
{mso-level-number-format:bullet;
mso-level-text:\F0B7;
mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-18.0pt;
font-family:Symbol;}
@list l0:level2
{mso-level-number-format:bullet;
mso-level-text:o;
mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-18.0pt;
font-family:"Courier New";}
@list l0:level3
{mso-level-number-format:bullet;
mso-level-text:\F0A7;
mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-18.0pt;
font-family:Wingdings;}
@list l0:level4
{mso-level-number-format:bullet;
mso-level-text:\F0B7;
mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-18.0pt;
font-family:Symbol;}
@list l0:level5
{mso-level-number-format:bullet;
mso-level-text:o;
mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-18.0pt;
font-family:"Courier New";}
@list l0:level6
{mso-level-number-format:bullet;
mso-level-text:\F0A7;
mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-18.0pt;
font-family:Wingdings;}
@list l0:level7
{mso-level-number-format:bullet;
mso-level-text:\F0B7;
mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-18.0pt;
font-family:Symbol;}
@list l0:level8
{mso-level-number-format:bullet;
mso-level-text:o;
mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-18.0pt;
font-family:"Courier New";}
@list l0:level9
{mso-level-number-format:bullet;
mso-level-text:\F0A7;
mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-18.0pt;
font-family:Wingdings;}
@list l1
{mso-list-id:993266094;
mso-list-template-ids:52355976;}
@list l2
{mso-list-id:1214855733;
mso-list-type:hybrid;
mso-list-template-ids:-1780857610 74317839 74317849 74317851 74317839 74317849 74317851 74317839 74317849 74317851;}
@list l2:level1
{mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-18.0pt;}
@list l2:level2
{mso-level-number-format:alpha-lower;
mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-18.0pt;}
@list l2:level3
{mso-level-number-format:roman-lower;
mso-level-tab-stop:none;
mso-level-number-position:right;
text-indent:-9.0pt;}
@list l2:level4
{mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-18.0pt;}
@list l2:level5
{mso-level-number-format:alpha-lower;
mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-18.0pt;}
@list l2:level6
{mso-level-number-format:roman-lower;
mso-level-tab-stop:none;
mso-level-number-position:right;
text-indent:-9.0pt;}
@list l2:level7
{mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-18.0pt;}
@list l2:level8
{mso-level-number-format:alpha-lower;
mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-18.0pt;}
@list l2:level9
{mso-level-number-format:roman-lower;
mso-level-tab-stop:none;
mso-level-number-position:right;
text-indent:-9.0pt;}
@list l3
{mso-list-id:1941718043;
mso-list-type:hybrid;
mso-list-template-ids:849772308 74317825 74317827 74317829 74317825 74317827 74317829 74317825 74317827 74317829;}
@list l3:level1
{mso-level-number-format:bullet;
mso-level-text:\F0B7;
mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-18.0pt;
font-family:Symbol;}
@list l3:level2
{mso-level-number-format:bullet;
mso-level-text:o;
mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-18.0pt;
font-family:"Courier New";}
@list l3:level3
{mso-level-number-format:bullet;
mso-level-text:\F0A7;
mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-18.0pt;
font-family:Wingdings;}
@list l3:level4
{mso-level-number-format:bullet;
mso-level-text:\F0B7;
mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-18.0pt;
font-family:Symbol;}
@list l3:level5
{mso-level-number-format:bullet;
mso-level-text:o;
mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-18.0pt;
font-family:"Courier New";}
@list l3:level6
{mso-level-number-format:bullet;
mso-level-text:\F0A7;
mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-18.0pt;
font-family:Wingdings;}
@list l3:level7
{mso-level-number-format:bullet;
mso-level-text:\F0B7;
mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-18.0pt;
font-family:Symbol;}
@list l3:level8
{mso-level-number-format:bullet;
mso-level-text:o;
mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-18.0pt;
font-family:"Courier New";}
@list l3:level9
{mso-level-number-format:bullet;
mso-level-text:\F0A7;
mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-18.0pt;
font-family:Wingdings;}
ol
{margin-bottom:0cm;}
ul
{margin-bottom:0cm;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]-->
</head>
<body lang="LB-LU" link="#0563C1" vlink="#954F72" style="word-wrap:break-word">
<div class="WordSection1">
<p class="MsoNormal"><span lang="DE">Hallo in die Runde,</span><span lang="DE"><o:p></o:p></span></p>
<p class="MsoNormal"><span lang="DE"><o:p> </o:p></span></p>
<p class="MsoNormal"><span lang="DE">ich wende mich an euch, da ich keine Möglichkeit gefunden habe (weder in QGIS, noch im QGIS-Lizmap Plugin) in Lizmap
<b>Dropdown-Menüs alphabetisch sortiert</b> darzustellen.<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="DE"><o:p> </o:p></span></p>
<p class="MsoNormal"><span lang="DE">Mein Ziel ist unseren Datenbank-Usern im Lizmap Editierwerkzeug beim Erstellen/Editieren eines Wertes die Auswahl aus einem
<b>alphabetisch sortieren Dropdown-Menü </b>zu ermöglichen. Dazu habe ich in unserer PostGIS Datenbank eine Tabelle erstellt (deren Werte nicht alphabetisch sortiert sind, da dies nicht möglich ist, da sich deren Werte ständig ändern) die die Dropdown Werte
enthält und mit dem jeweiligen Attribut der Zieltabelle (die später den Wert enthält) über eine „Foreign Key“ Beziehung verknüpft ist.
<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="DE"><o:p> </o:p></span></p>
<p class="MsoNormal"><span lang="DE">Ich habe dazu ein kleines Testprojekt erstell (<a href="https://test.siasportail.lu/">https://test.siasportail.lu/</a>, Screenshot dazu im Anhang):
<o:p></o:p></span></p>
<ol style="margin-top:0cm" start="1" type="1">
<li class="MsoListParagraph" style="margin-left:0cm;mso-list:l2 level1 lfo3"><span lang="DE">Um dort das Editier-Werkzeug nutzen zu können, muss man sich zunächst als User „test“ (PW: test123456789) einloggen.
<o:p></o:p></span></li><li class="MsoListParagraph" style="margin-left:0cm;mso-list:l2 level1 lfo3"><span lang="DE">Beim Erstellen eines “Test Point” mit dem Editierwerkzeug kann ich für das Attribut “Test Dropdown” aus einem Dropdown-Menü auswählen. Da die Werte in der zugrundeliegenden
PostGIS Tabelle jedoch nicht alphabetisch sortiert abgelegt sind, werden diese im Dropdown-Menü auch nicht alphabetisch sortiert dargestellt.<o:p></o:p></span></li></ol>
<p class="MsoNormal"><span lang="DE"><o:p> </o:p></span></p>
<p class="MsoNormal"><b><span lang="DE">Meine Frage daher an euch</span></b><span lang="DE">: Wisst ihr, wie man die Werte im Dropdown-Menü alphabetisch sortiert darstellen kann, auch wenn die Werte in der zugrundeliegenden Tabelle nicht alphabetisch sortiert
sind?<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="DE"><o:p> </o:p></span></p>
<p class="MsoNormal"><span lang="DE">Weiterhin würde uns noch interessieren, ob es in Lizmap möglich ist ein
<b>„doppeltes“ Dropdown-Menü zu</b> erstellen, mit der Vorauswahl einer übergeordneten Kategorie und anschließend der Auswahl der Werte die diesen Kategorie entsprechen (wie z.B. hier dargestellt
<a href="https://www.sqlmaestro.com/products/mysql/phpgenerator/help/editors_dynamic_cascading_combobox/">
https://www.sqlmaestro.com/products/mysql/phpgenerator/help/editors_dynamic_cascading_combobox/</a>).
<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="DE"><o:p> </o:p></span></p>
<p class="MsoNormal"><span lang="DE">Die folgenden Versionen haben wir für das Aufsetzten des Test-Projektes verwendet:
<o:p></o:p></span></p>
<ul style="margin-top:0cm" type="disc">
<li class="MsoListParagraph" style="margin-left:0cm;mso-list:l0 level1 lfo6"><span lang="DE">Lizmap Web Client : 3.7.10<o:p></o:p></span></li><li class="MsoListParagraph" style="margin-left:0cm;mso-list:l0 level1 lfo6"><span lang="DE">Lizmap plugin : 4.3.24<o:p></o:p></span></li><li class="MsoListParagraph" style="margin-left:0cm;mso-list:l0 level1 lfo6"><span lang="DE">QGIS Desktop : 3.34.4<o:p></o:p></span></li><li class="MsoListParagraph" style="margin-left:0cm;mso-list:l0 level1 lfo6"><span lang="DE">QGIS Server : 3.34.11<o:p></o:p></span></li><li class="MsoListParagraph" style="margin-left:0cm;mso-list:l0 level1 lfo6"><span lang="DE">QGIS Server plugin atlasprint : 3.4.1<o:p></o:p></span></li><li class="MsoListParagraph" style="margin-left:0cm;mso-list:l0 level1 lfo6"><span lang="DE">QGIS Server plugin lizmap_server : 2.10.0<o:p></o:p></span></li><li class="MsoListParagraph" style="margin-left:0cm;mso-list:l0 level1 lfo6"><span lang="DE">PHP Version: 8.3</span><span lang="DE"><o:p></o:p></span></li></ul>
<ul style="margin-top:0cm" type="disc">
<li class="MsoListParagraph" style="margin-left:0cm;mso-list:l3 level1 lfo4"><span lang="DE">PostgreSQL / PostGIS : 16 / 3.4.2<o:p></o:p></span></li></ul>
<p class="MsoNormal"><span lang="DE"><o:p> </o:p></span></p>
<p class="MsoNormal"><span lang="DE">Herzlichen Dank im Voraus und liebe Grüße aus Luxemburg,<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="DE">Tobias<o:p></o:p></span></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;margin-bottom:6.0pt"><span lang="DE" style="font-size:12.0pt;font-family:"Calibri",sans-serif;color:#946B43;mso-fareast-language:LB-LU">Mat frëndleche Gréiss +++ Meilleures salutations +++ Mit freundlichen
Grüssen +++ Kind Regards<o:p></o:p></span></p>
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="549">
<tbody>
<tr style="height:27.5pt">
<td width="180" style="width:134.65pt;padding:0cm 11.25pt 15.0pt 0cm;height:27.5pt">
<p class="MsoNormal" style="line-height:105%"><span lang="DE" style="font-size:12.0pt;line-height:105%;mso-ligatures:none"><img border="0" width="149" height="59" style="width:1.552in;height:.6145in" id="Image_x0020_1" src="cid:image001.png@01DB14EA.2636A5E0" alt="sias"></span><span lang="DE"><o:p></o:p></span></p>
</td>
<td width="180" valign="top" style="width:134.65pt;padding:0cm 0cm 15.0pt 22.5pt;height:27.5pt">
<p class="MsoNormal" style="margin-left:-15.4pt;line-height:105%"><span lang="DE" style="font-size:15.0pt;line-height:105%;font-family:"Calibri",sans-serif;color:#946B43">Tobias Mosthaf</span><span lang="DE" style="font-size:12.0pt;line-height:105%">
<br>
</span><b><span lang="DE" style="font-size:12.0pt;line-height:105%;font-family:"Calibri",sans-serif;color:#EE7D00">Natura 2000<br>
</span></b><b><span lang="DE" style="font-size:12.0pt;line-height:105%;font-family:"Calibri",sans-serif;color:#946B43">T
</span></b><span lang="DE" style="font-size:12.0pt;line-height:105%;font-family:"Calibri",sans-serif;color:#946B43">+ 352 34 94 10 – 34<o:p></o:p></span></p>
<p class="MsoNormal" style="margin-left:-15.4pt;line-height:105%"><b><span lang="DE" style="font-size:12.0pt;line-height:105%;font-family:"Calibri",sans-serif;color:#946B43">E
</span></b><a href="mailto:t.mosthaf@sias.lu"><span lang="DE" style="font-size:12.0pt;line-height:105%;color:#946B43;text-decoration:none">t.mosthaf@sias.lu</span></a><span lang="DE" style="font-size:12.0pt;line-height:105%">
</span><span lang="DE"><o:p></o:p></span></p>
</td>
<td width="190" style="width:142.45pt;padding:0cm 0cm 0cm 0cm;height:27.5pt">
<p class="MsoNormal" align="center" style="margin-left:-7.65pt;text-align:center;text-indent:-.55pt;line-height:105%">
<span lang="DE" style="font-size:15.0pt;line-height:105%;font-family:"Calibri",sans-serif;color:#946B43"> </span><span lang="DE" style="font-size:12.0pt;line-height:105%;mso-ligatures:none"><img border="0" width="144" height="69" style="width:1.5in;height:.7187in" id="_x0000_i1028" src="cid:image002.png@01DB14EA.2636A5E0" alt="Une image contenant texte, capture d’écran, dessin humoristique, Graphique
Description générée automatiquement"></span><span lang="DE" style="font-size:15.0pt;line-height:105%;font-family:"Calibri",sans-serif;color:#946B43"><o:p></o:p></span></p>
</td>
</tr>
</tbody>
</table>
<p class="MsoNormal"><b><span lang="DE" style="font-size:12.0pt;font-family:"Calibri",sans-serif;color:#946B43;mso-fareast-language:LB-LU">SIAS - Syndicat intercommunal à vocation multiple<br>
</span></b><span lang="DE" style="font-size:12.0pt;font-family:"Calibri",sans-serif;color:#946B43;mso-fareast-language:LB-LU">5, rue Neihaischen - L-2633 Senningerberg<br>
</span><a href="http://www.sias.lu/"><b><span lang="DE" style="font-size:12.0pt;font-family:"Calibri",sans-serif;color:#946B43;mso-fareast-language:LB-LU">www.sias.lu</span></b></a><b><u><span lang="DE" style="font-size:12.0pt;font-family:"Calibri",sans-serif;color:#946B43;mso-fareast-language:LB-LU"><o:p></o:p></span></u></b></p>
<p class="MsoNormal"><a href="http://www.natura2000.lu/"><b><span lang="DE" style="font-size:12.0pt;font-family:"Calibri",sans-serif;color:#946B43;mso-fareast-language:LB-LU">www.natura2000.lu</span></b></a><u><span lang="DE" style="color:#946B43;mso-fareast-language:LB-LU"><o:p></o:p></span></u></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><a href="https://www.facebook.com/www.sias.lu/"><span lang="DE" style="font-size:12.0pt;font-family:"Calibri",sans-serif;color:#0563C1;mso-ligatures:none;mso-fareast-language:LB-LU;text-decoration:none"><img border="0" width="9" height="19" style="width:.0937in;height:.1979in" id="Image_x0020_3" src="cid:image003.png@01DB14EA.2636A5E0"></span></a><span lang="DE" style="font-size:12.0pt;mso-fareast-language:LB-LU"> </span><a href="https://www.youtube.com/channel/UClGQbc7ugXYy7jw7j547g7w"><span lang="DE" style="font-size:12.0pt;font-family:"Calibri",sans-serif;color:#0563C1;mso-ligatures:none;mso-fareast-language:LB-LU;text-decoration:none"><img border="0" width="19" height="19" style="width:.1979in;height:.1979in" id="Image_x0020_4" src="cid:image004.png@01DB14EA.2636A5E0"></span></a><span lang="DE" style="font-size:12.0pt;mso-fareast-language:LB-LU"> </span><a href="https://www.youtube.com/channel/UClGQbc7ugXYy7jw7j547g7w"><span lang="DE" style="font-size:12.0pt;font-family:"Calibri",sans-serif;color:#0563C1;mso-ligatures:none;mso-fareast-language:LB-LU;text-decoration:none"><img border="0" width="28" height="19" style="width:.2916in;height:.1979in" id="Image_x0020_5" src="cid:image005.png@01DB14EA.2636A5E0"></span></a><span lang="DE" style="font-size:12.0pt;mso-fareast-language:LB-LU"> <br>
</span><span lang="DE" style="font-size:11.5pt;font-family:Webdings;color:#C8D400;mso-fareast-language:LB-LU">P</span><span lang="DE" style="font-size:12.0pt;color:#C8D400;mso-fareast-language:LB-LU"> Be environmentally friendly: please do not print this email
unless it is entirely necessary. </span><span lang="DE" style="font-size:12.0pt;mso-fareast-language:LB-LU"><o:p></o:p></span></p>
<p class="MsoNormal"><span lang="DE"><o:p> </o:p></span></p>
</div>
</body>
</html>