AutoQueryable icon indicating copy to clipboard operation
AutoQueryable copied to clipboard

Add graphql like filter for complicated filters

Open trenoncourt opened this issue 6 years ago • 2 comments

Sometimes we can't write some complicated filters with AQ because we have multiple conditions and subconditions :

((id == 1 || id == 2 || id == 3) && color.Contains("blue")) || (quantity >= 5 && quantity < 10)

We need to add a new filter clause (while keeping the old way) to make complicated filters like this :

filter=or(and(id(1,2,3),color(contains=blue),quantity(>=5,<10))

trenoncourt avatar Apr 21 '18 13:04 trenoncourt

Hi @trenoncourt I've just come across this issue and it seems to be the very functionality that we are looking for.

I'm wondering if we can already perform a simple logical OR across 2 different fields, or whether this would be part of this enhancement?

e.g. name.Contains("John") OR surname.Contains("Smith")

jsancho avatar Sep 05 '18 15:09 jsancho

hi @jsancho,

Sorry, not yet implemented, but in roadmap !

trenoncourt avatar Sep 06 '18 09:09 trenoncourt