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

volume_up

A critical vulnerability was discovered in React Server Components (Next.js). Our systems remain protected but we advise to update packages to newest version. Learn More.

Home / Forums / Legacy forums / Episerver Community /

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

Vote:

expand_less 0 expand_more

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:

expand_less 0 expand_more

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

Vote:

expand_less 0 expand_more

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:

expand_less 0 expand_more

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

error This thread is locked and should be used for reference only. Please use the Legacy add-ons forum to open new discussions.