Changes affecting Web Services in MRI Evolution release 5.9.0.0



JIRA Ref Work Item Type Web Service Change Details DTO Value(s)

CE-83

Story

Account Service

New Web Methods:

Accounts

  • GetAccountsbyDto

Roles

  • GetRolesByDto

  • GetRolesById

  • CreateRole

  • UpdateRole

Others

  • GetUserLicenceTypesByDto

  • GetReachMenuItemsByDto

  • GetAccountProfilesByDto

CE-524

Story Account Service

New MRI Evolution Securables have been added to control the new web methods, as below:

  • Retrieve Accounts - GetAccountsbyDto

  • Retrieve Roles - GetRolesByDto, GetRolesById

  • Create Roles - CreateRole

  • Update Roles - UpdateRole

  • Retrieve User Licence Types - GetUserLicenceTypesByDto

  • Retrieve Account Profiles - GetAccountProfilesByDto

  • Retrieve Reach Menu Items - GetReachMenuItemsByDto

 
CE-674 Story Account Service

New AccountUserLicenceTypeDto.

New web methods:

  • GetAccountUserLicenceTypesByDto

  • GetAccountUserLicenceTypeById

  • CreateAccountUserLicenceType

    • Custom method that will create a record with incoming parameters:

      • AccountId

      • UserLicenceTypeName- string

  • DeleteAccountUserLicenceType

    • Custom method that will delete record with incoming parameters:

      • AccountId

      • UserLicenceTypeName - string

New MRI Evolution Securables have been added to control the new web methods, as below:

  • Retrieve Account User Licence Types - GetAccountUserLicenceTypesByDto

  • Delete Account User Licence Types - DeleteAccountUserLicenceType

  • Create Account User Licence Types - CreateAccountUserLicenceType

AccountId, UserLicenceTypeName (String value from UserLicenceTypes.Name)
CE-675 Story Account Service

New AccountRoleDto.

New web methods:

  • GetAccountRolesByDto

  • GetAccountRoleById

  • CreateAccountRole

  • DeleteAccountRole

New MRI Evolution Securables have been added to control the new web methods, as below:

  • Retrieve Account Roles -GetAccountRolesByDto, GetAccountRoleById

  • Delete Account Roles - DeleteAccountRole

  • Create Account Roles - CreateAccountRole

AccountRoleId, AccountId, RoleId, DatabaseId

CE-89

Story

Asset Service V3

The AssetDto has been modified so that it contains a read-only field for AssetClassificationId.

It will only be used for the purposes of retrieving Assets in the GetAssetByDto method.

If a value is passed for AssetClassificationId in GetAssetsByDto then the array of returned assets will be filtered to include those linked to an AssetClassGroupClass that has a AssetClassificationId matching the value being passed.

AssetClassificationId

CE-1254 Story Concept Document Service V3

New ConceptDocumentRequestDto Dto fields.

IntegrationSystem, IntegrationObject, IntegrationIdentifier, ExternalController, IntegrationDate
CE-1255 Story Concept Document Service V3

New Dto fields:

  • ConceptDocumentEntityAssignRequestDto

  • BIMDocumentEntityAssignRequestDto

IntegrationSystem, IntegrationObject, IntegrationIdentifier, ExternalController, IntegrationDate

CE-476

Story Contract Service V3

The ContractScheduleOfRateDto has been modified so that it contains a read-only field for ScheduleOfRatesMasterGroupId.

It will only be used for the purposes of retrieving assets in the GetContractScheduleOfRateByDto method. 

If a value is passed for ScheduleOfRatesMasterGroupId in GetContractScheduleOfRateByDto then the array of returned Schedule of Rates should be filtered to include those linked to a ScheduleOfRatesMasters that has a ScheduleOfRatesMasterGroupId matching the value being passed.

ScheduleOfRatesMasterGroupId
CE-1252 Story Events Service New EventsDto Dto fields. IntegrationSystem, IntegrationObject, IntegrationIdentifier, ExternalController, IntegrationDate

