Uploaded image for project: 'CFA MX '
  1. CFA MX
  2. CFAMX-1194

2019.R1(S6):Order Guide- No Discontinue Date in Rule does not update VEI

    Details

    • Type: Sprint Defect
    • Status: Done (View Workflow)
    • Priority: Major
    • Resolution: Completed
    • Affects Version/s: CFA 2019R1
    • Fix Version/s: CFA 2019R1
    • Component/s: OrderGuide
    • Labels:
      None

      Description

      Both the Vendor Item, Discontinue Date and the Rule End Date, contain NULL Dates.  In this case, the VEI table for the item should be updated to NULL.  Actual results, the whatever value in the table remained.

      Please search  item  '043514'  on the Assign Vendor Items Page: https://m.inform.jatesting.cfahome.com/#/Administration/AssignVendorItems/AssignVendorItems

      DECLARE @EntityId bigint = 1287
      DECLARE @VendorCode varchar(50) = '043514'
      select vei.IntroductionDate
      , vei.DiscontinueDate
      , vei.DiscontinueDateOverridden
      , vei.DiscontinueDateOverrideEnabled
      , vei.ItemID
      , *
      from tbVendorEntityItem vei with (nolock)
      where vei.entityid = @EntityID
      and vei.VendorCode = @VendorCode

       

      --Vendor Item Intro and Discontinue Dates

      select vi.IntroductionDate as 'Vendor Intro Date'
      , vi.DiscontinueDate as 'Vendor Disc Date'
      , *
      from tbVendorItem vi with (nolock)
      where vi.VendorCode = '043514'

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                soma.dixon Soma Dixon (Inactive)
                Reporter:
                soma.dixon Soma Dixon (Inactive)
              • Watchers:
                1 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved:

                  Time Tracking

                  Estimated:
                  Original Estimate - 1h Original Estimate - 1h
                  1h
                  Remaining:
                  Remaining Estimate - 0h
                  0h
                  Logged:
                  Time Spent - 1.5h
                  1.5h

                    PagerDuty

                    Error rendering 'com.pagerduty.jira-server-plugin:PagerDuty'. Please contact your Jira administrators.