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!

Architect Forums - SalesLogix Scripting & Customization
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.

Forums RSS Feed

Back to Forum List | Back to SalesLogix Scripting & Customization | New Thread

View: Search:

Author

Thread: Customising Contacts data grid

Andrew Grandin
Posts: 272

Customising Contacts data grid Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 17 Sep 09 4:49 AM

Hi all, ive been experimenting with limiting what users can see what Contacts on an Account. At the moment i have it so the Contacts datagrid is filtered so a user can only see contacts they have created and no others. I have done this by creating a global join and adding a condition in the SQL of the datagrid so that:

Contact.Userinfo.Userid -- is equal to -- :userid (this gets the id of the user who is currently loged on.)

What i would like is to get the datagrid to filter so users can see contacts created by other users from their department (this being the department found in Administrator -> General -> Department) and no others.

I was naive enough to think that :department would work the same as :userid but no such luck.

Any ideas?

[Reply][Quote]

Raul A. Chavez
Posts: 1300

Re: Customising Contacts data grid Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 17 Sep 09 6:39 AM

First of all, Remove your Custom Join/Condition
Next, Join from the Contact table to the User Info utilizing the AcctMgrID (A Global Join is probably already available for this).
Then, add a Condition for the Department field out of the UserInfo table

On the Popup box for the Condition, set the Operator to "IN", click on the Use Valueas Literal, and type the following on the value box:
(SELECT DEPARTMENT FROM USERINFO WHERE USERID = :USERID)

The end result is embedding a Subquery into your Grid's conditions.

[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 \|

page cache (param): 8/29/2025 2:09:09 PM