ogc:IsLessThan, ogc:IsGreaterThen
sql like
filter:
(
( `t`.`A_RECORD_CREATE_DATE` < '2015-12-01' or `t`.`A_RECORD_CREATE_DATE` <= '2015-12-01' )
and ( `t`.`A_RECORD_UPDATE_DATE` > '2016-06-01' or `t`.`A_RECORD_UPDATE_DATE` >= '2016-06-01' )
)
POST on
?SERVICE=WFS&VERSION=1.0.0&REQUEST=GetFeature&TYPENAME=p5_default_db:TEST_PERMS&SRSNAME=EPSG:3003
<GetFeature xmlns="http://www.opengis.net/wfs/2.0"
xmlns:ogc="http://www.opengis.net/ogc"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
service="WFS"
version="2.0.2"
xsi:schemaLocation="http://www.opengis.net/wfs/2.0 http://schemas.opengis.net/wfs/2.0/wfs.xsd">
<ogc:Filter>
<ogc:And>
<ogc:Or>
<ogc:PropertyIsLessThan>
<ogc:PropertyName>A_RECORD_CREATE_DATE</ogc:PropertyName>
<ogc:Literal>2015-12-01</ogc:Literal>
</ogc:PropertyIsLessThan>
<ogc:PropertyIsLessThanOrEqualTo>
<ogc:PropertyName>A_RECORD_CREATE_DATE</ogc:PropertyName>
<ogc:Literal>2015-12-01</ogc:Literal>
</ogc:PropertyIsLessThanOrEqualTo>
</ogc:Or>
<ogc:Or>
<ogc:PropertyIsGreaterThan>
<ogc:PropertyName>A_RECORD_UPDATE_DATE</ogc:PropertyName>
<ogc:Literal>2016-06-01</ogc:Literal>
</ogc:PropertyIsGreaterThan>
<ogc:PropertyIsGreaterThanOrEqualTo>
<ogc:PropertyName>A_RECORD_UPDATE_DATE</ogc:PropertyName>
<ogc:Literal>2016-06-01</ogc:Literal>
</ogc:PropertyIsGreaterThanOrEqualTo>
</ogc:Or>
</ogc:And>
</ogc:Filter>
</GetFeature>