hsbc110_r_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.collection_classes = 'REFUND'"
        expression : "t1.status in ('NEW','ERROR','FINISHED','SEND_MID','CONFIRM1_ERROR','CONFIRM2_FULL_ERROR') and nvl(t1.cf_item,'-1') <> '0'"
    }
];


add_datafilter();
override();