var override_queryfields = [
    {
        name: 'contract_id_from',
        queryexpression: "t1.contract_id_n >=  ${@contract_id_from} "
    },
    {
        name: 'contract_id_from',
        queryexpression: "t1.contract_id_n <=  ${@contract_id_from} "
    },

    {
        name: 'invoice_number_from',
        queryexpression: "t1.invoice_number >=  ${@invoice_number_from} "
    },
    {
        name: 'invoice_number_to',
        queryexpression: "t1.invoice_number <=  ${@invoice_number_to} "
    },
    {
        name: 'invoice_date_from',
        queryexpression: "t1.invoice_date>=trunc(to_date(${@invoice_date_from},'yyyy-mm-dd'))"
    },
    {
        name: 'invoice_date_to',
        queryexpression: "trunc(t1.invoice_date)<=to_date(${@invoice_date_to},'yyyy-mm-dd')"
    },
    {
        name: 'lease_execution_date_from',
        queryexpression: "t1.lease_execution_date>=trunc(to_date(${@lease_execution_date_from},'yyyy-mm-dd'))"
    },
    {
        name: 'lease_execution_date_to',
        queryexpression: "trunc(t1.lease_execution_date)<=to_date(${@lease_execution_date_to},'yyyy-mm-dd')"
    },
    {
        name: 'total_amount_from',
        queryexpression: "t1.total_amount>=${@total_amount_from}"
    },
    {
        name: 'total_amount_to',
        queryexpression: "trunc(t1.total_amount)<=${@total_amount_to}"
    }


];

var add_datafilters = [{
    name: "invoice_status",
    expression: " t1.invoice_status in （'VERIFIED','ARCHIVED'）"
}

];

override();
add_datafilter();