[Geoserver-users] WMS Date filters not working with MongoDB

GeoServer GeoServer User
1

I am creating a date filter like so

<PropertyIsGreaterThan>
  <PropertyName>
    date
  </PropertyName>
  <Function name="parseDate">
    <Literal>yyyy-MM-dd</Literal>
    <Literal>2015-07-01</Literal>
  </Function>
</PropertyIsGreaterThan>

The query string getting sent to MongoDB from geoserver looks like
{
  "date" : {
    "$gt" : "Wed Jul 01 00:00:00 UTC 2015"
  }
}

But the query returns nothing. That is because the date is getting passed into Mongo as a string instead of a Date.

The query below is what the query generated by geoserver should look like
{
  "date" : {
    "$gt" : ISODate("2015-07-01T00:00:00Z")
  }
}

I know that the MongoDB store is unsupported. I am just looking for hints so I can fix the problem.
Can someone point me to the class that builds the query string?

Thanks,

Nathan

2

Hi Nathan,
Some devs do read this list, but your question may be better suited to the Dev List.
Cheers,
Jonathan

-----Original Message-----
From: Reese, Nathan [mailto:nreese@anonymised.com]
Sent: Thursday, July 23, 2015 9:42 PM
To: geoserver-users@lists.sourceforge.net
Subject: [Geoserver-users] WMS Date filters not working with MongoDB

I am creating a date filter like so

<PropertyIsGreaterThan>
  <PropertyName>
    date
  </PropertyName>
  <Function name="parseDate">
    <Literal>yyyy-MM-dd</Literal>
    <Literal>2015-07-01</Literal>
  </Function>
</PropertyIsGreaterThan>

The query string getting sent to MongoDB from geoserver looks like {
  "date" : {
    "$gt" : "Wed Jul 01 00:00:00 UTC 2015"
  }
}

But the query returns nothing. That is because the date is getting passed into Mongo as a string instead of a Date.

The query below is what the query generated by geoserver should look like {
  "date" : {
    "$gt" : ISODate("2015-07-01T00:00:00Z")
  }
}

I know that the MongoDB store is unsupported. I am just looking for hints so I can fix the problem.
Can someone point me to the class that builds the query string?

Thanks,

Nathan
------------------------------------------------------------------------------
_______________________________________________
Geoserver-users mailing list
Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users

This message has been scanned for viruses by MailControl - www.mailcontrol.com

Click https://www.mailcontrol.com/sr/iF6Y!MbV1r7GX2PQPOmvUhStAXlT3N1zrYlqvsNWsE!zyYM5I1KuElmbQOkV7RLv!XW!bVrg2Z4DMGoTToeXlw== to report this email as spam.

________________________________

HR Wallingford and its subsidiaries uses faxes and emails for confidential and legally privileged business communications. They do not of themselves create legal commitments. Disclosure to parties other than addressees requires our specific consent. We are not liable for unauthorised disclosures nor reliance upon them.
If you have received this message in error please advise us immediately and destroy all copies of it.

HR Wallingford Limited
Howbery Park, Wallingford, Oxfordshire, OX10 8BA, United Kingdom
Registered in England No. 02562099

________________________________