Uploaded image for project: 'mod-inventory-storage'
  1. mod-inventory-storage
  2. MODINVSTOR-392

Make item.status.date read only field.

    XMLWordPrintable

Details

    • Core: F - Sprint 79, Core: F - Sprint 80
    • 3
    • Prokopovych

    Description

      Spike outcome: investigate what modules will be updated & get familiarized with code. Investigate ways of implementation.

      This is a breaking compatibility change.

      • Make the item.status.date as readonly (it is populated by a DB trigger now, see MODINVSTOR-367).
      • Add "format": "date-time" so the property becomes java Date instead of raw string.
      Implementation notes

      RMB removes readonly fields before updating them, so we additionally have to update instanceStatusUpdatedDateTrigger.sql trigger, so it will transfer the OLD statusUpdatedDate to the NEW record, i.e.:

      IF (OLD.jsonb->'status'->>'date' IS NOT NULL) THEN
   NEW.jsonb->'status'->>'date'= OLD.jsonb->'status'->>'date';
END IF;

      TestRail: Results

        Attachments

          Issue Links

            defines

            Umbrella - MODINVSTOR-416 Item Storage 8.0

            • P2 - normal priority level, must be included in the current development cycle
            • Closed
            relates to

            Story - Created by Jira Software - do not edit or delete. Issue type for a user story. MODINVSTOR-388 Make instance.statusUpdatedDate read only field.

            • P3 - low priority level, item will be considered for inclusion in the next dev cycle
            • Open

            Bug - A problem which impairs or prevents the functions of the product. RMB-538 JSON validation: read-only sub-fields, translation code

            • TBD - To be determined
            • Closed

            Story - Created by Jira Software - do not edit or delete. Issue type for a user story. MODINVSTOR-367 Maintain item status date even if item record is edited

            • P2 - normal priority level, must be included in the current development cycle
            • Closed
            requires

            Story - Created by Jira Software - do not edit or delete. Issue type for a user story. CIRC-608 Item-storage 8.0 breaking changes

            • P2 - normal priority level, must be included in the current development cycle
            • Closed

            Story - Created by Jira Software - do not edit or delete. Issue type for a user story. MODINV-189 Item-storage 8.0 breaking changes

            • P2 - normal priority level, must be included in the current development cycle
            • Closed

            Activity

              People

                bohdan-suprun Bohdan Suprun
                VRohach Volodymyr Rohach
                Votes:
                0 Vote for this issue
                Watchers:
                6 Start watching this issue

                Dates

                  Created:
                  Updated:
                  Resolved:

                  TestRail: Runs

                    TestRail: Cases