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

ppetzold / nestjs-paginate

Pagination and filtering helper method for TypeORM repositories or query builders using Nest.js framework :book::paperclip:

MIT License

451 stars 100 forks source link

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

Open jlefebvre1997 opened 1 week ago

jlefebvre1997 commented 1 week ago

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 commented 1 week ago

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