...
Abfrage | Beispiel |
|---|---|
String baseSQL | <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 searchFunctionConf | <param type="String[]" value="cCode,landid_${LANGUAGE},kategorie,datum,zeit_${LANGUAGE},titel_${LANGUAGE},ort_${LANGUAGE},sprache_${LANGUAGE},kurstag1_${LANGUAGE},hinweiskurstag2_${LANGUAGE}"/> |
String[] displayFieldsConf | <param type="String[]" value="cCodedatum,landtitel_${LANGUAGE},hinweisort_${LANGUAGE}"/> |
String[] updateFieldsConf | <param type="String[]" value="landid_${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}+hinweissprache_${LANGUAGE}['xpath':'.';'valueCol':'cCodesprache_${LANGUAGE}'],cCodesprache_${LANGUAGE}['xpath':'risikolandf_sprache'],landid_${LANGUAGE}+hinweiskurstag1_${LANGUAGE}['xpath':'.';'valueCol':'landkurstag1_${LANGUAGE}'],landkurstag1_${LANGUAGE}['xpath':'risikolandf_fullkurstag1'],landid_${LANGUAGE}+hinweiskurstag2_${LANGUAGE}['xpath':'.';'valueCol':'hinweiskurstag2_${LANGUAGE}'],hinweiskurstag2_${LANGUAGE}['xpath':'hinweisf_kurstag2']"/> |
String seperator | <param type="String" value="&nbsp;"/> |
int minLength | <param type="int" value="1"/> |
boolean isUseCache | <param type="boolean" value="true"/> |
...