12-06-2016 11:29 PM
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?
12-07-2016 08:26 AM - edited 12-07-2016 08:27 AM
Here is a sample WMPS query with Oracle DATE field:
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.