con_transfer_result_queryfields.js 631 Bytes
Newer Older
Spencer Chang's avatar
Spencer Chang committed
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17
var override_queryfields = [
{
	name : 'lease_start_date_from',
	queryexpression : "trunc(t1.lease_start_date) >= to_date(${@lease_start_date_from},'yyyy-mm-dd')"
},
{
	name : 'lease_start_date_to',
	queryexpression : "trunc(t1.lease_start_date) <= to_date(${@lease_start_date_to},'yyyy-mm-dd')"
}
		 ];
var add_datafilters = [ {
	name : 'contract_status',
	expression : "t1.data_class = 'NORMAL' and exists (select 1 from yonda_doc_status_history t where t.document_category = 'CONTRACT' and t.document_id=t1.contract_id and t.status = '280') and t1.contract_status in ('TERMINATE','ET','AD')"
} ];

add_datafilter();
override();