var override_queryfields = [ { name : 'bp_id_tenant', queryexpression : "t1.bp_id_tenant =${@bp_id_tenant}" }, { name : 'bp_id', queryexpression : "t1.bp_id_tenant =${@bp_id}" }, { name : 'bp_id_tenant_n', queryexpression : "t1.bp_id_tenant_n like ${@bp_id_tenant_n}" }, { name : 'lease_start_date_from', queryexpression : "t1.lease_start_date between to_date(${@lease_start_date_from},'yyyy-mm-dd') and nvl(to_date(${@lease_start_date_to},'yyyy-mm-dd'),t1.lease_start_date)" }, { name : 'lease_start_date_to', queryexpression : "t1.lease_start_date between nvl(to_date(${@lease_start_date_from},'yyyy-mm-dd'),t1.lease_start_date) and to_date(${@lease_start_date_to},'yyyy-mm-dd')" }, { field : 'project_id', queryoperator : "=" }, { name : 'project_name', queryexpression : "t1.project_id_n like ${@project_name}" }, { field : 'contract_id', queryoperator : "=" }, { field : 'contract_name', queryoperator : "like" }, { name : 'employee_name_of_manager', queryexpression : "t1.employee_id_of_manager like ${@employee_name_of_manager}" }, { field : 'lease_organization', queryoperator : "=" }, { field : 'lease_channel', queryoperator : "=" }, { field : 'contract_status', queryoperator : "=" }, { field : 'division', queryoperator : "=" }, { field : 'document_type', queryoperator : "=" }, { field : 'business_type', queryoperator : "=" }, { name : 'contract_num_from', queryexpression : "t1.contract_id between ${@contract_num_from} and nvl(${@contract_num_to},${@contract_num_from})" }, { name : 'contract_num_to', queryexpression : "t1.contract_id between ${@contract_num_from} and nvl(${@contract_num_to},${@contract_num_from})" }, { name : 'cf_item', queryexpression : "t1.cf_item = ${@cf_item}" } ]; override();