Prev
Next
Forums Smart Notification

Name Changes

Sort:
You are not authorized to post a reply.
Author
Messages
thummel1
Veteran Member
Posts: 121
Veteran Member
3/26/2015 10:58 AM
    Hi,

    I have a name change Smart Note that I am testing for functionality. One thing I noticed is that whenever someone's name changes from all capital letters to lowercase letters, or vice versa, it triggers this record to appear on the Smart Note. (We have a process where some groups of individuals need to be listed as all caps and some don't, and sometimes their role changes, thus we'll change them from all capital letters to non and vice versa).

    How can I stop the Smart Note from capturing these types of changes? Thanks
    John Henley
    Senior Member
    Posts: 3348
    Senior Member
    3/26/2015 12:13 PM
      Is the notification using an infoset based on an DME query against EMPLOYEE? If so, try adding LAST-NAME-UC and FIRST-NAME-UC to the query and use those rather than LAST-NAME and FIRST-NAME for determining changes.
      Thanks for using the LawsonGuru.com forums!
      John
      The.Sam.Groves
      Veteran Member
      Posts: 89
      Veteran Member
      3/26/2015 12:15 PM
        And if it's using a SQL query, instead of pulling the raw fields, encase them in an UPPER(fieldname) or LOWER(fieldname) so that the string comparisons are apples to apples instead of apples to oranges.
        You are not authorized to post a reply.