How to select multiple columns and filter duplicate values in Laravel?

Question

I'm trying to select multiple columns and avoid duplicate values in these columns with Laravel. Here is my data:

id, name, job, department
[1, "Jane Doe", "worker", "departmentA"]
[2, "Adam Smith", "manager", "departmentB"]
[3, "Machiavelli", "worker", "departmentA"]
[4, "Rousseau", "worker", "departmentC"]

I want to get job and department without duplicate data. So I want this result:

[["worker", "manager"], ["departmentA", "departmentB", "departmentC"]]

I'm trying to get it with model like that:

$users = Users::all();
$user_fields = $users->pluck("job", "department")->toArray();
return $user_fields;

But it's not working. How can I do it?

What is "not working"? An error? not the expected result? You cant expect "pluck" to create an array per column... — Gert B.
– Gert B., Commented Oct 26, 2021 at 13:10

sundowatch · Accepted Answer · 2021-10-26 14:11:13Z

2

I dont think you can do it with one function.

But with two plucks it is simple:

$user_fields = 
    [
        $users->pluck("job")->unique()->values()->toArray(),
        $users->pluck("department")->unique()->values()->toArray()
    ];

edited Oct 26, 2021 at 14:11

sundowatch

3,1254 gold badges47 silver badges76 bronze badges

answered Oct 26, 2021 at 13:13

Autista_z

2,53118 silver badges25 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

sundowatch Over a year ago

This is the closest answer. Please update your answer with adding values() after the unique() and do not merge arrays, just wrap them with array bracket. That was what I want. Thank you.

Professor · Accepted Answer · 2021-10-26 13:21:19Z

0

When you pluck 2 values, you're creating an associative array.

You can split them into separate arrays using array_keys and array_values. I would use array_unique to remove duplicates.

$users = Users::all();

$jobs_despartments = $users->pluck("job", "department")->all();

$jobs = array_unique(array_keys($jobs_despartments));
// ["worker", "manager"]

$departments = array_unique(array_values($jobs_despartments));
// ["departmentA", "departmentB", "departmentC"]

answered Oct 26, 2021 at 13:21

Professor

9081 gold badge10 silver badges17 bronze badges

Collectives™ on Stack Overflow

How to select multiple columns and filter duplicate values in Laravel?

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related