PrevPrev Go to previous topic
NextNext Go to next topic
Last Post 03/26/2015 8:15 AM by  The.Sam.Groves
Name Changes
 2 Replies
Sort:
You are not authorized to post a reply.
Author Messages
thummel1
Data Analyst II
Fairview Health Services
Veteran Member
(183 points)
Veteran Member
Posts:101


Send Message:

--
03/26/2015 6: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
    Private
    Private
    Senior Member
    (9563 points)
    Senior Member
    Posts:3205


    Send Message:

    --
    03/26/2015 8:13 AM
    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
    Programmer Analyst
    St Lukes Hospital
    Veteran Member
    (265 points)
    Veteran Member
    Posts:89


    Send Message:

    --
    03/26/2015 8:15 AM
    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.