DataSources, ApplyFilter, and an OR statement

Hi All,

Sorry if this post is a repeat, normally I would ask google first but search for the phrase OR just seems like a bad idea.

Can someone please clarify for me how to us an OR condition in a filter on a DataSource?

As far as I can tell, the expression is being parsed correctly in Expressions.SplitFilter, but when it comes to Filter.ApplyFilter the OR statement does not seem to be taken into account.

Have I seriously miss-read something here?

Thanks

Nick

Hi,

You can try these options:
Option 1:
ChannelParameterBuilder filter = new ChannelParameterBuilder(false, false);
filter.AppendEquals(ChannelColumn.IdChannel, "1");
filter.AppendEquals(ChannelColumn.IdChannel, "2");

Option 2:
ChannelParameterBuilder filter = new ChannelParameterBuilder();
filter.AppendIn(ChannelColumn.IdChannel, "1,2");

Option 3:

 ChannelParameterBuilder filter = new ChannelParameterBuilder(false, false);
filter.AppendEquals(ChannelColumn.IdChannel, "1");
filter.Junction = "OR";
filter.AppendEquals(ChannelColumn.IdChannel, "2");

Execute filter:
TList<Channel> list = DataRepository.ChannelProvider.Find(filter.GetParameters());