---

SELECT DISTINCT
    ps.id AS id,
    REPLACE(
        REPLACE(
            REPLACE(
                COALESCE(NULLIF(ps.index_scheme, ''), ps.number, ps.name),
                '\', '\\'
            ),
            '"', '\"'
        ),
        chr(10), ' '
    ) 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





#set( $result = $db.find($schema_index_list) )
{
  "list": [
    #if ($result)
      #foreach( $t in $result )
      {
        "name": "$t.name",
        "id": "$t.id"
      }#if($foreach.hasNext),#end
      #end
    #end
  ]
}