This topic is based on this post: https://forum.awareim.com/d/9026
I try to use REPLACE_PATTERN function with some attributes, but if one attribute is empty->the result of the function is empty attribute also.
For example:
Orders.CustomerFirstName = Jane
Orders.CustomerLastName = Doe
Creating another BO based on Orders.BO with these rules => the result is ok.
Rule 1:
If Messages.HTML CONTAINS '{CustomerFirstName}' Then
Messages.HTML=REPLACE_PATTERN(Messages.HTML,'\{CustomerFirstName\}',Messages.Owner.Customer_FirstName)
Rule 2:
If Messages.HTML CONTAINS '{CustomerLastName}' Then
Messages.HTML=REPLACE_PATTERN(Messages.HTML,'\{CustomerLastName\}',Messages.Owner.Customer_LastName)
BUT if one of the fields are empty => the result of REPLACE_PATERN is also empty
Orders.CustomerFirstName = 'Jane'
Orders.CustomerLastName = ''
https://streamable.com/3g3yf
Here is a sample BSV:
- Create one Order (complete Customer First Name, Customer Last name)
- Create a message template with both 2 tokens {CustomerFirstName} {CustomerLastName}
- In Orders list query -> click "Create Message" button
==> inspect the result in "Messages" query (you should see the message with entered info in Orders attributes)
- Edit the Order and empty one field
- In Orders list query -> click "Create Message" button -->inspect the created message ->the result will be an empty field.