hsbc120_g_result_queryfields.js

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();