I’ve created a layer using a parameterized query as a database view. I see how I can pass in arguments for the parameters using viewparams=p1:v1;… in the GetMap request. However, I would like to pass a dimension value from the GetMap request into the view as the argument. Is there any way to do this without forcing the client to copy the dimension value into the viewparams query string parameter?
Thanks,
Tom
On Thu, Oct 29, 2015 at 11:26 PM, Ruff, Thomas <THOMAS.RUFF@anonymised.com> wrote:
I've created a layer using a parameterized query as a database view. I
see how I can pass in arguments for the parameters using
viewparams=p1:v1;... in the GetMap request. However, I would like to pass
a dimension value from the GetMap request into the view as the argument.
Is there any way to do this without forcing the client to copy the
dimension value into the viewparams query string parameter?
No, not possible (unless we change the code somehow)... but I doubt it can
be made to easily work
in general, as dimension values can be provided in a number of ways,
instant, multiple values, range,
values relative to a reference, I sort of have a hard time picturing a sql
query that can seamlessly
handle them all (yes, a stored procedure or a custom function could of
course, still, it would
have to duplicate quite a bit of GeoServer own code).
Cheers
Andrea
Ing. Andrea Aime
@geowolf
Technical Lead
GeoSolutions S.A.S.
Via Poggio alle Viti 1187
55054 Massarosa (LU)
Italy
phone: +39 0584 962313
fax: +39 0584 1660272
mob: +39 339 8844549
http://www.geo-solutions.it
http://twitter.com/geosolutions_it
*AVVERTENZE AI SENSI DEL D.Lgs. 196/2003*
Le informazioni contenute in questo messaggio di posta elettronica e/o
nel/i file/s allegato/i sono da considerarsi strettamente riservate. Il
loro utilizzo è consentito esclusivamente al destinatario del messaggio,
per le finalità indicate nel messaggio stesso. Qualora riceviate questo
messaggio senza esserne il destinatario, Vi preghiamo cortesemente di
darcene notizia via e-mail e di procedere alla distruzione del messaggio
stesso, cancellandolo dal Vostro sistema. Conservare il messaggio stesso,
divulgarlo anche in parte, distribuirlo ad altri soggetti, copiarlo, od
utilizzarlo per finalità diverse, costituisce comportamento contrario ai
principi dettati dal D.Lgs. 196/2003.
The information in this message and/or attachments, is intended solely for
the attention and use of the named addressee(s) and may be confidential or
proprietary in nature or covered by the provisions of privacy act
(Legislative Decree June, 30 2003, no.196 - Italy's New Data Protection
Code).Any use not in accord with its purpose, any disclosure, reproduction,
copying, distribution, or either dissemination, either whole or partial, is
strictly forbidden except previous formal approval of the named
addressee(s). If you are not the intended recipient, please contact
immediately the sender by telephone, fax or e-mail and delete the
information in this message that has been received in error. The sender
does not give any warranty or accept liability as the content, accuracy or
completeness of sent messages and accepts no responsibility for changes
made after they were sent or for other risks which arise as a result of
e-mail transmission, viruses, etc.
-------------------------------------------------------