var override_queryfields = [
    {
        name: 'signing_date_from',
        queryexpression: "T1.signing_date>=trunc(to_date(${@signing_date_from},'yyyy-mm-dd'))"
    },
    {
        name: 'signing_date_to',
        queryexpression: "trunc(T1.signing_date)<=to_date(${@signing_date_to},'yyyy-mm-dd')"
    },
    {
        name: 'loan_date_from',
        queryexpression: "T1.loan_date_to>=trunc(to_date(${@loan_date_from},'yyyy-mm-dd'))"
    },
    {
        name: 'loan_date_to',
        queryexpression: "trunc(T1.loan_date_to)<=to_date(${@loan_date_to},'yyyy-mm-dd')"
    },
    {
        name: 'loan_amount_from',
        queryexpression: "T1.loan_amount>=${@loan_amount_from}"
    },
    {
        name: 'loan_amount_to',
        queryexpression: "T1.loan_amount<=${@loan_amount_to}"
    },
    {
        name: 'withdraw_amount_from',
        queryexpression: "T1.withdraw_amount>=${@withdraw_amount_from}"
    },
    {
        name: 'withdraw_amount_to',
        queryexpression: "T1.withdraw_amount<=${@withdraw_amount_to}"
    },
    {
        name: 'remaining_amount_from',
        queryexpression: "T1.remaining_amount>=${@remaining_amount_from}"
    },
    {
        name: 'remaining_amount_to',
        queryexpression: "T1.remaining_amount<=${@remaining_amount_to}"
    }
];

var add_datafilters = [{
    name: 'status',
    expression: " (T1.loan_con_wfl_status = 'WFL_APPROVED')"
}];

add_datafilter();
override();
