I'm stuck with this, and I haven't seen any examples of how to do this. Here is what I want:

 "Where Status = 'A' and Priority in (1, 2, 3, 4, 5)".

Here is my criteria:

CriteriaOperator co = CriteriaOperator.Parse("Status = ? AND Priority in (?)", "A", new int[ { 1, 2, 3, 4, 5 }");

the resultant co.ToString() on this is: [Status] = 'A' And [Priority] In ('System.Int32[') instead of the expected:

"[Status] = 'A' And [Priority] in (1, 2, 3, 4, 5)"

Creating this criteria manually using the InOperator("Priority", new int[ {1, 2, 3, 4, 5}); does produce the correct result. It seems as though the CriteriaOperator.Parse chooses to ignore the fact that the InOperator requires an ICollection type, and just does a .ToString() on the parameter instead.

Am I doing this wrong, or is this just impossible?

Josh Norris

hi,

do you found a solution? I have exactly the same problem.

Dominik

Hey guys

I have the same problem too and i'm waiting for someone to post a solution in my current post.I'll get back if ever i find a solution.

Thanks

Hi guys check out this thread. http://community.devexpress.com/forums/t/71682.aspx

thanks

I would recommend instead of Parse to do the following:

CriteriaOperator co = new GroupOperator(GroupOperatorType.And, new BinaryOperator("Status", "A", BinaryOperatorType.Equal), new InOperator("Priority", new int[ { 1, 2, 3, 4, 5 }));

Your Output will be: [Status] = 'A' And [Priority] In (1, 2, 3, 4, 5)