Level 43
Maybe do this:
Model::select('column->property as field')
->...
->groupBy('field');
2 likes
Jan 7, 2018
6
Level 27
Can I group by a json property?
Hi there,
me again ;-). Can I make an eloquent query to group by a json column property like:
Model::get()->groupBy('column->property')
? Does not seem to work, but maybe it does not work at all?
Cheers
Chris
Level 27
Hey crnkovic,
many thanks :-). That did work as expected.
Level 6
Hi) How i can select all distinct values from json array? My structure is: id, items. Items contains json array like ['Apple', 'Orange'], ['Apple', 'Juice', 'Tomato']. I want select all distinct, i.e. Apple, Orange, Juice, Tomato.
Level 102
@addorange please create a new topic instead of high jacking someone else's
Level 27
@sinnbeck Excuse me. Whose topic did I hijack?
Level 102
@addorange Sorry! Must have selected you instead of @projct1 by mistake
Sorry about that :)
Please or to participate in this conversation.