Ubicar reportes en adempiere

create or replace function sp_ubicar_reporte(hostname varchar, port varchar)
returns boolean as $$
begin
    update ad_process
        set jasperreport = 'http://' || hostname || ':' || port || '/reports/' ||
        substring( jasperreport, position('reports/' in  jasperreport) + 8, length( jasperreport))
    where isreport = 'Y'
    and (jasperreport is not null or jasperreport <> '');
    
    return true;
end;
$$ language plpgsql;