Geographic Information Systems Stack Exchange is a question and answer site for cartographers, geographers and GIS professionals. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

In Geoserver i create parametric view:

FROM MyTable
LEFT JOIN Track On MyTable.SegmentID=Track.SegmentID
WHERE (DATEPART(yy, MyTable.Date)=%year%
AND DATEPART(mm, MyTable.Date)=%month%
AND DATEPART(dd, MyTable.Date)=%day%)

i set default values 2009-09-18

Now i go in layer preview pick my layer and see layer with features with Date=2009-09-18.
Now i want to see features with another date. In address line i add:


But still see same features. I try another dates but not help.
Whats wrong?

share|improve this question
is that %mounth% correct? or just a typo here? – iant Apr 25 '13 at 10:49
Yeah %month% of course. Just a typo. – Kliver Max Apr 26 '13 at 3:54
up vote 0 down vote accepted

I dont know what heppens with my view but i delete all parameters except one and try it. And use viewparams parameter in Layer Preview i get features. After i add another parameters in view and my final view:

FROM myTable
LEFT JOIN Track ON Segment_ID.Segment_ID=Track.Segment_ID
where (DATEPART(yy, myTable.Date) = %year%
AND DATEPART(mm, myTable.Date) = %mounth%
AND DATEPART(dd, myTable.Date) = %day%
AND DATEPART(hh, myTable.Date) = %hour%)

And Layer Preview address look like:


I think my problem was with Bouding Box. It was too small.

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.