var override_queryfields = [ { name : 'send_date', queryexpression : "trunc(t1.send_date) = to_date(${@send_date},'yyyy-mm-dd')" }, { name : 'hsbc_status', queryexpression : "t1.status = ${@hsbc_status}" }, { name : 'inacctname', queryexpression : "exists (select 1 from hl_hsbc_paying_doc_lv hd where t1.batch_id = hd.batch_id and hd.inacctname like ${@inacctname})" } ]; var add_datafilters = [ { name : 'init_filter', expression : "t1.status in ('BANK_RECEIVED','BANK_HALF_BACKED','BANK_BACKED','FINISHED','CONFIRM1','CONFIRM1_ERROR','CONFIRM2','CONFIRM2_FULL_ERROR','CONFIRM2_PART_ERROR','SENDING','SEND_MID','CLOSED')" } ]; add_datafilter(); override();