authen.public

Parameters

Name	Type	Mode
p_permissions	json	IN

Definition

SELECT COALESCE(json_agg(
               json_build_object('category', category, 'items', items)
               ORDER BY cat_min_code, category
           ), '[]'::json)
    FROM (
        SELECT category,
               min(sub_min_code) AS cat_min_code,
               json_agg(
                   json_build_object('subcategory', subcategory, 'permissions', permissions)
                   ORDER BY sub_min_code, subcategory
               ) AS items
        FROM (
            SELECT split_part(elem->>'category', '/', 1) AS category,
                   COALESCE(NULLIF(split_part(elem->>'category', '/', 2), ''), '') AS subcategory,
                   min(elem->>'code') AS sub_min_code,
                   json_agg(
                       json_build_object(
                           'code', elem->>'code',
                           'name', elem->>'name',
                           'is_granted', (elem->>'is_granted')::boolean,
                           'is_override', COALESCE((elem->>'is_override')::boolean, false)
                       )
                       ORDER BY elem->>'code'
                   ) AS permissions
            FROM json_array_elements(p_permissions) elem
            GROUP BY 1, 2
        ) s
        GROUP BY category
    ) c;

fn_group_permissions_by_category

Description

Parameters

Definition