var override_queryfields = [
	{
		name : 'bp_name',
		queryexpression : "t1.bp_id_tenant_n like '%'||${@bp_name}||'%'"
	},
	{
		name : 'city_n',
		queryexpression : "t1.city_n like ${@city_n}"
	},
	{
		name : 'province_n',
		queryexpression : "t1.province_n like ${@province_n}"
	},
	{
		name : 'lease_start_date_from',
		queryexpression : "t1.lease_start_date >= ${@lease_start_date_from}"
	},
	{
		name : 'lease_start_date_to',
		queryexpression : "t1.lease_start_date <=${@lease_start_date_to}"
	},
	{
		name : 'lease_end_date_from',
		queryexpression : "to_char(t1.et_date,'yyyy-mm-dd') >= ${@lease_end_date_from}"
	},
	{
		name : 'lease_end_date_to',
		queryexpression : "to_char(t1.et_date,'yyyy-mm-dd') <=${@lease_end_date_to}"
	},

	{
		name : 'contract_creation_date_from',
		queryexpression : "t1.contract_creation_date >= trunc(to_date(${@contract_creation_date_from},'yyyy-mm-dd') )"
	},
	{
		name : 'contract_creation_date_to',
		queryexpression : "trunc(t1.contract_creation_date) <=to_date(${@contract_creation_date_to},'yyyy-mm-dd')"
	},
	{
		name : 'closed_date_from',
		queryexpression : "t1.closed_date >= trunc(to_date(${@closed_date_from},'yyyy-mm-dd') )"
	},
	{
		name : 'closed_date_to',
		queryexpression : "trunc(t1.closed_date) <=to_date(${@closed_date_to},'yyyy-mm-dd')"
	},
	//

	{
		field : 'employee_id',
		queryoperator : "="
	},
	{
		name : 'project_number',
		queryexpression : "t1.project_number like ${@project_number}"
	},
	{
		name : 'agent_extra_nam',
		queryexpression : "t1.agent_extra_nam like '%'||${@agent_extra_nam}||'%'"
	},
	{
		field : 'contract_id',
		queryoperator : "="
	},
	{
		name : 'contract_number',
		queryexpression : "t1.contract_number like '%'||${@contract_number}||'%'"
	},
	{
		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 : 'company_authority',
		queryexpression : "t1.company_id in (select company_id from fnd_companies start with company_id =${@company_authority} connect by prior company_id = parent_biz_company_id)"
	},
	{
		name : 'data_class',
		queryexpression : "t1.data_class=${@data_class}"
	},
	{
		name : 'sec_tenant_name',
		queryexpression : "t1.bp_name_sec_tenant like ${@sec_tenant_name}"
	},
	{
		name : 'submit_date_detail_from',
		queryexpression : "t1.submit_date_detail >= trunc(to_date(${@submit_date_detail_from},'yyyy-mm-dd') )"
	},
	{
		name : 'submit_date_detail_to',
		queryexpression : "trunc(t1.submit_date_detail) <=to_date(${@submit_date_detail_to},'yyyy-mm-dd')"
	},
	{
		name : 'lease_execution_date_from',
		queryexpression : "to_char(t1.lease_execution_date,'yyyy-mm-dd') >= ${@lease_execution_date_from}"
	},
	{
		name : 'lease_execution_date_to',
		queryexpression : "to_char(t1.lease_execution_date,'yyyy-mm-dd') <=${@lease_execution_date_to}"
	},{
		name:'contract_status',
		queryexpression:"t1.contract_status=${@contract_status}"
	}

];

override();
