var add_datafilters = [

	{
		name:'contract_status',
		expression:"t1.contract_status  in ('INCEPTING','INCEPT','INCEPT_RETURN','NEW')"
	},
    {
        name:'sign_contract_status',
        expression:"t1.sign_contract_status  in ('SIGNING','SIGN')"

    },
    {
        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} "
    },{
        name:'contract_status',
        queryexpression:"t1.contract_status=${@contract_status}"
    }
];

override();

add_datafilter();