14 lines
767 B
YAML
14 lines
767 B
YAML
- args:
|
|
cascade: true
|
|
read_only: false
|
|
sql: "CREATE OR REPLACE FUNCTION public.search_jobs(search text, startDate date,
|
|
endDate date)\n RETURNS SETOF jobs\n LANGUAGE plpgsql\n STABLE\nAS $function$
|
|
BEGIN if search = '' then return query\nselect *\nfrom jobs j;\nelse return
|
|
query\nSELECT *\nFROM jobs j2\nWHERE \nclose_date between startDate and endDate
|
|
\ and\n(\nownr_fn ILIKE '%' || search || '%'\n or ownr_ln ILIKE '%' || search
|
|
|| '%'\n \n or clm_no ILIKE '%' || search || '%')\n\nORDER BY \n clm_no
|
|
ILIKE '%' || search || '%'\n OR null,\n ownr_fn ILIKE '%' || search ||
|
|
'%'\n OR NULL,\n ownr_ln ILIKE '%' || search || '%'\n OR NULL;\nend
|
|
if;\nEND $function$;"
|
|
type: run_sql
|