Handover Transition - SWCR status code incorrect. e.g.,, Comm. pkg. 8730-H03

[EDUT-Equinor]

Description

Status for SWCR picking up wrong Status.

These two SWCR-status-code for Comm. pkg. 8730-H03. The old version shows "Closed - Rejected" which is correct, and the new version shows "Accepted" which is not the current status.

Reproduce

Old Handover - Correct :

New Handover - Incorrect:

Expected behavior

[Gustav-Eikaas]

@BenSvend, can you verify this calculation in the SQL view?

[BenSvend]

@Gustav-Eikaas In the data I can see in FAM (their completion view, not one we've created). It does indeed show what is displayed on the bottom image. I don't have access to check how the calculation is made, and I therefore assume that the data is wrong. Should contact FAM for clearification.

[BenSvend]

Accodring to FAM the mistake lies with Procosys, the following is a response from Procosys:

"Status is a calculated field, based on several tables, it is not persisted. We do send the current status when sending the swcr, but perhaps that is a mistake.
This is a bug, and I'm not sure how to solve it, will have to work it out."

[ken-mellem]

We recognize the issue - our decision is to remove the SWCR Status field from the view until we get a properly calculated field from source.

[BenSvend]

Closing this issue as "Wont fix". Since FAM have indicated that they will remove the Status field from their database until further notice.

Look at the issue below for more information:

• SWCR: SWCR.Status Field from SWCR cc-components#741

[EDUT-Equinor]

Hei @BenSvend @ken-mellem - we defo need this issue resolved somehow, have had some more comments today about it not working.

[EDUT-Equinor]

Here are some pics i got yesterday on topice - we cant have errors like these if we want users to trust new tools, that is my concern.
Old

New

Old:

new:

Same issue also happening in Query:
Old:

New

Please check related Queries in ProCoSys:

[ken-mellem]

Closed as duplicate

See

• SWCR: SWCR.Status Field from SWCR cc-components#741

[ken-mellem]

@EDUT-Equinor calculation issues for Query should be reported in a new separate issue - thanks.

[EDUT-Equinor]

yes whoops! i did do that but forgot to remove the query issue here!