var override_queryfields = [ { name: 'tax_type_rate', queryexpression: "t1.tax_type_rate=${@tax_type_rate}" }, { name: 'accounting_date_from', queryexpression: "t1.accounting_date>=trunc(to_date(${@accounting_date_from},'yyyy-mm-dd'))" }, { name: 'accounting_date_to', queryexpression: "trunc(t1.accounting_date) <= to_date(${@accounting_date_to},'yyyy-mm-dd')" }, { name: 'invoice_date_from', queryexpression: "t1.invoice_date between to_date(${@invoice_date_from},'yyyy-mm-dd') and nvl(to_date(${@invoice_date_to},'yyyy-mm-dd'),t1.invoice_date)" }, { name: 'invoice_date_to', queryexpression: "t1.invoice_date between nvl(to_date(${@invoice_date_from},'yyyy-mm-dd'),t1.invoice_date) and to_date(${@invoice_date_to},'yyyy-mm-dd')" }, { name: 'invoice_number_from', queryexpression: "t1.invoice_number >= ${@invoice_number_from} " }, { name: 'invoice_number_to', queryexpression: "t1.invoice_number <= ${@invoice_number_to} " }, { name: 'contract_number_from', queryexpression: "t1.contract_number >= ${@contract_number_from} " }, { name: 'contract_number_to', queryexpression: "t1.contract_number <= ${@contract_number_to} " } ]; var add_datafilters = []; override(); add_datafilter();