Skip to main content
Solved

Event Action condition IS NOT NULL

  • January 9, 2024
  • 4 replies
  • 446 views
B
Sidekick (Customer)
Forum|alt.badge.img+7
  • bapehu
  • Sidekick (Customer)
  • 34 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

4 replies

J
Do Gooder (Customer)
Forum|alt.badge.img+2
  • jaw
  • 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
  • Jonas Feigl
  • Superhero (Employee)
  • 266 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”.

B
Sidekick (Customer)
Forum|alt.badge.img+7
  • bapehu
  • Author
  • Sidekick (Customer)
  • 34 replies
  • January 10, 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

Thank you very much Alexander, I tried and works! 

B
Sidekick (Customer)
Forum|alt.badge.img+7
  • bapehu
  • Author
  • Sidekick (Customer)
  • 34 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”.

Hi Jonas, 

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

Kind Regards, 

Balazs


Terms & ConditionsCookie settingsAccessibility statement