Pattern Matching

[banerjee...@gmail.com]

Hi Team,

In my application, i want to take out the list by matching 4 fields pattern, from my collection. And for generating the list i am using aggregation, i am able to filter out the list based on 2 columns, but there are situations when i need to filter the result or generate the list based on 4 columns, can u tell me how to do so?

[banerjee...@gmail.com]

Adding, to my previous post, i am giving the code below which i am using to generate the list,

function set_vb_list_value(vb_name,vb_value){
var a = new RMP_List();
a.fromArray(vb_value);
RMPApplication.setList(vb_name,a);
}

function callbackSuccess(result){
set_vb_list_value("vb_routed_people",result);
}

function callbackFailure(result) {
alert("ko=" + JSON.stringify(result));
}


var entered_amount = parseFloat(RMPApplication.getVariable("proposed_credit_amount"));
var pipelines = [{"$match":{"credit_amount_from":{"$lte":entered_amount},"credit_amount_to":{"$gte":entered_amount}}},{"$project":{"label":"$routed_people","value":"$routed_people"}}];

col_approvalmatrix.aggregateCallback(pipelines,{},callbackSuccess,callbackFailure);

in the code if u see i am using credit amount from and credit amount to, for the getting the list, but i also need to match the pattern of guarantee type and channel group , in this code to get the exact result.

So please help...

[banerjee...@gmail.com]

Hi Team,

I have figured out the way for this, sorry for the trouble, you can close this case.

Regards,
Somjit