Solved

Filter rows in ODX on multiple substrings

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.

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.

Thanks RLB that did the trick

Sign up