Unterschiede
Hier werden die Unterschiede zwischen zwei Versionen angezeigt.
| Beide Seiten der vorigen Revision Vorhergehende Überarbeitung Nächste Überarbeitung | Vorhergehende Überarbeitung | ||
| playground:prodliste:mainmenue [2023/08/03 07:40] – 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 ====== | ====== Liste der Q-meldungen ====== | ||
| Zeile 6: | Zeile 6: | ||
| < | < | ||
| - | <sql> select q_meldung.Lfd_Nr as Nummer, | + | <sql> select q_meldung.Lfd_Nr as ' |
| + | q_meldung.erstellt_am as ' | ||
| CONVERT(CAST(CONVERT(Gemeldet_von USING latin1) AS BINARY) USING utf8) as ' | CONVERT(CAST(CONVERT(Gemeldet_von USING latin1) AS BINARY) USING utf8) as ' | ||
| CONVERT(CAST(CONVERT(Ursprung USING latin1) AS BINARY) USING utf8) as Ursprung, | CONVERT(CAST(CONVERT(Ursprung USING latin1) AS BINARY) USING utf8) as Ursprung, | ||
| Zeile 12: | Zeile 13: | ||
| CONVERT(CAST(CONVERT(Bezeichnung USING latin1) AS BINARY) USING utf8) as Bezeichnung, | CONVERT(CAST(CONVERT(Bezeichnung USING latin1) AS BINARY) USING utf8) as Bezeichnung, | ||
| CONVERT(CAST(CONVERT(Menge USING latin1) AS BINARY) USING utf8) as ' | CONVERT(CAST(CONVERT(Menge USING latin1) AS BINARY) USING utf8) as ' | ||
| + | CONVERT(CAST(CONVERT(Reklamationsgrund USING latin1) AS BINARY) USING utf8) as Reklamationsgrund, | ||
| CONVERT(CAST(CONVERT(geschaetzter_Nacharbeitsaufwand USING latin1) AS BINARY) USING utf8) as ' | CONVERT(CAST(CONVERT(geschaetzter_Nacharbeitsaufwand USING latin1) AS BINARY) USING utf8) as ' | ||
| CONVERT(CAST(CONVERT(Materialkosten_Nacharbeit USING latin1) AS BINARY) USING utf8) as ' | CONVERT(CAST(CONVERT(Materialkosten_Nacharbeit USING latin1) AS BINARY) USING utf8) as ' | ||