How to perform a consultation in the bank applying "exceptions" with a relationship?

Question

I need to get all users with "Exceção" those of the function containing the id=2, it is possible?

You can fit a Where in that consultation?

I have the following consult at the bank Laravel which returns an object to the datatables.net follow-up consultation:

$query = User::query()->select('*');
$query->with(['roles']);
$table = Datatables::of($query);

This returns me all the users of the bank and with their respective functions 'roles'. if I want to fetch everyone from a certain function I do it:

$query = Role::find(1)->users;
$table = Datatables::of($query);

The '1' within find() represents the id of function

find(1)

but I need to get all users of all functions Except that of the id = 2 it is possible?

Answer 1

You can do it like this:

All the Role except for the number 2 bring the relationship of usuários, example

$users = Role::where('id', '<>', 2)->users;

bringing all users except what has roles == 2.

Observing: users and its relationship with the functions of each user so put the same name configured in your model

Another way by the user’s relationship with the method has():

$users = User::with(['roles'])->has('roles', '<>', 2)->get();

^{Reference: Querying Relationship Existence}