How can I add an array parameter to an sql view?
Ive seen an option for dimensionality requested in this thread http://osgeo-org.1560.x6.nabble.com/RFC-Parametric-SQL-View-Enhancement-Proposal-and-patch-td3823813.html by Rob but not answered.
And I cannot find a testcase for an array in geoserver source – (https://github.com/geoserver/geoserver/blob/646480bcc069464bc45600a5f4c59e4293513b77/src/ows/src/test/java/org/geoserver/ows/kvp/FormatOptionsKvpParserTest.java).
The sql view I would like to create is:
select * from imr_areavalue_with_avg_value(‘NorMar’,febr2014’, array[‘L10.0:20.0’], array[‘Q20001’, ‘Q20002’], 0.0, 19.0)
Endre
On Mon, Aug 11, 2014 at 1:28 PM, Moen Endre <endre.moen@anonymised.com> wrote:
How can I add an array parameter to an sql view?
Ive seen an option for dimensionality requested in this thread
http://osgeo-org.1560.x6.nabble.com/RFC-Parametric-SQL-View-Enhancement-Proposal-and-patch-td3823813.html
by Rob but not answered.
I don't know if the original patch got merged, but the ability to specify
multiple values
sets for different layers seems to be there, the ViewParamsKvpParser is
there and it's
used to parse sql view parameters into a list of arrays.
The sql view I would like to create is:
select * from imr_areavalue_with_avg_value('NorMar',febr2014',
array['L10.0:20.0'], array['Q20001', 'Q20002'], 0.0, 19.0)
Where would the parameters be in this query, and which values would you
like to assign?
Cheers
Andrea
--
GeoServer Professional Services from the experts! Visit
http://goo.gl/NWWaa2 for more information.
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
-------------------------------------------------------