Level 36
one solution could be to write a helper function, eg like so:
public function filterMyDailyTracker($filtername)
{
$filter = \App\DailyTracker::query()->where('filtername', $filtername)->get();
return $filter;
}
1 like
Feb 23, 2016
7
Level 1
Reusing query with extra where condition.
I wanted to create two separate data sets from same table with two different condition.
For e.g see below, this is what all I need.
$filter = "select * from filters"; $filter_one = $filter . " where filtername = 'test'; $filter_two = $filter . " where filtername = 'test1';
I did it in the following way using laravel.
$filter = \App\DailyTracker::query(); $filter_one = $filter; $filter_two = $filter;
$res1 = $filter_one->where('filtername', 'test')->get(); $res2 = $filter_two->where('filtername', 'test1')->get();
$res1 gets the record as I expected, however $res2 is null because the second condition appended to the first one.
I guess it is object reference and that may be the reason. Anyhow, is there any way to achieve my requirement so that I can avoid writing same line of code again and again.
Level 10
THIS SOLUTION DOES NOT WORK, SORRY!
There is an method on Query Builder called newQuery() that will clone current query.
https://laravel.com/api/5.1/Illuminate/Database/Query/Builder.html#method_newQuery
$filter1 = $filter->newQuery();
$filter2 = $filter->newQuery();
Now your two new queries are isolated from filter.
1 like
Level 13
@EliasSoares That won't work since newQuery creates an empty query.
The best way to solve it is as @frezno suggested, or clone the query manually:
$filterOne = clone $filter;
$filterTwo = clone $filter;
4 likes
Level 10
@acasar Yes, sorry, I did some tests that worked, but it does not clone it.
The PHP clone solves it as you said.
2 likes
Level 1
@EliasSoares Thank you for your reply. I applied your solution, but it is making a new query, not a continuation of the object we are attempting to modify. Once again thanking you for the suggestion.
Level 1
Level 1
@acasar hurraaaay!! that worked :) thanks alot.
Please or to participate in this conversation.