hsbc110_m_result_queryfields.js

var override_queryfields = [
    {
        name : 'creationdate_from',
        queryexpression : "trunc(t1.creationdate) >= to_date(${@creationdate_from},'yyyy-mm-dd')"
    },
    {
        name : 'creationdate_to',
        queryexpression : "trunc(t1.creationdate) <= to_date(${@creationdate_to},'yyyy-mm-dd')"
    }
];

var add_datafilters = [
    {
        name : 'init_filter',
        expression : "t1.status in ('NEW','ERROR','FINISHED','SEND_MID','CONFIRM1_ERROR','CONFIRM2_FULL_ERROR') and t1.cf_item in ('40','911')"
    }
];


add_datafilter();
override();