Message of the day:
Security release 4.4.4 is out. Changelog: https://github.com/silverstripe/silverstripe-framework/blob/4/docs/en/04_Changelogs/4.4.4.md
SilverStripe 4 related information and questions.
When you run the query, are all the rows null, or just some?
something like this seems like what you are going for: https://stackoverflow.com/questions/725556/how-can-i-merge-two-mysql-tables
It's doesn't help that 'Order' is a reserved word... makes the quoting extremely important
which do you prefer, if the field is defined on both tables?
well a loop seems like a straightforward way to do it, though probably not too efficient
it needs to be an upgrade task we can run during dev build
yes, there are multiple projects we need to upgrade from ss3 to ss4 that have our custom commerce modules installed
Do you need to do this in SQL? Could you export to CSV and import?
in ss3 order was the base object and estimate was an extension in ss4 estimate is the base object and the order (now called invoice) is the extension
It's upgrading some tables from ss3 to ss4 the tables are different in ss4 so i need to merge the data from both tables and use that data to create new orders