I want to add custom conditions to generic filter using jpqlFilter.
This jpql filters works if i dont use generic filter but inside genericFilter they are not loading items for some reason. Is this supported?
<genericFilter id="genericFilter"
width="100%"
classNames="shadow-xs"
dataLoader="propertiesDl"
opened="false"
autoApply="true"
applyShortcut="ENTER">
<properties include=".*"/>
<responsiveSteps>
<responsiveStep minWidth="0" columns="1" labelsPosition="TOP"/>
<responsiveStep minWidth="40em" columns="2" labelsPosition="TOP"/>
<responsiveStep minWidth="60em" columns="4" labelsPosition="TOP"/>
<responsiveStep minWidth="110em" columns="4" labelsPosition="ASIDE"/>
</responsiveSteps>
<conditions>
<jpqlFilter id="search"
parameterClass="java.lang.String"
label="msg://search.label">
<comboBox id="globalSearch"
clearButtonVisible="true"
width="100%"
pageSize="10">
<prefix>
<icon icon="SEARCH"/>
</prefix>
<itemsQuery escapeValueForLike="true"
searchStringFormat="(?i)%${inputString}%">
<query>
<![CDATA[
select distinct e.name
from Property e
where (e.hierarchy is null or (e.hierarchy <> 'ROOM' and e.hierarchy <> 'BED'))
and e.name like :searchString escape '\'
order by e.name asc
]]>
</query>
</itemsQuery>
</comboBox>
<condition>
<c:jpql>
<c:where>
<![CDATA[e.name LIKE CONCAT('%', ?, '%')]]>
</c:where>
</c:jpql>
</condition>
</jpqlFilter>
<jpqlFilter id="combinedStateFilter"
parameterClass="java.lang.String"
label="msg://combinedStateFilter.label">
<comboBox id="combinedState"
clearButtonVisible="true"
width="100%"
pageSize="10"
placeholder="msg://state">
<itemsQuery escapeValueForLike="true"
searchStringFormat="(?i)%${inputString}%">
<query>
<![CDATA[
select distinct concat(coalesce(e.state,''), '_', coalesce(e.rentState,''))
from Property e
where concat(coalesce(e.state,''), '_', coalesce(e.rentState,'')) like :searchString escape '\'
order by concat(coalesce(e.state,''), '_', coalesce(e.rentState,'')) asc
]]>
</query>
</itemsQuery>
</comboBox>
<condition>
<c:jpql>
<c:where>
<![CDATA[concat(coalesce(e.state,''), '_', coalesce(e.rentState,'')) LIKE CONCAT('%', ?, '%')]]>
</c:where>
</c:jpql>
</condition>
</jpqlFilter>
</conditions>
</genericFilter>