WebGIS Discussions

Need a push in the right direction when configuring WebMap, Portal or SDI services? Looking for hints and tips, or just looking for Ideas and information? The WebGIS discussion board is where you start those discussions, connect and share information.
Showing results for 
Search instead for 
Do you mean 
Reply
Highlighted
New Contributor
Posts: 2
Registered: ‎11-30-2016

Query by date

I have a number of Oracle tables with date fields and would like my webmap users to query these tables based on date ranges.  Is it possible to build and publish such a query in GeoMedia WebMap 15?

Highlighted
Technical Evangelist
Posts: 355
Registered: ‎02-04-2016

Re: Query by date

[ Edited ]

Hi Rogi,

 

Here is a sample WMPS query with Oracle DATE field:

 

Query_by_DATE.png

 

The whereclause should look something like:

where adate < to_timestamp('!DATPAR!', 'DD-MM-YYYY')

 

This is a working example from WebMap Publisher v6.1 but it should work the same way in v16 WebMap Publisher Administrator where you create the WMPS predefined query.

 

Hope this helps.

 

Frank

Highlighted
New Contributor
Posts: 2
Registered: ‎11-30-2016

Re: Query by date

Thanks for your help Frank.