Hi!
Have a query that returns dupicate users
public function getNotificationFlowUsers($golfID)
{
$flowusers = User::where('golfclub_id', '=',$golfID)
->leftJoin('role_user', 'role_user.user_id', '=', 'users.id')
->where('role_user.role_id',10)
->orWhere('role_user.role_id',1)
->orWhere('role_user.role_id',4)
->orWhere('role_user.role_id',6)
->get();
return $flowusers;
}
But i want to return only 1 record -> unique value email
Tryed this:
public function getNotificationFlowUsers($golfID)
{
$flowusers = User::where('golfclub_id', '=',$golfID)
->leftJoin('role_user', 'role_user.user_id', '=', 'users.id')
->where('role_user.role_id',10)
->orWhere('role_user.role_id',1)
->orWhere('role_user.role_id',4)
->orWhere('role_user.role_id',6)
->unique('users.email')
->get();
return $flowusers;
}
But this gives me error:
"message": "Call to undefined method Illuminate\Database\Eloquent\Builder::unique()",
"exception": "BadMethodCallException",
"file":
How can i do this ?