17 lines
780 B
YAML
17 lines
780 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 ownr_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
|
|
- args:
|
|
name: search_jobs
|
|
schema: public
|
|
type: track_function
|