If id is the fid (and possibly even if it isn't) then it is a special
attribute and I suspect it is handled differently in the filters as is
hinted at http://docs.geotools.org/stable/userguide/library/cql/ecql.html.
Try something like:
Data_col<'03/21/2018' and in (2)
and see if that works.
For speed I'd reverse the order of the query as checking the ID is likely
to be much quicker than looking at all the dates.
Ian
On Sun, 8 Jul 2018 at 08:44, Maria Krommyda via Geoserver-users <
[email protected]> wrote:
> Dear all,
>
> I have been trying for a couple days now to solve a very frustrating issue
> and I am hoping that you can provide me with some help.
>
> I have set up Geoserver over an Accumulo datastore, when creating the
> layer I can see all the parameters and when I download all the dataset as
> one JSON file, I have no issues at all.
>
> My issues start when I try to add the &cql_filter.
>
> I want to query two of the parameters at once, so I do
> (working_uri_that_gives_all_data_as_json)&cql_filter=(Data_col<'03/21//2018'
> and id=2)
>
> When I try this URI from my web-browser only the first restriction is
> taken into account, and when I try to sent it from JAVA as an HTTP request
> I get a URI malformed error.
>
> I have tried adding single quotes around all the elements, adding or
> eliminating spaces between words, and anything else that could cross my
> mind but nothing seems to be working.
>
> I have full control over the format of the URI so I can replace anything
> with the corresponding special character if that would help.
>
> I am not sure if I am making an obvious mistake or not, but I would be
> greatful for any help.
>
> Best regards,
> Maria.
>
> ------------------------------------------------------------------------------
> Check out the vibrant tech community on one of the world's most
> engaging tech sites, Slashdot.org! http://sdm.link/slashdot
> _______________________________________________
> Geoserver-users mailing list
>
> Please make sure you read the following two resources before posting to
> this list:
> - Earning your support instead of buying it, but Ian Turton:
> http://www.ianturton.com/talks/foss4g.html#/
> - The GeoServer user list posting guidelines:
> http://geoserver.org/comm/userlist-guidelines.html
>
> If you want to request a feature or an improvement, also see this:
> https://github.com/geoserver/geoserver/wiki/Successfully-requesting-and-integrating-new-features-and-improvements-in-GeoServer
>
>
> [email protected]
> https://lists.sourceforge.net/lists/listinfo/geoserver-users
>
--
Ian Turton
------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot
_______________________________________________
Geoserver-users mailing list
Please make sure you read the following two resources before posting to this
list:
- Earning your support instead of buying it, but Ian Turton:
http://www.ianturton.com/talks/foss4g.html#/
- The GeoServer user list posting guidelines:
http://geoserver.org/comm/userlist-guidelines.html
If you want to request a feature or an improvement, also see this:
https://github.com/geoserver/geoserver/wiki/Successfully-requesting-and-integrating-new-features-and-improvements-in-GeoServer
[email protected]
https://lists.sourceforge.net/lists/listinfo/geoserver-users
