authen.public

Parameters

Name	Type	Mode
prop_id	integer	IN
report_id	integer	IN (DEFAULT NULL)
id	integer	OUT
name	text	OUT
category	text	OUT
report_type	text	OUT
template_file_name	text	OUT
template_path	text	OUT
template_type	text	OUT
report_url	text	OUT

Definition

with rp as (
        select r.id, 
            coalesce(pr.report_name, r.report_name) as name, 
            r.category, 
            r.report_type,   
            replace(coalesce(pr.report_filename, r.report_filename), '.frx', '') as report_filename,
            case when r.report_filename ilike '%.frx' then 'frx' else 'jrxml' end as template_type,
            fn_get_config(prop_id, 'JASPER_SERVICE_URL')||r.path_url as report_url 
            -- 'https://file1.fromas.cloud'||r.path_url as report_url 
        from reports r 
            left join property_reports pr on r.id = pr.report_id and pr.prop_id = $1
        where  ($2 is null or r.id = $2) 
            and coalesce(pr.report_filename, r.report_filename) is not null
    )
    select id, name, category, report_type, 
        case  
            when (report_type = 'print_form') and (template_type = 'jrxml') then
               'print_form/'||report_filename||'.'||template_type
            else    
                report_filename||'.'||template_type
        end as template_file_name,  
        fn_get_config(prop_id, 'FILE_STORAGE_URL')||'report_src/'||report_filename||'.'||template_type as template_path,
        template_type,
        report_url
    from RP;

sp_get_report_list

Parameters

Definition