Unterschiede

Hier werden die Unterschiede zwischen zwei Versionen angezeigt.

--- playground:prodliste:mainmenue [2023/08/03 06:33] – andretzky
+++ playground:prodliste:mainmenue [2025/08/28 12:40] (aktuell) – Externe Bearbeitung 127.0.0.1
@@ Zeile 1: / Zeile 1: @@
-====== Auswahlliste Test ======
 ====== Liste der Q-meldungen ======
@@ Zeile 6: / Zeile 6: @@
 <datatables dom="Bfrtip" buttons=' [ "copy" ]'>
-<sql>select Lfd_Nr as 'Lfd. Nr', erstellt_am as 'Datum',
+<sql> select q_meldung.Lfd_Nr as 'Lfd-Nr.',
+q_meldung.erstellt_am as 'Datum',
 CONVERT(CAST(CONVERT(Gemeldet_von USING latin1) AS BINARY) USING utf8) as 'Gemeldet von',
 CONVERT(CAST(CONVERT(Ursprung USING latin1) AS BINARY) USING utf8) as Ursprung,
 CONVERT(CAST(CONVERT(Kunden USING latin1) AS BINARY) USING utf8) as 'Kunden/Lieferant',
 CONVERT(CAST(CONVERT(Bezeichnung USING latin1) AS BINARY) USING utf8) as Bezeichnung,
 CONVERT(CAST(CONVERT(Menge USING latin1) AS BINARY) USING utf8) as 'Anz.',
+CONVERT(CAST(CONVERT(Reklamationsgrund USING latin1) AS BINARY) USING utf8) as Reklamationsgrund,
+CONVERT(CAST(CONVERT(geschaetzter_Nacharbeitsaufwand USING latin1) AS BINARY) USING utf8) as 'Nacharbeitsaufwand',
+CONVERT(CAST(CONVERT(Materialkosten_Nacharbeit USING latin1) AS BINARY) USING utf8) as 'Materialkosten'
-CONVERT(CAST(CONVERT(Reklamationsgrund USING latin1) AS BINARY) USING utf8) as Reklamationsgrund from q_meldung;</sql>
+ from qm_massnahmen, q_meldung WHERE qm_massnahmen.Lfd_Nr = q_meldung.Lfd_Nr
+;</sql>
 </datatable>