Relationship helpers
Sorry to just write it here in general, I have looked through alot of docs, tried many different ways and also used the AI.
Really the only solution I can find is to keep a separate table with the information combined, or adding the status to the "userOrders" table, but the status of the order could already be updating in many different places, and in a couple of months if adding a new way to update the status, one would forget to include "userOrders". and there is currently no platform level trigger that listenes to changes where one would safely implement this
Really the only solution I can find is to keep a separate table with the information combined, or adding the status to the "userOrders" table, but the status of the order could already be updating in many different places, and in a couple of months if adding a new way to update the status, one would forget to include "userOrders". and there is currently no platform level trigger that listenes to changes where one would safely implement this
