nestjs-paginate icon indicating copy to clipboard operation
nestjs-paginate copied to clipboard

Filtering on a relation actually returns the filtered relations, not the filtered main array

Open jlefebvre1997 opened this issue 1 year ago • 3 comments
trafficstars

For exemple, if I filter my cats by toys.name=$not:$eq:pillow, if some of the cats have a toy whose name is pillow, they will still appear in the filtered results, only the toy entity will not be included in the loaded relation array, is this intended ?

jlefebvre1997 avatar Nov 20 '24 14:11 jlefebvre1997

I understand this one is more of an SQL issue, I don't know if this will be easy to fix

jlefebvre1997 avatar Nov 20 '24 14:11 jlefebvre1997

This can be addressed once #539 gets merged I think :) Everything intermediate relationship is left joined instead of inner joined

Helveg avatar Jan 07 '25 08:01 Helveg

@jlefebvre1997 #539 has been merged, does the problem still occur on version 11.0.2?

Helveg avatar Mar 06 '25 12:03 Helveg