Search query does not written array object

Asked Apr 11 '17 at 05:57

Active Apr 11 '17 at 10:08

Viewed 171 times

I am working in Laravel 5.4. I have written a search query and it works fine. But it does not return array object.

It return like below data:

"user" : {
     2: {
        "id":2,
        "firstname":"xyz"
     },
     3: {
        "id":31,
        "firstname":"abc"
     },
     5: {
        "id":42,
        "firstname":"pqr"
     }
}

But I need array like below:

"user" : [
     {
        "id":2,
        "firstname":"xyz"
     },
     {
        "id":31,
        "firstname":"abc"
     },
     {
        "id":42,
        "firstname":"pqr"
     }
}

I have written query like :

User::search($request->data)->paginate(5);

In model I have write code as :

public function toSearchableArray()
{        
    return array_only($this->toArray(), ['id', 'firstname', 'lastname']);    
}

So what code should I have to change to return as per the required data?

Note: I have tried toArray() but it does not work.

edited Apr 11 '17 at 10:08

jedrzej.kurylo

39,591
9
98
107

asked Apr 11 '17 at 05:57

Nisarg Bhavsar

Might help to show what your `search` code is like. Most likely `User::search($request->data)->values()->paginate(5)` will work but not sure. – apokryfos Apr 11 '17 at 05:59
@apokryfos it gives an error as `Call to undefined method Laravel\Scout\Builder::values()`. – Nisarg Bhavsar Apr 11 '17 at 06:01
I don't see scout supporting this out of the box then. You can probably get the paginated results page as a collection and do a `->values()` on that but that's a bit shady. – apokryfos Apr 11 '17 at 06:20
@apokryfos I have same query in the same function. It returns perfect with paginate but this query does not return. – Nisarg Bhavsar Apr 11 '17 at 06:37
It's probably because this is getting a result and then it's filtering it. It's not the same as a normal eloquent query, it probably tries to keep the indexes matched with what the equivalent eloquent query would return. – apokryfos Apr 11 '17 at 06:53
@apokryfos So, how can I resolve it? – Nisarg Bhavsar Apr 11 '17 at 07:21
Can you share the piece of code that generates the data you are showing? – apokryfos Apr 11 '17 at 07:24
Can you show your configuration or customzation in your User model? – Cong Chen Apr 11 '17 at 08:03
@gentcys I have update question please check it. – Nisarg Bhavsar Apr 11 '17 at 08:25
Did you filter the result after `User::search($request->data)->paginate(5);`? – Cong Chen Apr 11 '17 at 09:59
@gentcys No, i do not filter after writing search query. – Nisarg Bhavsar Apr 11 '17 at 12:42
@NisargBhavsar May be you remove items in indexs`0, 1, 4` of `users`, and the result auto convert to object instead of array. – Cong Chen Apr 12 '17 at 01:42
@gentcys I have written same query for another model and its work fine and i do not do anything after writing this query. – Nisarg Bhavsar Apr 12 '17 at 04:37

Search query does not written array object

0 Answers0