var override_queryfields = [
    {
        name: 'base_date_from',
        queryexpression: "t1.base_date>=to_date(${@base_date_from},'yyyy-mm-dd')"
    },
    {
        name: 'base_date_to',
        queryexpression: "t1.base_date<=to_date(${@base_date_to},'yyyy-mm-dd')"
    },
    {
        name: 'overdue_days_from',
        queryexpression: "t1.overdue_days>=${@overdue_days_from}"
    },
    {
        name: 'overdue_days_to',
        queryexpression: "t1.overdue_days<=${@overdue_days_to}"
    },
    {
        name: 'loan_amount_from',
        queryexpression: "t1.loan_amount>=${@loan_amount_from}"
    },
    {
        name: 'loan_amount_to',
        queryexpression: "t1.loan_amount<=${@loan_amount_to}"
    },
    {
        name: 'loan_balance_from',
        queryexpression: "t1.loan_balance>=${@loan_balance_from}"
    },
    {
        name: 'loan_balance_to',
        queryexpression: "t1.loan_balance<=${@loan_balance_to}"
    },
    {
        name: 'repayment_date',
        queryexpression: "t1.repayment_date=to_date(${@repayment_date},'yyyy-mm-dd')"
    },
    {
        name: 'overdue_principal_from',
        queryexpression: "t1.overdue_principal>=${@overdue_principal_from}"
    },
    {
        name: 'overdue_principal_to',
        queryexpression: "t1.overdue_principal<=${@overdue_principal_to}"
    },
    {
        name: 'loan_term_from',
        queryexpression: "t1.loan_term>=${@loan_term_from}"
    },
    {
        name: 'loan_term_to',
        queryexpression: "t1.loan_term<=${@loan_term_to}"
    },
    {
        name: 'due_date_from',
        queryexpression: "t1.due_date>=to_date(${@due_date_from},'yyyy-mm-dd')"
    },
    {
        name: 'due_date_to',
        queryexpression: "t1.due_date<=to_date(${@due_date_to},'yyyy-mm-dd')"
    },
    {
        name: 'import_date_from',
        queryexpression: "trunc(t1.import_date)>=to_date(${@import_date_from},'yyyy-mm-dd')"
    },
    {
        name: 'import_date_to',
        queryexpression: "trunc(t1.import_date)<=to_date(${@import_date_to},'yyyy-mm-dd')"
    },
    {
        name: 'payment_date_from',
        queryexpression: "t1.payment_date>=to_date(${@payment_date_from},'yyyy-mm-dd')"
    },
    {
        name: 'payment_date_to',
        queryexpression: "t1.payment_date<=to_date(${@payment_date_to},'yyyy-mm-dd')"
    },
    {
        name: 'dcs_sales_date_from',
        queryexpression: "t1.dcs_sales_date>=to_date(${@dcs_sales_date_from},'yyyy-mm-dd')"
    },
    {
        name: 'dcs_sales_date_to',
        queryexpression: "t1.dcs_sales_date<=to_date(${@dcs_sales_date_to},'yyyy-mm-dd')"
    }
];
override();
