9/19/2026 10:11:08 PM
|
| |
| slxdeveloper.com Community Forums |
|
| |
|
|
The Forums on slxdeveloper.com are now retired. The forum archive will remain available for the time being. Thank you for your participation on slxdeveloper.com!
Forum to discuss writing script in Architect plugins for SalesLogix & general SalesLogix customization topics (for Windows client only). View the code of conduct for posting guidelines.
|
|
|
|
Lookup restrict values
Posted: 12 May 08 2:00 PM
|
I need to restrict a lookup on two conditions. Is there an easy way of scripting this? This is what I have so far and it meets one of the restrict conditions, now I need to restrict it by date also.
strStartDate = now
strTR_COURSEID = txtCourseId.Text
lueClassName.LookupRestrictField = "TR_COURSE:TR_COURSEID"
lueClassName.LookupRestrictOp = "="
lueClassName.LookupRestrictValue = strTR_COURSEID
Thanks, |
|
|
|
Re: Lookup restrict values
Posted: 14 May 08 7:26 AM
|
No.
And, if this is 7.2.1, I've encountered a bug with lookups and lookup restrictions - they are not honored on subsequent lookups (in the same instance) and if run against particularily large tables, the cause a freezing behavior. I have an open ticket with Sage for this now, but I've been too busy to follow up. I wound up re-coding a lookup by hand (new form that looks like a lookup) and from there I can restict on two vaules.
If your lookup restrictions are static, you might consider creating a view and building your lookup off the view.
Good luck!
|
|
|
|
Re: Lookup restrict values
Posted: 14 May 08 8:14 PM
|
you have to use the lookuprestrictop = "IN" and a sql select for the lookuprestrictvalue
In some cases it can really slow performance of the lookup |
|
|
|
You can
subscribe to receive a daily forum digest in your
user profile. View the site code
of conduct for posting guidelines.
 Forum RSS Feed - Subscribe to the forum RSS feed to keep on top of the latest forum activity!
|
|
|
|
|
|
|
|