Framework: [5.2] Pluck query by json column

[MCMatters]

When I make a query with plucking results by json property, I am getting a collection with nulls. For example:
\App\Entities\User::find(1140)->logins()->pluck('payload->ip')
Expected result: array with ips
Actually result:

Illuminate\Support\Collection {#1326
     all: [
       null,
       null,
       null,
     ],
   }

The results are correct but on a moment of a plucking they break.
laravel/framework/src/Illuminate/Database/Query/Builder.php

[themsaid]

It's extremely tricky to get this to work with the current way the query builder works :)

[MCMatters]

I've found the trick for this issue.
If I am using pluck('payload->ip AS ip') then everything is okay.

[themsaid]

nice :) Thanks for sharing.

[Omranic]

@MCMatters I'm currently in need for similar feature, but after trying both above syntaxes it seems to be not working, can you kindly confirm how you manage to make it work for you? 🙂

[MCMatters]

@Omranic, sure. Here is my example http://take.ms/BRQlV

[Omranic]

Thanks @MCMatters I see it's working on queries now, that's helpful 👍
Have you tried to make it work with normal collections?

[MCMatters]

@Omranic Yes. Just add casting to the attribute in the model and call pluck like this http://take.ms/KHT1i
I hope it will be useful

[Omranic]

Awesome, really appreciated 😊
Thanks @MCMatters

[gabriel-rod]

I've found the trick for this issue.
If I am using pluck('payload->ip AS ip') then everything is okay.

this works for me on localhost, but throws syntax error on shared hosting

[BasvanH]

I know it's old, but correct syntax is:

$model->pluck('json.key.key'));

Like:
$books->pluck('details.pages.page');