hsbc100_r_result_queryfields.js 513 Bytes
Newer Older
1 2 3 4 5 6 7 8 9 10 11 12
var override_queryfields = [
	{
		name : 'payment_req_number',
		queryexpression : "transaction_num = ${@payment_req_number}"
	},
	{
		name : 'approval_date_from',
		queryexpression : "trunc(t1.approval_date) >= to_date(${@approval_date_from},'yyyy-mm-dd')"
	},
	{
		name : 'approval_date_to',
		queryexpression : "trunc(t1.approval_date) <= to_date(${@approval_date_to},'yyyy-mm-dd')"
13 14 15 16
	},
	{
		name : 'collection_classes',
		queryexpression : "collection_classes = ${@collection_classes}"
17 18 19 20 21
	}
];


override();