Client-Side List Filter "setFilter()" using AND not OR?

[PFish]

Hi All,

Following this page https://documentation.alphasoftware....r%20Method.xml

I'm trying to set a client-side filter but it seems it only does the filter with an "OR" statement. Is there any way to tell "setFilter" to do an "AND"? Or do I just need to code the filter more?

Trying to avoid server-side as our Alpha costs are rising like crazy.

Thanks!

[madtowng]

It makes things a lot easier when you show the code that's not working as expected.

[PFish]

var listObj = {dialog.object}.getControl('list1');
//using Regular Expressions on some fields and functions on other.
//filter on the Name starts with an "E" or the Age is between 18 and 65 - note the value of "Age" gets passed into the function.
listObj.setFilter(
{
Name: RegExp('^E','i'),
Age: function(val){
if(val < 18 || val > 65) return false;
else return true;
}
}
);

[PFish]

Is there no way to set the filter to do "AND" and not "OR" using the code above? It always searches via OR. I can get it to work server-side using {dialog.object}._filterList but not the client-side.

Thanks!

[madtowng]

try this

Name.includes('E') || (Age >= 18 && Age <= 65 )

[PFish]

Thanks, I figured I may just need to make my filter more in-depth. Was hoping for an easier method... I'm going to give up on the client-side filtering as it just doesn't work the same as server-side. Server-side was working just fine but figured it might use less "compute units" if I could do client-side.

[madtowng]

As I reread what you were looking for I noticed my code was off just a bit.
I'm not sure how a "compute unit" is calculated, but the effort could be worthwhile.
There's not a lot of adjustment to be made, but obviously the choice is all yours.

if(data.Name.substr(0,1) = 'E' || (data.Age >= 18 && data.Age <= 65 ) return true;
else return false