Загрузка данных

SELECT DISTINCT
    ps.id AS id,
    COALESCE(NULLIF(ps.index_scheme, ''), ps.number, ps.name) AS name
FROM ourpension.pension_scheme ps
WHERE COALESCE(NULLIF(ps.index_scheme, ''), ps.number, ps.name) IS NOT NULL

#if ("$!term" != "")
    AND COALESCE(NULLIF(ps.index_scheme, ''), ps.number, ps.name) ILIKE '%' || :term || '%'
#end

ORDER BY name