CMDBuild Forum

Work order link is missing

Old Versions
#1

Hi there, 

Our OM instance is using latest CMDBuild 2.4 + OM 1.0. We have some workflow issues and try to fix them before the latest OM release. 

When a work order is created via Maintenance Request.  it's shown on the work order grid list. However, when I check the relationship tab, there's no link between work order and maintenance request. 

 

Within Map_MaintenanceRequestWorkOrder table, there are two records found related to above WO and MR but the Status are "N" and "U". 

    • IdDomain, IdClass1, IdObj1, IdClass2, IdObj2, Status, User, BeginDate,  EndDate, Id
    • ""Map_MaintenanceRequestWorkorder"";""MaintenanceRequest"";242621;""Workorder"";242641;"N";"system";"2016-05-17 05:58:19.290561";"";242643
    • ""Map_MaintenanceRequestWorkorder"";""MaintenanceRequest"";242621;""Workorder"";242641;"U";"system / admin";"2016-05-17 05:58:17.655987";"2016-05-17 05:58:19.290561";242643

Below script return a empty list.

cd_workorder_list = cmdb.queryRelations("MaintenanceRequest",ProcessId.intValue())
                             .withDomain("MaintenanceRequestWorkorder")
.fetch();
    Any idea how to fix it ? and what does status "N" and "U" stands for . 

    Also, does work order can only be generated by MR as it returns a blank property tab when clicking "create work order" button. It happens on both OM 1.0 + CMDB2.3 and OM1.0 + CMDB2.4

     

    Thank you.