CMDBuild Forum

How pass input parameter to a SQL VIEW

Old Versions
#1

Hi, I created my first SQL Views . 

I followed  the exemple that  suggest  the Administration Manual but i'm not understand if it is possible to pass a input parameter to a View. My function is :

CREATE OR REPLACE FUNCTION public.prova_email(seriale text, OUT mail text)

 RETURNS text

 LANGUAGE plpgsql

AS $function$BEGIN

EXECUTE 'SELECT "Supplier"."email"

FROM "Asset", "Supplier"

 WHERE "Asset"."Supplier"="Supplier"."Id"

 and "Asset"."Serial"='||quote_literal(seriale) INTO mail;

 END

 $function$

 

 

 THANKS

#2

At the moment CMDBuild Views don’t allow you to define parameters.
CMDBuild Team

#3

Will you integrate this feature in your next update?

 

Regards.

 

#4

It is currently not among the new features already planned.
CMDBuild Team