Update new DataTable row value to database

menashe

I have the following:

The Low Price field (which is a database column on the Packaging table) on the Packaging row is updated dynamically as a row in the Prices (child) table is modified (or added).

How can I save that table value to the database?

menashe

I actually came up with a much more elegant solution! The Lowest Price field is no longer in the database; it is "virtual".

I thought that I needed it in the database to display the Lowest Price BEFORE the Price (child) rows were expanded.

But, instead, I now generate it as a column of the Packaging table!

    ->leftJoin('(SELECT packaging_id, min(price) as lowest_price FROM prices WHERE prices.date > now() - INTERVAL \'90 days\' GROUP BY packaging_id) lowest', 'lowest.packaging_id', '=', 'packaging.id')

allan

Awesome - great to hear you found a solution.

Allan