Welcome Guest, Not a member yet? Register   Sign In
model 'withDeleted()'
#1

Hi, I'm have a weird problem, and I don't know how to fix it. I noticed that when using the withDeleted or onlyDeleted function of a model that has useSoftDeletes as true, it will add GROUP BY and ORDER BY to the query.
Here is the php code:
PHP Code:
$this->where('product_id'$productID)->selectSum('amount''total')->withDeleted()->first(); 
the query generated from this function is this:
Code:
SELECT SUM(`amount`) AS `total`
FROM `orders`
WHERE `product_id` = '40'
GROUP BY`orders`.`id`
ORDER BY `orders`.`id` ASC
LIMIT 1
but when I don't use the withDeleted function, the generated query is this:
Code:
SELECT SUM(`amount`) AS `total`
FROM `orders`
WHERE `product_id` = '40'
AND `orders`.`cancelled_at` IS NULL
LIMIT 1
is there any way to let the model build a query like this:
Code:
SELECT SUM(`amount`) AS `total`
FROM `orders`
WHERE `product_id` = '40'
LIMIT 1
Reply


Messages In This Thread
model 'withDeleted()' - by needhelp202 - 01-02-2022, 03:08 PM
RE: model 'withDeleted()' - by iRedds - 01-03-2022, 12:12 AM
RE: model 'withDeleted()' - by kenjis - 01-03-2022, 03:32 AM
RE: model 'withDeleted()' - by iRedds - 01-03-2022, 05:41 AM



Theme © iAndrew 2016 - Forum software by © MyBB