Complex filtering possibilities

[strailov]

Hello,
I was playing around with springfilter with jpa and I was wondering is it possible to filter some more complex cases.

More specifically I have an entity which have a relation to attributes table with String key value pairs.

So for example If I have couple of attributes for a particular entity
Map<String, String> attributes;
Currently I see It is possible to filter for attribute.key : value
Is it possible somehow to filter for attribute.<valueOfKey> : <valueInMap> ?
So for example if I have
{ "foo" : "bar" } top somehow filter for attributes.foo : 'bar'
Currently Criteria builder throws an exception
Criteria expression is of primitive type and cannot be further navigated.
Which of course seems reasonable but I was just wondering is there a way ?

[strailov]

And also is it possible to filter for multiple entities in this Map ?
Like
(attribute.key : 'one' AND attribute.value : 'two') AND (attribute.key : 'three' AND attribute.value : 'four') ?

[torshid]

Hello @strailov

I'm not sure I understood what you meant. As you said, we can currently filter maps using keys.

As for your second question, try to wrap your query with the exists function:

exists((attribute.key : 'one' AND attribute.value : 'two') AND (attribute.key : 'three' AND attribute.value : 'four'))