var override_queryfields = [
{
	name:'bp_code_from',
	queryexpression:"t1.bp_code between ${@bp_code_from} and nvl(${@bp_code_to},t1.bp_code)"
},
{
	name:'bp_code_to',
	queryexpression:"t1.bp_code between nvl(${@bp_code_from},t1.bp_code) and ${@bp_code_to}"
},
{
	field:'bp_name',
	queryoperator:"like"
},
{
	field:'extra_nam',
	queryoperator:"like"
},
{
	field:'bp_type',
	queryoperator:"="
},
{
	name:'project_id',
	queryexpression:"exists (select 1 from prj_project_bp b where b.project_id=${@project_id} and t1.bp_id=b.bp_id )"
},
{
	name:'project_name',
	queryexpression:"exists (select 1 from prj_project_bp_lv b where b.project_id_n like ${@project_name} and t1.bp_id=b.bp_id )"
},
{
	name:'contract_id',
	queryexpression:"exists (select 1 from con_contract_bp b where b.contract_id like ${@contract_id} and t1.bp_id=b.bp_id )"
},
{
	name:'contract_name',
	queryexpression:"exists (select 1 from con_contract_bp bp,con_contract cc where bp.contract_id=cc.contract_id and cc.contract_name like ${@contract_name} and bp.bp_id=t1.bp_id)"
},
{
	field:'bp_class',
	queryoperator:'='
},
{	
	name:'class_desc',
	queryexpression:"(t1.bp_class=${@class_desc})"
},
{	
	name:'enabled_flag_query',
	queryexpression:"(t1.enabled_flag=${@enabled_flag_query} or ${@enabled_flag_query}='ALL')"
},
{	
	name:'bp_role',
	queryexpression:"exists (select 1 from hls_bp_master_role t where t.bp_id=t1.bp_id and t.bp_type=${@bp_role})"
}
//{
//	name:'created_by',
//	queryexpression:"((((t1.created_by = ${@created_by} AND t1.bp_category = 'TENANT') OR " +
//			"(EXISTS (SELECT 1  "  +
//                  "   FROM sys_user u " +
//                  "   WHERE u.user_name = 'HAND' " +
//                  "     AND u.user_id = ${@created_by})))" +
//			"OR (t1.bp_category <> 'TENANT')) " +
//			"AND " +
//			"(EXISTS (SELECT 1 " +
//	                "   FROM sys_user u	" +
//	                "  WHERE u.user_name = 'HAND' " +
//	                "   AND u.user_id = ${@created_by}) OR t1.bp_class <> 'IMPORT')) "
//
//			
//}



 ];

override();
