How to query user by conditon same property has different values,

How to query user by conditon same property has different values, e.g. GivenName = 'a' or GivenName = 'b'

Menglong Lu

Vote:

I know how to query if the condition is GivenName = 'a' or SurName = 'a'.

But how can I query users by condition GivenName = 'a' or GivenName = 'b'? UserQuery can only set one Criterion on one property, currently I have to query many times then add them together. If I can query only one time, it save lot of time.

Does anybody have idea?

#63810

Nov 29, 2012 22:15

Magnus Rahl

Vote:

I think you should be able to use the StringInCriterion, something like:

var uq = new UserQuery();
uq.GivenName = new StringInCriterion();
uq.GivenName.Values.Add("a");
uq.GivenName.Values.Add("b");

I haven't tried this and I might not remember correctly how to use it. But something like it may work.

#63812

Nov 30, 2012 8:49

Menglong Lu

Vote:

Hi Magnus, thanks for you answer

What should be used is "Includes"

uq.GivenName.Includes = new StringInCriterion();
uq.GivenName.Includes.Values.Add("a");
uq.GivenName.Includes.Values.Add("b");

Thanks again.

#63864

Dec 03, 2012 11:28

Magnus Rahl

Vote:

Ah, yes of course, I forgot that level. I suppose it would have been obvious if I had actually tried to assign it :)

#63868

Dec 03, 2012 13:05