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 TableAWHERE [autoid] > 61103544AND ([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 AdvanceHans

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 Tautoid], ,values]
FROM TableA
WHERE Eautoid] > 61103544
AND (�values] like '<N V="D%' or ovalues] 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

Page 1 / 1

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