<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=utf-8">
<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.EmailStyle21
{mso-style-type:personal;
font-family:"Aptos",sans-serif;
color:windowtext;}
span.EmailStyle22
{mso-style-type:personal-compose;
font-family:"Aptos",sans-serif;
color:windowtext;}
.MsoChpDefault
{mso-style-type:export-only;
font-size:10.0pt;
mso-ligatures:none;}
@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:154927340;
mso-list-template-ids:612414088;}
@list l0:level1
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:36.0pt;
mso-level-number-position:left;
text-indent:-18.0pt;
mso-ansi-font-size:10.0pt;
font-family:Symbol;}
@list l0:level2
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:72.0pt;
mso-level-number-position:left;
text-indent:-18.0pt;
mso-ansi-font-size:10.0pt;
font-family:Symbol;}
@list l0:level3
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:108.0pt;
mso-level-number-position:left;
text-indent:-18.0pt;
mso-ansi-font-size:10.0pt;
font-family:Symbol;}
@list l0:level4
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:144.0pt;
mso-level-number-position:left;
text-indent:-18.0pt;
mso-ansi-font-size:10.0pt;
font-family:Symbol;}
@list l0:level5
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:180.0pt;
mso-level-number-position:left;
text-indent:-18.0pt;
mso-ansi-font-size:10.0pt;
font-family:Symbol;}
@list l0:level6
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:216.0pt;
mso-level-number-position:left;
text-indent:-18.0pt;
mso-ansi-font-size:10.0pt;
font-family:Symbol;}
@list l0:level7
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:252.0pt;
mso-level-number-position:left;
text-indent:-18.0pt;
mso-ansi-font-size:10.0pt;
font-family:Symbol;}
@list l0:level8
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:288.0pt;
mso-level-number-position:left;
text-indent:-18.0pt;
mso-ansi-font-size:10.0pt;
font-family:Symbol;}
@list l0:level9
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:324.0pt;
mso-level-number-position:left;
text-indent:-18.0pt;
mso-ansi-font-size:10.0pt;
font-family:Symbol;}
@list l1
{mso-list-id:685137999;
mso-list-template-ids:230059924;}
@list l2
{mso-list-id:991565643;
mso-list-type:hybrid;
mso-list-template-ids:1994002526 74317825 74317827 74317829 74317825 74317827 74317829 74317825 74317827 74317829;}
@list l2:level1
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-18.0pt;
font-family:Symbol;}
@list l2: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 l2:level3
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-18.0pt;
font-family:Wingdings;}
@list l2:level4
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-18.0pt;
font-family:Symbol;}
@list l2: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 l2:level6
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-18.0pt;
font-family:Wingdings;}
@list l2:level7
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-18.0pt;
font-family:Symbol;}
@list l2: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 l2:level9
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-18.0pt;
font-family:Wingdings;}
@list l3
{mso-list-id:1214855733;
mso-list-type:hybrid;
mso-list-template-ids:-1780857610 74317839 74317849 74317851 74317839 74317849 74317851 74317839 74317849 74317851;}
@list l3:level1
{mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-18.0pt;}
@list l3:level2
{mso-level-number-format:alpha-lower;
mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-18.0pt;}
@list l3:level3
{mso-level-number-format:roman-lower;
mso-level-tab-stop:none;
mso-level-number-position:right;
text-indent:-9.0pt;}
@list l3:level4
{mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-18.0pt;}
@list l3:level5
{mso-level-number-format:alpha-lower;
mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-18.0pt;}
@list l3:level6
{mso-level-number-format:roman-lower;
mso-level-tab-stop:none;
mso-level-number-position:right;
text-indent:-9.0pt;}
@list l3:level7
{mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-18.0pt;}
@list l3:level8
{mso-level-number-format:alpha-lower;
mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-18.0pt;}
@list l3:level9
{mso-level-number-format:roman-lower;
mso-level-tab-stop:none;
mso-level-number-position:right;
text-indent:-9.0pt;}
@list l4
{mso-list-id:1591039099;
mso-list-template-ids:1506475274;}
@list l4:level1
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:36.0pt;
mso-level-number-position:left;
text-indent:-18.0pt;
mso-ansi-font-size:10.0pt;
font-family:Symbol;}
@list l4:level2
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:72.0pt;
mso-level-number-position:left;
text-indent:-18.0pt;
mso-ansi-font-size:10.0pt;
font-family:Symbol;}
@list l4:level3
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:108.0pt;
mso-level-number-position:left;
text-indent:-18.0pt;
mso-ansi-font-size:10.0pt;
font-family:Symbol;}
@list l4:level4
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:144.0pt;
mso-level-number-position:left;
text-indent:-18.0pt;
mso-ansi-font-size:10.0pt;
font-family:Symbol;}
@list l4:level5
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:180.0pt;
mso-level-number-position:left;
text-indent:-18.0pt;
mso-ansi-font-size:10.0pt;
font-family:Symbol;}
@list l4:level6
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:216.0pt;
mso-level-number-position:left;
text-indent:-18.0pt;
mso-ansi-font-size:10.0pt;
font-family:Symbol;}
@list l4:level7
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:252.0pt;
mso-level-number-position:left;
text-indent:-18.0pt;
mso-ansi-font-size:10.0pt;
font-family:Symbol;}
@list l4:level8
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:288.0pt;
mso-level-number-position:left;
text-indent:-18.0pt;
mso-ansi-font-size:10.0pt;
font-family:Symbol;}
@list l4:level9
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:324.0pt;
mso-level-number-position:left;
text-indent:-18.0pt;
mso-ansi-font-size:10.0pt;
font-family:Symbol;}
@list l5
{mso-list-id:1941718043;
mso-list-type:hybrid;
mso-list-template-ids:849772308 74317825 74317827 74317829 74317825 74317827 74317829 74317825 74317827 74317829;}
@list l5:level1
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-18.0pt;
font-family:Symbol;}
@list l5: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 l5:level3
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-18.0pt;
font-family:Wingdings;}
@list l5:level4
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-18.0pt;
font-family:Symbol;}
@list l5: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 l5:level6
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-18.0pt;
font-family:Wingdings;}
@list l5:level7
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-18.0pt;
font-family:Symbol;}
@list l5: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 l5:level9
{mso-level-number-format:bullet;
mso-level-text:;
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,<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="DE"><o:p> </o:p></span></p>
<p class="MsoNormal"><span lang="DE">dank des Hinweises von Günter, dass es sich hier wohl eher um ein „QGIS-Problem“ handelt, scheine ich die Antwort auf meine Frage schon gefunden zu haben.
<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 musste in den „Layer Properties“ in QGIS an Stelle des Widget Type „Relation Reference“ den Widget Type „Value Relation“ auswählen, diesen kann ich alphabetisch sortieren („Order by value“) – Screenshots dazu im Anhang.
Dann scheint es zu funktionieren. </span><span lang="DE" style="font-family:"Segoe UI Emoji",sans-serif">😊</span><span lang="DE"> Zumindest im Test-Projekt.<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="DE"><o:p> </o:p></span></p>
<p class="MsoNormal"><span lang="DE">Zur Frage mit dem <b>„doppelten“ Dropdown-Menü
</b>könnte hier die Lösung liegen, das muss ich dann noch ausprobieren: <a href="https://www.youtube.com/watch?v=mtpUP5n_78E">
https://www.youtube.com/watch?v=mtpUP5n_78E</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">Herzlichen Dank 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>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;margin-bottom:6.0pt"><span 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 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_1889165073" src="cid:image001.png@01DB1576.3F300F00" alt="sias"></span><o:p></o:p></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="FR-LU" style="font-size:15.0pt;line-height:105%;font-family:"Calibri",sans-serif;color:#946B43">Tobias Mosthaf</span><span lang="FR-LU" style="font-size:12.0pt;line-height:105%">
<br>
</span><b><span lang="FR-LU" style="font-size:12.0pt;line-height:105%;font-family:"Calibri",sans-serif;color:#EE7D00">Natura 2000<br>
</span></b><b><span lang="FR-LU" style="font-size:12.0pt;line-height:105%;font-family:"Calibri",sans-serif;color:#946B43">T
</span></b><span lang="FR-LU" 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-LU" 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-LU" style="font-size:12.0pt;line-height:105%;color:#946B43;text-decoration:none">t.mosthaf@sias.lu</span></a><span style="font-size:12.0pt;line-height:105%">
</span><o:p></o:p></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="FR-LU" style="font-size:15.0pt;line-height:105%;font-family:"Calibri",sans-serif;color:#946B43"> </span><span 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="Image_x0020_9" src="cid:image002.png@01DB1576.3F300F00" alt="Une image contenant texte, capture d’écran, dessin humoristique, Graphique
Description générée automatiquement"></span><span lang="FR-LU" 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 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 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 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 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 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 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 style="font-size:12.0pt;font-family:"Calibri",sans-serif;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_1299119703" src="cid:image003.png@01DB1576.3F300F00"></span></a><span lang="EN-US" style="font-size:12.0pt;mso-fareast-language:LB-LU"> </span><a href="https://www.youtube.com/channel/UClGQbc7ugXYy7jw7j547g7w"><span style="font-size:12.0pt;font-family:"Calibri",sans-serif;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_1559534112" src="cid:image004.png@01DB1576.3F300F00"></span></a><span lang="EN-US" style="font-size:12.0pt;mso-fareast-language:LB-LU"> </span><a href="https://www.youtube.com/channel/UClGQbc7ugXYy7jw7j547g7w"><span style="font-size:12.0pt;font-family:"Calibri",sans-serif;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_1950667132" src="cid:image005.png@01DB1576.3F300F00"></span></a><span lang="EN-US" style="font-size:12.0pt;mso-fareast-language:LB-LU"> <br>
</span><span style="font-size:11.5pt;font-family:Webdings;color:#C8D400;mso-fareast-language:LB-LU">P</span><span 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="EN-US" style="font-size:12.0pt;mso-fareast-language:LB-LU"><o:p></o:p></span></p>
</div>
<p class="MsoNormal"><o:p> </o:p></p>
<div>
<div style="border:none;border-top:solid #E1E1E1 1.0pt;padding:3.0pt 0cm 0cm 0cm">
<p class="MsoNormal"><b><span lang="FR" style="font-family:"Calibri",sans-serif;mso-ligatures:none;mso-fareast-language:LB-LU">De :</span></b><span lang="FR" style="font-family:"Calibri",sans-serif;mso-ligatures:none;mso-fareast-language:LB-LU"> Lizmap-de <lizmap-de-bounces@lists.osgeo.org>
<b>De la part de</b> Tobias Mosthaf via Lizmap-de<br>
<b>Envoyé :</b> 02. Oktober2024 21:32<br>
<b>À :</b> lizmap-de@lists.osgeo.org<br>
<b>Objet :</b> [Lizmap-de] Lizmap - Dropdown-Menü sortieren<o:p></o:p></span></p>
</div>
</div>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal"><span lang="DE">Hallo in die Runde,<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 (</span><a href="https://test.siasportail.lu/"><span lang="DE">https://test.siasportail.lu/</span></a><span lang="DE">, 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:l3 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:l3 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
</span><a href="https://www.sqlmaestro.com/products/mysql/phpgenerator/help/editors_dynamic_cascading_combobox/"><span lang="DE">https://www.sqlmaestro.com/products/mysql/phpgenerator/help/editors_dynamic_cascading_combobox/</span></a><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">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:l2 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:l2 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:l2 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:l2 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:l2 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:l2 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:l2 level1 lfo6"><span lang="DE">PHP Version: 8.3<o:p></o:p></span></li></ul>
<ul style="margin-top:0cm" type="disc">
<li class="MsoListParagraph" style="margin-left:0cm;mso-list:l5 level1 lfo9"><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" style="width:411.75pt">
<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="_x0000_i1029" src="cid:image001.png@01DB1576.3F300F00" 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="Image_x0020_4" src="cid:image002.png@01DB1576.3F300F00" 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;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@01DB1576.3F300F00"></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;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_2" src="cid:image004.png@01DB1576.3F300F00"></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;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_1" src="cid:image005.png@01DB1576.3F300F00"></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>