Laravel realtionship groupBy

Question

I am trying to get a relationship from a model but only 1 type of children.

Credito is my main model, and it has many archivos. Archivos has a field called 'parent_requisito_id', i want to extract all archivos but that i don't get repeated 'parent_requisito_id' looking for the newest entry of the single parent_requisito_id.

I have no idea into getting that output on a relation.

$files = $credito->archivos;

Kevin Bui · Accepted Answer · 2020-01-30T01:42:58.437

1

I think this popular post answers your question. But doing the same query with laravel relationship is a bit of work.

I don't know Spanish so I am gonna write some code in English after some translation:

credito: loan
archivo: archive (file)
requisito: requirement

A simple approach could be using Laravel Collection. From the discussion you got some timestamps issue. Lets use id instead of timestamps.

$files = $loan->archives()
    ->get()
    ->keyBy('parent_requirement_id')
    ->values();

edited Jan 30 '20 at 01:42

answered Jan 29 '20 at 23:31

Kevin Bui

2,754
1
14
15

it did work that it returned only 1 per parent_requisito_id, but not the latest – pato.llaguno Jan 29 '20 at 23:33
wait, i think its my bad since the one showing has no timestamps and the others do... – pato.llaguno Jan 29 '20 at 23:34
latest() considers created or modified timestamp? – pato.llaguno Jan 29 '20 at 23:35
im still getting the first instead of last, fixed the timestamps – pato.llaguno Jan 29 '20 at 23:42
another problem with that solution is that i get only 1 archive, not only 1 grouped by parent – pato.llaguno Jan 29 '20 at 23:46
`latest()` works on `created_at` by default, if you need to order other columns you can do `latest('column_name')` – mdexp Jan 29 '20 at 23:57
A `Credito` model can have multiple `Archivos` with different `parent_requisito_id`? – mdexp Jan 29 '20 at 23:58
@mdexp yes, thats the point, to get all the archivos but dont have repeated parent_requisito – pato.llaguno Jan 30 '20 at 00:37
@pato.llaguno I have updated my answer, including reference to another post. You want to have a look. – Kevin Bui Jan 30 '20 at 01:35
@kevin the problem with timestamp was a seed thing – pato.llaguno Jan 30 '20 at 01:57
it did work, ill reasearc around why keyBy gives me the latest, also have never used values() before on eloquent – pato.llaguno Jan 30 '20 at 16:52

Laravel realtionship groupBy

1 Answers1