Home | Forums | Contact | Search | Syndication  
 
 [login] [create account]   Saturday, August 16, 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: lookup to userinfo with filter
chez
Posts: 44
 
lookup to userinfo with filterYour last visit to this thread was on 1/1/1970 12:00:00 AM
Posted: 07 Nov 08 8:05 AM
Hi
Need to get userid, filter by title,Could anyone solve this prob'?

Created a child property under account linking regionalmangerid M:1 userinfo.userid called PrimaryCSR
Added new lookup on insert account screen
with Properties:
Databindings - PrimaryCSR map to LookupResultValue
Lookup Entity Name userinfo
Lookup prefilter - propertyname = title , condoperator = equalto, filtervalue = CSR
Lookup Properties - added Username, department,region

Can select person but doesn't save anything to account under regionalmanagerid.!

if use regionalmanager (property already set up by slx) using entity user brings back userid, but how do i then filter by userinfo.title?

Got little knowledge of 75 so far, so please guide me..
Cheers
Chez
[Reply][Quote]
Nick Hollis
Posts: 549
Top 10 forum poster: 549 posts
 
Re: lookup to userinfo with filterYour last visit to this thread was on 1/1/1970 12:00:00 AM
Posted: 07 Nov 08 8:32 AM
Hi Chez,

Is PrimaryCSR a relationship property? And it is it related to the User entity? And is your lookup set to object binding? Im guessing the last one is true as RegionalManager binds. PrimaryCSR needs to be a relationship (object) property and related to User. If PrimaryCSR is just the field where you stroe the physical Id of the user this will not work (in 7.2 anyway).

Thanks,
Nick
[Reply][Quote]
chez
Posts: 44
 
Re: lookup to userinfo with filterYour last visit to this thread was on 1/1/1970 12:00:00 AM
Posted: 07 Nov 08 8:47 AM
pretty sure PrimaryCSR is a relationship
created by going to child property under account then mapping RegionalManagerID M:1 with Userinfo.Userid
(and now shows under relationships Account.PrimaryCSR M:1 User Info , - don't need to do anything else to make it relationship do i?)

lookup binding mode = object

How do i link PrimaryCSR to user?
if use RegionalManager which already linked to user, how add filter to userinfo.Title?
Thanks
[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): 8/16/2025 1:38:25 AM