Forums
Smart Notification
Name Changes
Author
Messages
thummel1
Veteran Member
Posts: 121
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: 3349
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.
The.Sam.Groves
Veteran Member
Posts: 89
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.