var override_queryfields = [ { name: 'bp_id', queryexpression: "t1.bp_id_tenant=${@bp_id}" }, { name: 'bp_name', queryexpression: "exists (select 1 from hls_bp_master hr where hr.bp_id=t1.bp_id_tenant and hr.bp_name like '%'||${@bp_name}||'%')" }, { 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')" }, { name: 'approved_date_from', queryexpression: "t1.approved_date between to_date(${@approved_date_from},'yyyy-mm-dd') and nvl(to_date(${@approved_date_to},'yyyy-mm-dd'),t1.approved_date)" }, { name: 'approved_date_to', queryexpression: "t1.approved_date between nvl(to_date(${@approved_date_from},'yyyy-mm-dd'),t1.approved_date) and to_date(${@approved_date_to},'yyyy-mm-dd')" }, { name: 'create_date_from', queryexpression: "t1.create_date between to_date(${@create_date_from},'yyyy-mm-dd') and nvl(to_date(${@create_date_to},'yyyy-mm-dd'),t1.create_date)" }, { name: 'create_date_to', queryexpression: "t1.create_date between nvl(to_date(${@create_date_from},'yyyy-mm-dd'),t1.create_date) and to_date(${@create_date_to},'yyyy-mm-dd')" }, { field: 'project_id', queryoperator: "=" }, { field: 'employee_id', queryoperator: "=" }, { field: 'lease_organization', queryoperator: "=" }, { field: 'contract_id', queryoperator: "=" }, { name: 'contract_number', queryexpression: "t1.contract_number like '%'||${@contract_number}||'%'" }, { field: 'lease_channel', queryoperator: "=" }, { field: 'document_type', queryoperator: "=" }, { field: 'lease_channel', queryoperator: "=" }, { field: 'document_type', queryoperator: "=" }, { field: 'business_type', queryoperator: "=" }, { field: 'contract_status', queryoperator: "=" }, { field: 'division', queryoperator: "=" },{ name: 'change_created_by_n', queryexpression: "t1.change_created_by_n like '%'||${@change_created_by_n}||'%'" } ]; var add_datafilters = [ { name: "req_status", expression: "t1.req_status in ('REJECT','APPROVED','APPROVING')" }/*, { name : "ccr_document_type", expression : "exists (select 1 from con_contract_change_req r where r.change_req_id = t1.contract_id and r.document_type = 'PAYCARD')" }*/]; override(); add_datafilter();