X-Git-Url: https://git.infodrom.org/?p=misc%2Fhallinta-metro;a=blobdiff_plain;f=artikel.php;h=2bb5744b6a97dd4cd400294a7665ee25a5eb8f85;hp=e4eb9567222f3202d01e4cc688da91d8b7785be0;hb=82f814cbf0260daa1e8d5f35e1e5c46a087fb70d;hpb=18c6d68debc9e7c83f7854b49cd082442cc9f5f8

diff --git a/artikel.php b/artikel.php
index e4eb956..2bb5744 100644
--- a/artikel.php
+++ b/artikel.php
@@ -175,6 +175,7 @@ $mask = array(
 					    'width' => 200,
 					    'specs' => "filterUI: 's'",
 					    'control' => "new Rico.TableColumn.lookup(".grid_lookup_sql('metro_abteilung','id','name').", 0, '')",
+					    'distinct' => "SELECT DISTINCT abteilung,metro_abteilung.name FROM metro_artikel JOIN metro_abteilung ON abteilung = metro_abteilung.id ORDER BY name",
 					    'visible' => false,
 					    ),
 			      'gang' => array(
@@ -188,6 +189,7 @@ $mask = array(
 					    'width' => 70,
 					    'specs' => "ClassName: 'aligncenter', filterUI: 's'",
 					    'control' => "new Rico.TableColumn.lookup(".grid_lookup_sql('metro_vpe','id','name').", 0, '')",
+					    'distinct' => "SELECT DISTINCT vpe,metro_vpe.name FROM metro_artikel JOIN metro_vpe ON vpe = metro_vpe.id ORDER BY name",
 					    ),
 			      ),
 	      'edit' => array(