Hi,
Please help to find the solution:
I have two tables in database join:
The table "Shipments" has a database join to table "Shipment_Status".
Each Shipment has many statuses, and I want to calc the latest (by date/time) status, as follows:
So, if, for example, Shipment1 has 3 statuses as follows, I want to get the value "Received" as a result of calc plugin:
2017-05 "Shipped"
2017-06 "Customs Clearance"
2017-07 "Received"
Thank you in advance!
Please help to find the solution:
I have two tables in database join:
The table "Shipments" has a database join to table "Shipment_Status".
Each Shipment has many statuses, and I want to calc the latest (by date/time) status, as follows:
So, if, for example, Shipment1 has 3 statuses as follows, I want to get the value "Received" as a result of calc plugin:
2017-05 "Shipped"
2017-06 "Customs Clearance"
2017-07 "Received"
Thank you in advance!