CMDBuild Forum

FIlter by function

Programming and Web Services
#1

Hi
we have a filter, created like another one published by Tecnoteca.

Our filter is:

CREATE OR REPLACE FUNCTION public.wf_csi_im_filter_bycurrentperformer3(“UserId” bigint, “GroupId” bigint, “ClassName” character varying, OUT “Number” bigint)
RETURNS SETOF bigint
LANGUAGE plpgsql
AS $function$
BEGIN
RETURN QUERY
SELECT “Id” FROM “Customer” WHERE “Status” = ‘A’;
END;
$function$
;

COMMENT ON FUNCTION public.wf_csi_im_filter_bycurrentperformer3(int8,int8,varchar) IS ‘TYPE: function|TAGS:filterFn’;

– Permissions

ALTER FUNCTION public.wf_csi_im_filter_bycurrentperformer3(int8,int8,varchar) OWNER TO cmdbuild;
GRANT ALL ON FUNCTION public.wf_csi_im_filter_bycurrentperformer3(int8,int8,varchar) TO public;
GRANT ALL ON FUNCTION public.wf_csi_im_filter_bycurrentperformer3(int8,int8,varchar) TO cmdbuild;
GRANT ALL ON FUNCTION public.wf_csi_im_filter_bycurrentperformer3(int8,int8,varchar) TO cmdbuild_users;

Using it we obtain ‘invalid filter’. We need help, thanks in advance. Our version of CMBUILD is Version: 3.4-l