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

Collected Sales - Select Customer does not display Customers w/leading or trailing spaces

    Details

    • Root cause - Reason:
      Bad data

      Description

      Scenario - 00663 in testing/ April 9
      This store has multiple records in the CustomerInformation table with trailing and leading spaces.
      When a customer that has a leading space or a trailing space is used (# of leading or trailing is irrelevant) for a Collected Sale on the POS
      AND when that customer is selected from the Unapplied view in MXC

      And Apply to Invoice is clicked
      And the Select Customer modal is displayed

      Defect - the customer is not displayed by default as it should - as in this case with Roper Mt.Science Center which has leading spaces.

      These queries were used to determine the lead and trailing spaces by store EntityID. In this case I am working with 00663 / Entity ID 386 in testing.

      SELECT entityID,CustomerName --trailing spaces
      FROM CustomerInformation where CustomerName not like RTRIM(CustomerName)
      and entityId ='386'

      entityID CustomerName
      386 Aldersgate Child Developement
      386 Sealed Air
      386 Mt Lebenon Elem
      386 Shannon Brame Jour. HospMoo86
      386 Janice Grant--Duke
      386 Becky Hyatt Pelham LinksMOO26
      386 PMP Swimteam

      SELECT entityID,CustomerName --leading & trailing spaces both
      FROM CustomerInformation where CustomerName not like LTRIM(CustomerName) and CustomerName not like RTRIM(CustomerName)
      --and entityId ='386'
      **NONE**

      SELECT entityID,CustomerName --leading spaces
      FROM CustomerInformation where CustomerName not like LTRIM(CustomerName)
      and entityId ='386'

      386 Carolina Center for BSMOO 45
      386 Roper Mt. Science Cent

        Attachments

        1. AFTER - Leading #2.PNG
          86 kB
          Charles Wheeler
        2. After - LEADING 1.PNG
          38 kB
          Charles Wheeler
        3. image-2020-04-09-16-46-26-655.png
          68 kB
          Charles Wheeler
        4. image-2020-04-09-16-47-41-975.png
          76 kB
          Charles Wheeler
        5. Leading BEFORE.PNG
          89 kB
          Charles Wheeler

          Issue Links

            Activity

              People

              • Assignee:
                will.englefield Will Englefield (Inactive)
                Reporter:
                charles.wheeler Charles Wheeler
              • Watchers:
                2 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved:

                  PagerDuty

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