CE-587

Story Property Service V3 New LocationDto field. MobileLocation
CE-980 Story Property Service V3 New BuildingDto field. DefaultContractId
CE-982 Story Property Service V3 New PortfolioTypes Dto field. ServiceCataloguePortfolio
CE-1118 Story Property Service V3 New read only Portfolio Dto fields. PortfolioType, ServiceCataloguePortfolio

CE-585

Story Resource Service V3

New ResourceLogOnLogOff Dto.

New web methods:

  • GetResourceLogOnLogOffsByDto

  • GetResourceLogOnLogOffById

  • DeleteResourceLogOnLogOff

New MRI Evolution Securables have been added to control the new web methods, as below:

Retrieve Resource Log On Log Off History - GetResourceLogOnLogOffsByDto, GetResourceLogOnLogOffById

Delete Resource Log On Log Off History - DeleteResourceLogOnLogOff

ResourceLogOnLogOffId, ResourceId, LogOnTime, LogOffTime, SystemLogOnTime, SystemLogOffTime, LogOnLatitude, LogOnLongitude, LogOffLatitude, LogOffLongitude, IsAutoLogout
CE-602 CE-1147 Story Resource Service V3

New web method:

UpdateResourceLogOnLogOff

Returns - ResourceLogOnLogOffId

Web Method Logic

For both Logon and Logoff actions the web method will look up an F_RESOURCE record based on the ResourceId parameter.

If Action = Logon

  • Update F_RESOURCE.OnDuty to True

  • CREATE a new F_SS_LOGONOFFRECORD with the following details:

    • FKEY_RES_SEQ = ResourceId param

    • RESOURCE_TIME_LOGON = ResourceTime param

    • LogOnLatitude = Latitude param

    • LogOnLongitude = Longitude param

    • IsMobile = IsMobile param

    • IntegrationSystem = IntegrationSystem param

    • IntegrationObject = IntegrationObject param

    • IntegrationIdentifier = IntegrationIdentifier param

  • Update F_RESOURCE.CurrentLogOnOffId with the new F_SS_LOGONOFFRECORD.LOGON_SEQ

If Action = Logoff

  • Update F_RESOURCE.OnDuty to False

  • If a ResourceLogOnLogOffId has been provided look up F_SS_LOGONOFFRECORD

    • Where LOGON_SEQ = ResourceLogOnLogOffId

  • If a ResourceLogOnLogOffId has NOT been provided look up F_SS_LOGONOFFRECORD

    • Where F_SS_LOGONOFFRECORD.LOGON_SEQ = F_RESOURCE.CurrentLogOnOffId of the F_RESOURCE identified by the ResourceId param

  • If a matching F_SS_LOGONOFFRECORD is found then UPDATE the F_SS_LOGONOFFRECORD with the following details:

    • RESOURCE_TIME_LOGOFF = ResourceTime param

    • LogOffLatitude = Latitude param

    • LogOffLongitude = Longitude param

    • IsAutoLogout = IsAutoLogout param

 
CE-1151 Story Resource Service V3 New ResourceLogOnLogOff Dto field. IsMobile
CE-1223 Story Resource Service V3 New ResourceLogOnLogOff Dto fields. IntegrationSystem, IntegrationObject, IntegrationIdentifier, IntegrationDate

CE-116

Story Setup Service New CallEvents Dto fields. Comments, Mitigating, DefaultEventType, DefaultDueDateOffset, DefaultDuration, AvailableIn, VisibleIn, ForceLoCChange, LevelOfCompletionId, IsSystemEvent

CE-586

Story Stock Service V3

New read only fields have been added to the StockLocationResourceDto.

Location, LocationLongitude, LocationLatitude, MobileLocation, Building, BuildingLongitude, BuildingLatitude

CE-593

Story Stock Service V3

New read only fields have been added to the StockItemDto.

