Skip to main content
To homepage To homepage
Solved

Filter rows in ODX on multiple substrings

  • September 23, 2024
  • 2 replies
  • 47 views
H
Starter

Hi I am trying to find a way to filter rows in ODX on multiple 'like’ expressions.

Below the SQL statement i use in SQL Server Manager that i would like to implement;

SELECT [autoid], [values]
FROM TableA
WHERE [autoid] > 61103544
AND  ([values] like '<N V="D%' or [values] like '<N V="VAS%')

How can we achieve this in ODX so I can limit the amount of records retrieved from the source.

Thanks in Advance

Hans

Best answer by RLB

You should be able to add two rules: one where autoid > 61103544 and values like <N V="D% and one where autoid > 61103544 and values like <N V="VAS%.

So basically you need two AND rules.

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

2 replies

R
Contributor
  • RLB
  • Contributor
  • 78 replies
  • Answer
  • September 23, 2024

You should be able to add two rules: one where autoid > 61103544 and values like <N V="D% and one where autoid > 61103544 and values like <N V="VAS%.

So basically you need two AND rules.

H
Starter
  • HansZZV
  • Author
  • Starter
  • 1 reply
  • September 23, 2024

Thanks RLB that did the trick

R
1 person likes this

Reply


Most helpful members this week

Terms and ConditionsCookie settings

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