Struktur der SQL-Abfrage
Abfrage | Beispiel |
|---|---|
String baseSQL | <param name="SQL" type="String" value=""SELECT * FROM (SELECT * FROM (SELECT MAX(CASE WHEN `KEY` = 'land_" + XUI_LANGUAGE + "' THEN value END) AS `land_" + XUI_LANGUAGE + "`, MAX(CASE WHEN `KEY` = 'hinweis_" + XUI_LANGUAGE + "' THEN value END) AS `hinweis_" + XUI_LANGUAGE + "`, MAX(CASE WHEN `KEY` = 'cCode' THEN value END) AS `cCode`, MAX(CASE WHEN `KEY` = 'status' THEN value END) AS `status` FROM JAX_DATAPOOL WHERE (SOURCE_GUID = '083d2d9a-499c-4196-b353-6d49f2e32e7b') GROUP BY POS) AS MATRIX) AS MatrixSummary WHERE STATUS = 'aktiv' ${WHERE_APPEND} order by land_" + XUI_LANGUAGE + " asc ""/> |
String searchFunctionConf | <param type="String[]" value="cCode,land_${LANGUAGE},hinweis_${LANGUAGE}"/> |
String[] displayFieldsConf | <param type="String[]" value="cCode,land_${LANGUAGE},hinweis_${LANGUAGE}"/> |
String[] updateFieldsConf | <param type="String[]" value="land_${LANGUAGE}+hinweis_${LANGUAGE}['xpath':'.';'valueCol':'cCode'],cCode['xpath':'risikoland'],land_${LANGUAGE}+hinweis_${LANGUAGE}['xpath':'.';'valueCol':'land_${LANGUAGE}'],land_${LANGUAGE}['xpath':'risikoland_full'],land_${LANGUAGE}+hinweis_${LANGUAGE}['xpath':'.';'valueCol':'hinweis_${LANGUAGE}'],hinweis_${LANGUAGE}['xpath':'hinweis']"/> |
String seperator | <param type="String" value="&nbsp;"/> |
int minLength | <param type="int" value="1"/> |
boolean isUseCache | <param type="boolean" value="true"/> |