Location, LocationLongitude, LocationLatitude, MobileLocation, Building, BuildingLongitude, BuildingLatitude

CE-114

Story

Task Events Service

Task Service V3

New F_EVENTS Dto fields. Duration, ActionedBy, ActionedByAccountId

CE-1253

Story

Task Events Service

Task Service V3

New F_EVENTS Dto fields. IntegrationSystem, IntegrationObject, IntegrationIdentifier, ExternalController, IntegrationDate

CE-122

Story

Task Events Service

Task Service V3

The save method for F_EVENTS has been updated so that it will automatically set values in F_EVENTS based on values from the associated CallEvent.

This will only happen if specific values are NOT passed in the web service.

  • EV_TYPE - DefaultEventType

    • The value of F_EVENTS.EV_TYPE for the event should be set based on the DefaultEventType of the associated CallEvent

  • EV_COMMENTS - Comments

    • The F_EVENTS.EV_COMMENTS for the event should be set based on the Comments of the associated CallEvent

  • Duration - DefaultDuration

    • The F_EVENTS.Duration of the event should be set based on the DefaultDuration of the associated CallEvent

  • EV_DUE_DATE - CurrentDateTime + DefaultDueDateOffset

    • The value of F_EVENTS.EV_DUE_DATE for the event should be set based on the DefaultDueDateOffset of the associated CallEvent. The Due Date should be set as the CurrentDateTime PLUS the DefaultDueDateOffset

  • IsSystem - IsSystemEvent

    • The value of F_EVENTS.IsSystem be set based on the IsSystemEvent of the associated CallEvent.

The Create and Update methods for F_EVENTS have been updated to save values for the following new fields.

On INSERT

If the value of F_EVENTS.EV_ACTIONED is inserted as 1 then:

  • ActionedBy = Accounts.FullName of Account creating the Event

  • ActionedByAccountId = Accounts.AccountId creating the Event

On UPDATE

If the value of F_EVENTS.EV_ACTIONED is Updated from 0 to 1 then:

  • ActionedBy = Accounts.FullName of Account updating the Event

  • ActionedByAccountId = Accounts.AccountId updating the Event

If the value of F_EVENTS.EV_ACTIONED is Updated from 1 to 0 then:

  • ActionedBy = reset to blank ''

  • ActionedByAccountId = reset to NULL

 
CE-1042 Bug Task Service V3 The Timezone for TA_DATE field was always being set to the System timezone when Tasks were created using TaskServiceV3 webservice.  

CE-110

Story

Task Service V3

PMS Service

New read only fields have been added to the base TaskDtoV3.

They are available in the following derived Dtos:

  • BreakDownTaskDtoV3

  • PPMTaskDtoV3

  • ProjectTaskDtoV3

  • ScheduledTaskDtoV3

TaskPerfSLARespondDate,  TaskPerfSLAAttendDate,  TaskPerfSLAContainDate,  TaskPerfSLAFixDate, TaskPerfSLAUserDefinedDate,  TaskPerfRespondDate,  TaskPerfAttendDate,  TaskPerfContainDate, TaskPerfFixDate,  TaskPerfUserDefinedDate,  TaskPerfMeasurable

CE-1251

Story

Task Service V3

PMS Service

New read only fields have been added to the base TaskDtoV3.

They are available in the following derived Dtos:

  • BreakDownTaskDtoV3

  • PPMTaskDtoV3

  • ProjectTaskDtoV3

  • ScheduledTaskDtoV3

IntegrationSystem, IntegrationObject, IntegrationIdentifier, ExternalController, IntegrationDate

CE-976 Story Time Record Service V3 New TimeRecordDtoV3 Dto fields. IntegrationSystem, IntegrationObject, IntegrationIdentifier, ExternalController, IntegrationDate, Integrated
CE-92 Story Time Record Service V3 New TimeRecordDtoV3 Dto fields. ExcludeFromSLA