• Search Forums
    Advanced Search Topics Posts
Prev
Next
Forums Performance Management Smart Notification

Name Changes

 2 Replies
 2 Subscribed to this topic
 14 Subscribed to this forum
Sort:
Author
Messages
thummel1
Veteran Member Send Private Message
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
Send Private Message
Posts: 3351
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 Send Private Message
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.