Hello
I have written a function in Oracle which allows to extract geographical and
statistical data from a view which has been added as a featuretype (the view
not the function) in GeoServer.
FUNCTION MyGeoServerResult(My_Gear in number, my_Species in number, my_year
in number ) RETURN myTableType PIPELINED IS
BEGIN
select ID_GEO,sum_value,geometry from
(
select ID_GEO
, sum(TS_VALUE) over (partition by ID_GEO) sum_value
, geometry
, row_number() over (partition by ID_GEO order by rownum) rn
, YR_TA
from MyView
where CD_GEAR in(My_Gear)and cd_species in (my_Species) and cd_year
in(my_year)
)
where rn = 1
END;
This function when passing parameter such as MyGeoServerResult (801,
2497,1999) allow to generate this kind of result for a specific year, a
specific gear and a specific species:
Geometry_|_ID_GEO_|_SUM_Value
Polygon1_|__1______|__12
Polygon2_|__2______|__16
This result should be then used by Geoserver to create a map.
The best for me would be to pass in the Geoserver URL the parameters
allowing to generate this result table.
Would it be feasible? What would be the other option?
Instead of calling a function, could i send directly the Select query -based
on ogc filter syntax- in the URL?
The idea is to send the query to the DB through the GeoServer URL to get a
result directly usable by Geoserver to build the map.
Thanks for your help
Sylvain
--
View this message in context: http://www.nabble.com/Oracle-Function---passing-Parameters-tp17273288p17273288.html
Sent from the GeoServer - User mailing list archive at Nabble.com.