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