hsbc110_m_result_queryfields.js 570 Bytes
Newer Older
panhong18943's avatar
panhong18943 committed
1 2 3 4 5 6 7 8 9 10 11 12 13 14
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',
panhong18943's avatar
panhong18943 committed
15
        expression : "t1.status in ('NEW','ERROR','FINISHED','SEND_MID','CONFIRM1_ERROR','CONFIRM2_FULL_ERROR') and t1.cf_item in ('40','911')"
panhong18943's avatar
panhong18943 committed
16 17 18 19 20 21
    }
];


add_datafilter();
override();