Restore a deleted item

In MassTrack you have two options for restoring a deleted item. See the two different approach in the text below. 

Restoring a Deleted Item in the Item Window

To restore a deleted item, right click anywhere in the table view of the Item Window and select “Deleted Items..” (not “Delete Item(s)) from the submenu.

This will bring up a window showing all deleted items, screened by the same filter that is applied to the Item Window you are running this function from. This means that if you have the Item Window open for a particular weight group, the Deleted Items window will show deleted items for this weight group only. If you have another filter applied in the Item Window, in example related to a maximum weight or CG position, this will also be applied when showing the deleted items, and so on.

To restore a deleted item, mark the item or items in the Deleted Items Window, rightclick and select “Restore” from the submenu.

Restoring from the Project Log Database Window

If you want to restore multiple items from a potential mix of changed and deleted items, this can be done from the Project Log Database window. You open this window from the menu “Database->Administrator->Project Log Database…”

After this window opens, make sure that you navigate and select the “ITEM” table as shown below.   To restore items, mark the items you want to restore, right-click and select “Restore” from the submenu.

This window also has input boxes for “Filter” and “Sort”.  Sorting can also be done by clicking the column header of the quantity you want to sort on. Clicking once will sort ascending, while clicking one more time will sort descending.  If you want to type in the sort syntax in the sort input box, the syntax is [<Qnt>] DESC/ASC and sorting on more than one column is done by separating the sort commands by comma.  In example:   [Description] ASC, [LCG] DESC   will sort first on the description column, then descending on the LCG column.

If you want to use the “Filter” input box, standard SQL filter syntax should be applied, in example “[Description] Like ‘Unit%’” or “[Weight] < 100”.

Note that if you scroll to the end of the table, you will find a column named “Changes”.  This column will tell you if a row was the first insert of the item (“Insert”), an update of an existing item (“Update”) or an item that has been deleted (“Delete”).  See picture below.