Seitenhistorie

String baseSQL

<param name="SQL" type="String" value="&quot;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,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="&amp;nbsp;"/>

int minLength

<param type="int" value="1"/>

boolean isUseCache

<param type="boolean" value="true"/>