Home | Forums | Contact | Search | Syndication  
 
 [login] [create account]   Saturday, July 5, 2025 
 
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!
 Web Forums - SalesLogix Web Platform & Application Architect
Forum to discuss the use of the SalesLogix Web Platform, Client and Customer Portals, and the Application Architect (For version 7.2 and higher only). View the code of conduct for posting guidelines.
Forums RSS Feed


 Back to Forum List | Back to SalesLogix Web Platform & Application Architect | New ThreadView:  Search:  
 Author  Thread: Multiple LookupPreFilters on same PropertyName
Doug Evenhouse
Posts: 66
 
Multiple LookupPreFilters on same PropertyNameYour last visit to this thread was on 1/1/1970 12:00:00 AM
Posted: 28 Jul 09 11:52 AM
We have a lookup on the Competitor entity wherein we want to limit the results to just those competitors that are local to the logged-in-user or national. Our approach is to add LookupPreFilter objects to the LookupControl's collection of LookupPreFilters. The problem we need help resolving is that LookupPreFilters appear to be mutually exclusive such that if you add more than one prefilter for the same property it will apply them all as ANDed, like this: Locality="3066" AND Locality="NATL" - since no Competitors have both values (and never could) the lookup returns no results.

Is there a way to apply an "OR" condition to the prefilters? There is a property on the LookupPreFilter object named CondOperator but we can't find documentation on what that property does or the values it accepts.

Does anyone know how to handle this?

Thanks,
Doug

[Reply][Quote]
Raul A. Chavez
Posts: 1300
Top 10 forum poster: 1300 posts
 
Re: Multiple LookupPreFilters on same PropertyNameYour last visit to this thread was on 1/1/1970 12:00:00 AM
Posted: 28 Jul 09 11:55 AM
No way to apply OR conditions (or to use an IN clause).
[Reply][Quote]
Doug Evenhouse
Posts: 66
 
Re: Multiple LookupPreFilters on same PropertyNameYour last visit to this thread was on 1/1/1970 12:00:00 AM
Posted: 28 Jul 09 1:01 PM
Hmmm. I was afraid of that.

OK - now to find a workaround! Thanks for your help.

-Doug
[Reply][Quote]
Doug Evenhouse
Posts: 66
 
Re: Multiple LookupPreFilters on same PropertyNameYour last visit to this thread was on 1/1/1970 12:00:00 AM
Posted: 28 Jul 09 1:18 PM
Hmmm. I was afraid of that.

OK - now to find a workaround! Thanks for your help.

-Doug
[Reply][Quote]
Raul A. Chavez
Posts: 1300
Top 10 forum poster: 1300 posts
 
Re: Multiple LookupPreFilters on same PropertyNameYour last visit to this thread was on 1/1/1970 12:00:00 AM
Posted: 28 Jul 09 1:46 PM
Do let me know if you find a work around for it!
[Reply][Quote]
 Page 1 of 1 
  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!
 

 
 slxdeveloper.com is brought to you courtesy of Ryan Farley & Customer FX Corporation.
 This site, and all contents herein, are Copyright © 2025 Customer FX Corporation. The information and opinions expressed here are not endorsed by Sage Software.

code of conduct | Subscribe to the slxdeveloper.com Latest Article RSS feed
   
 
page cache (param): 7/5/2025 10:59:23 AM