Pull data from hikashop_history table

-- HikaShop version -- : 4.7.2
-- Joomla version -- : 3.10.11
-- PHP version -- : 8.0.28

Hello,
We are wishing to search the hikashop_history table to get some information from multiple orders.
The hikashop_history is shown per order on the order details page. We would like to query this table.
Is there a method to do this using REPORTS and/or MASS ACTIONS?

The issue we face is the order is tagged with the last action change and so if an order is paid after it is shipped then that order will not be shown in a list of shipped orders - as the last moficiation was set to 'paid'.

We would like to get a list of all shipped orders even if the last modification is something else after the order has been shipped.
Currently we are unable / do not know how to achieve this.

I cannot seem to locate the table in the Hikashop Admin UI in Mass Action or Reports
I can see the table in phpMyAdmin however I do not understand how to get the date of modification.

Please advise.

Hello Philip,
Thank you for your reply.

Did you look at the HikaShop MassAction system?
>> Yes, I have used MassAction and I understand (basically) how to use it.

Thank you for the detailed instruction to get the current order status - unfortunately this is not what we are wanting to achieve.
We do not need to make changes to the status. We want to get the information from the hikashop_history table that is found in the ORDER DETAILS screen. We need to get the date for previously shipped statuses.

However, the table hikashop_history is not available in MassActions - is there a way to add this table?

Hi Nicolas,
Thank you for your directions, I have used them as start to get the data.
I appreciate your help.