I am trying to write a SQL query to provide that information. Here I can see some data inconsistency between tables workorder, workorderhistory, workorderstates, wo_assessment and wo_tech_info. Probably I am not aware of how the system works.

Any help will be appreciated.

Regards

Nelson