var add_datafilters = [

    {
        name: 'document_type',
        expression: "t1.document_type = 'CARCON'"
    },
    {
        name:'contract_status',
        expression:"t1.contract_status not in ('CLOSED','CANCEL')"
    },
    {
        name: 'sign_contract_status',
        expression: "t1.sign_contract_status in ('NEW','SIGNING','SIGN','SIGN_RETURN')"
    },
    {
        name : 'authority',
        expression : "(exists (select 1 from aut_trx_user_authorize a1, aut_owner_user_authorize a2  where a1.trx_category = 'CONTRACT' and a1.trx_id = t1.contract_id and trunc(sysdate) between a1.start_date and nvl(a1.end_date, trunc(sysdate)) and a1.user_id = a2.owner_user_id and a1.trx_category = a2.trx_category and a2.authorized_user_id = ${/session/@user_id} and trunc(sysdate) between a2.start_date and nvl(a2.end_date, trunc(sysdate))))"
    }

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

override();
add_datafilter();