darksaboteur / laravel-api-query-builder Goto Github PK

Hello,

Can you tell if it is possible to filter on a relation attribute using an AND. For instance, is it possible to filter the users to get every users with admin role AND publisher role ? With a request like this one:

/api/v1/users?role[]=admin&role[]=publisher

Or let's say that the admin role has ID 1 and the publisher role has ID 3, with something like:

/api/v1/users?role[]=1&role[]=3

If I issue this I get every users with admin role OR publisher role OR both.
This package craft the following query:

select users.* from userswhere exists (select * fromrolesinner joinusers_rolesonroles.id=users_roles.role_idwhereusers.id=users_roles.user_id and (roles.idin (1, 3))) order byusers.id desc

But it should craft the following one:

select users.* from userswhere exists (select * fromrolesinner joinusers_rolesonroles.id=users_roles.role_idwhereusers.id=users_roles.user_id and (roles.idin (1))) and exists (select * fromrolesinner joinusers_rolesonroles.id=users_roles.role_idwhereusers.id=users_roles.user_id and (roles.idin (3))) order byusers.id desc

Have you manage to do it yet or should I modify this package ?

Thank you in advance.