Skip to main content
Solved

Event Action Details Conditions


Forum|alt.badge.img+3
  • Do Gooder (Customer)
  • 4 replies

Would like to know, if this is the correct method of using the LIKE in a Condition?

 

 

Best answer by Charana Udugama

Hi @dwils,

LIKE condition is used match patterns. This is almost same as what you use in Search in IFSAPPs.

For an example we need names starting with the letter ‘R’. We can put the value as ‘R%’. If we need something that ends with the letters ‘er’. We can put the value as ‘%er’. 

Here is a document on the usage of LIKE Oracle / PLSQL: LIKE Condition (techonthenet.com)

Hope this helps.

Regards,
Charana

 

View original
This topic has been closed for comments

2 replies

Charana Udugama
Superhero (Employee)
Forum|alt.badge.img+12
  • Superhero (Employee)
  • 114 replies
  • Answer
  • March 24, 2022

Hi @dwils,

LIKE condition is used match patterns. This is almost same as what you use in Search in IFSAPPs.

For an example we need names starting with the letter ‘R’. We can put the value as ‘R%’. If we need something that ends with the letters ‘er’. We can put the value as ‘%er’. 

Here is a document on the usage of LIKE Oracle / PLSQL: LIKE Condition (techonthenet.com)

Hope this helps.

Regards,
Charana

 


Forum|alt.badge.img+3
  • Author
  • Do Gooder (Customer)
  • 4 replies
  • March 25, 2022

yes thank you, Realized that after I saw your reply.

I overthought this one. 

I need an IN (), but it isn’t available.

I was looking for a way in the condition to say 900 or 500.

I can just try this.


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