Feld vom Typ Plugin:
Struktur der SQL-Abfrage - Mehrsprachig
Abfrage | Beispiel |
|---|---|
String | <param name="SQL" type="String" value=""SELECT * FROM (SELECT * FROM (SELECT MAX(CASE WHEN 'KEY' = 'id_" + XUI_LANGUAGE + "' THEN value END) AS 'id_" + XUI_LANGUAGE + "', MAX(CASE WHEN 'KEY' = 'kategorie' THEN value END) AS 'kategorie', MAX(CASE WHEN 'KEY' = 'datum' THEN value END) AS 'datum', MAX(CASE WHEN 'KEY' = 'datum_technisch' THEN value END) AS 'datum_technisch', MAX(CASE WHEN 'KEY' = 'zeit_" + XUI_LANGUAGE + "' THEN value END) AS 'zeit_" + XUI_LANGUAGE + "', MAX(CASE WHEN 'KEY' = 'titel_" + XUI_LANGUAGE + "' THEN value END) AS 'titel_" + XUI_LANGUAGE + "', MAX(CASE WHEN 'KEY' = 'ort_" + XUI_LANGUAGE + "' THEN value END) AS 'ort_" + XUI_LANGUAGE + "', MAX(CASE WHEN 'KEY' = 'sprache_" + XUI_LANGUAGE + "' THEN value END) AS 'sprache_" + XUI_LANGUAGE + "', MAX(CASE WHEN 'KEY' = 'kurstag1_" + XUI_LANGUAGE + "' THEN value END) AS 'kurstag1_" + XUI_LANGUAGE + "', MAX(CASE WHEN 'KEY' = 'kurstag2_" + XUI_LANGUAGE + "' THEN value END) AS 'kurstag2_" + XUI_LANGUAGE + "' FROM JAX_DATAPOOL WHERE (SOURCE_GUID = '3e66c961-0f42-48a0-9683-e44a96d831c2') GROUP BY POS) AS MATRIX) AS MatrixSummary WHERE sprache_" + XUI_LANGUAGE + " = 'Deutsch' ${WHERE_APPEND} order by datum_technisch asc ""/> |
String | <param type="String[]" value="id_${LANGUAGE},kategorie,datum,zeit_${LANGUAGE},titel_${LANGUAGE},ort_${LANGUAGE},sprache_${LANGUAGE},kurstag1_${LANGUAGE},kurstag2_${LANGUAGE}"/> |
String[] | <param type="String[]" value="datum,titel_${LANGUAGE},ort_${LANGUAGE}"/> |
String[] | <param type="String[]" value="id_${LANGUAGE}['xpath':'.';'valueCol':'id_${LANGUAGE}'],id_${LANGUAGE}['xpath':'f_id'],id_${LANGUAGE}+kategorie['xpath':'.';'valueCol':'kategorie'],kategorie['xpath':'f_kategorie'],id_${LANGUAGE}+datum['xpath':'.';'valueCol':'datum'],datum['xpath':'f_datum'],id_${LANGUAGE}+zeit_${LANGUAGE}['xpath':'.';'valueCol':'zeit_${LANGUAGE}'],zeit_${LANGUAGE}['xpath':'f_zeit'],id_${LANGUAGE}+titel_${LANGUAGE}['xpath':'.';'valueCol':'titel_${LANGUAGE}'],titel_${LANGUAGE}['xpath':'f_titel'],id_${LANGUAGE}+ort_${LANGUAGE}['xpath':'.';'valueCol':'ort_${LANGUAGE}'],ort_${LANGUAGE}['xpath':'f_ort'],id_${LANGUAGE}+sprache_${LANGUAGE}['xpath':'.';'valueCol':'sprache_${LANGUAGE}'],sprache_${LANGUAGE}['xpath':'f_sprache'],id_${LANGUAGE}+kurstag1_${LANGUAGE}['xpath':'.';'valueCol':'kurstag1_${LANGUAGE}'],kurstag1_${LANGUAGE}['xpath':'f_kurstag1'],id_${LANGUAGE}+kurstag2_${LANGUAGE}['xpath':'.';'valueCol':'kurstag2_${LANGUAGE}'],kurstag2_${LANGUAGE}['xpath':'f_kurstag2']"/> |
String | <param type="String" value="&nbsp;"/> |
int | <param type="int" value="1"/> |
boolean | <param type="boolean" value="true"/> |
Struktur der SQL-Abfrage - Einsprachig
| String baseSQL | <param name="SQL" type="String" value=""SELECT * FROM (SELECT * FROM (SELECT MAX(CASE WHEN 'KEY' = 'id' THEN value END) AS 'id', MAX(CASE WHEN 'KEY' = 'kategorie' THEN value END) AS 'kategorie', MAX(CASE WHEN 'KEY' = 'datum' THEN value END) AS 'datum', MAX(CASE WHEN 'KEY' = 'datum_technisch' THEN value END) AS 'datum_technisch', MAX(CASE WHEN 'KEY' = 'zeit' THEN value END) AS 'zeit', MAX(CASE WHEN 'KEY' = 'titel' THEN value END) AS 'titel', MAX(CASE WHEN 'KEY' = 'ort' THEN value END) AS 'ort', MAX(CASE WHEN 'KEY' = 'sprache' THEN value END) AS 'sprache', MAX(CASE WHEN 'KEY' = 'kurstag1' THEN value END) AS 'kurstag1', MAX(CASE WHEN 'KEY' = 'kurstag2' THEN value END) AS 'kurstag2' FROM JAX_DATAPOOL WHERE (SOURCE_GUID = '3e66c961-0f42-48a0-9683-e44a96d831c2') GROUP BY POS) AS MATRIX) AS MatrixSummary WHERE sprache = 'Deutsch' ${WHERE_APPEND} order by datum_technisch asc ""/> |
| String searchFunctionConf | <param type="String[]" value="id,kategorie,datum,zeit,titel,ort,sprache,kurstag1,kurstag2"/> |
| String[] displayFieldsConf | <param type="String[]" value="datum,titel,ort"/> |
| String[] updateFieldsConf | <param type="String[]" value="id['xpath':'.';'valueCol':'id'],id['xpath':'f_id'],id+kategorie['xpath':'.';'valueCol':'kategorie'],kategorie['xpath':'f_kategorie'],id+datum['xpath':'.';'valueCol':'datum'],datum['xpath':'f_datum'],id+zeit['xpath':'.';'valueCol':'zeit'],zeit['xpath':'f_zeit'],id+titel['xpath':'.';'valueCol':'titel'],titel['xpath':'f_titel'],id+ort['xpath':'.';'valueCol':'ort'],ort['xpath':'f_ort'],id+sprache['xpath':'.';'valueCol':'sprache'],sprache['xpath':'f_sprache'],id+kurstag1['xpath':'.';'valueCol':'kurstag1'],kurstag1['xpath':'f_kurstag1'],id+kurstag2['xpath':'.';'valueCol':'kurstag2'],kurstag2['xpath':'f_kurstag2']"/> |
| String seperator | <param type="String" value="&nbsp;"/> |
| int minLength | <param type="int" value="1"/> |
| boolean isUseCache | <param type="boolean" value="true"/> |
Source definieren
Aktuelle Datenquelle aus dem Datapool:
SOURCE_GUID = '" + getCurrentDataPoolSourceGUID("GUID-DATA-POOL") + "'
Nicht vergessen die korrekte GUID des Datapool einzutragen (GUID-DATA-POOL).
Bestimmte Datenquellen-GUID:
SOURCE_GUID = 'GUID-DATENQUELLE'
Nicht vergessen die korrekte GUID der Datenquelle einzutragen (GUID-DATENQUELLE).
Ausgabe der Datapool-Daten im Formular:
