Skip to main content
Solved

Event Action condition IS NOT NULL


Forum|alt.badge.img+7
  • Sidekick (Customer)
  • 33 replies

Dear Community, 

 

Maybe you have some ideas for our small issue. 

We are using Apps10 UPD14.

We have some email sending event actions, but not all the time we have “To:” email addresses (coming from substitution field: &EMAIL_SENDER_ADDR). 

If there is no value in the &EMAIL_SENDER_ADDR the Application message status will be Failed because no To: address. 

Question is: how can I tell the event action, it should perform the event only if the &EMAIL_SENDER_ADDR IS NOT NULL? 

Can I use e.g.: = ‘%’ or LIKE ‘%’ or do you know any trick? 

 

 

Thank you very much in advance for any suggestion!

Kind regards, 

Balazs

Best answer by jaw

Hi,

We faced the same issue. LIKE % will be true for any value other than NULL and not fire the action.

Good luck!

Alexander

View original
Did this topic help you find an answer to your question?

4 replies

Forum|alt.badge.img+2
  • Do Gooder (Customer)
  • 3 replies
  • Answer
  • January 9, 2024

Hi,

We faced the same issue. LIKE % will be true for any value other than NULL and not fire the action.

Good luck!

Alexander


Jonas Feigl
Superhero (Employee)
Forum|alt.badge.img+20
  • Superhero (Employee)
  • 263 replies
  • January 10, 2024

Hi @bapehu . I can confirm that what @jaw has said should work. Actually using “=%” should also work.

 

For future reference: The conditions for the “=” option are actually evaluated by database method “Report_SYS.Parse_Parameter” which supports all the usual search syntaxes that are also available in the client. This includes wildcards “A%”, lists “B;C;D”, ranges “E..G”, or a combination of it “A%;B;C;D;E..G”.


Forum|alt.badge.img+7
  • Author
  • Sidekick (Customer)
  • 33 replies
  • January 10, 2024
jaw wrote:

Hi,

We faced the same issue. LIKE % will be true for any value other than NULL and not fire the action.

Good luck!

Alexander

Thank you very much Alexander, I tried and works! 


Forum|alt.badge.img+7
  • Author
  • Sidekick (Customer)
  • 33 replies
  • January 10, 2024
Jonas Feigl wrote:

Hi @bapehu . I can confirm that what @jaw has said should work. Actually using “=%” should also work.

 

For future reference: The conditions for the “=” option are actually evaluated by database method “Report_SYS.Parse_Parameter” which supports all the usual search syntaxes that are also available in the client. This includes wildcards “A%”, lists “B;C;D”, ranges “E..G”, or a combination of it “A%;B;C;D;E..G”.

Hi Jonas, 

Thank you so much the explanation and the examples! Very helpful to understand if we have more possibilities! 

Kind Regards, 

Balazs


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings