How do I restrict a lookup with an "or" condition?

[mlaspina]

Did you get it working?

[madlink]

No I could not.

I even tried to use another type of field (like Int32) so that the query wouldn't be set to Upper case but that didn't work either

Any ideas?

Regards

[mlaspina]

Looks like the behavior of the control changed in version 8.  I'll let you know what kind of workaround ro resolution we come up with.

[stubarev-d]

Any news on this problem?

[zinchenko-a]

It's very important thread, because since slx 8.0 there is no way to use lookup control properly. Please review the control, add "Or" and "In" conditions ("In" condition with subquery support).

[alex.cottner]

I was on a support call with Kelly at Swiftpage just now and she mentioned this thread. I already had to figure out how to do this in 8.0 so I thought I would save you the trouble. You can easily inject into the SeedProperty value. See example code below, this in a C# code snippet load action.

AssignedTo.SeedProperty = "User.UserInfo.Department like '%Tech Sup%' and User.Enabled eq true or OwnerDescription";
AssignedTo.SeedValue = "Everyone";