on 04-05-2016 11:22 AM
Hi Friends,
I need help in filter in to read oData. I need filter as following while performing oModel.read().
(
((USERID EQ 'KSA') OR (USERID EQ 'KSW'))
AND
((USERID NE 'KUMARNISH2') OR (USERID NE 'KUMARNISH3'))
)
If you see here there are multiple OR operation and atlast all are AND with each other.
I has following code:
var filters = [];
// var filters_ne = [];
var filter;
for (var i in employee){
var token = employee[i].getText();
if(token.startsWith("=")){
//equal to
filter = new sap.ui.model.Filter("UserID", "EQ",token.substring(1));
filters.push(filter);
}else if(token.startsWith("!")){
//not equal to
var notUser = token.substring(3);
notUser = notUser.substring(0,notUser.length-1);
filter = new sap.ui.model.Filter("UserID", "NE",notUser);
filters.push(filter);
}else{
//between
var userid = token.split("...");
filter = new sap.ui.model.Filter("UserID", "BT",userid[0],userid[1]);
filters.push(filter);
}
}
// filters.push(filters_ne);
// var allFilter = [];
// allFilter.push(filters_eq);
// allFilter.push(filters_ne);
// var filters = new sap.ui.model.Filter(allFilter, true);
this.getView().getModel().read("/I_Userdetails",{
filters :filters,
success : jQuery.proxy(this.updateUserData,this),
error : this.failed
});
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
HI,
For different type of filter u can refer this link:
and
User | Count |
---|---|
101 | |
13 | |
13 | |
11 | |
11 | |
7 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.