Home | Forums | Contact | Search | Syndication  
 
 [login] [create account]   Saturday, November 16, 2024 
 
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 Client (Pre-7.2)
Forum to discuss using & developing the legacy SalesLogix Web Client (For versions 7.0 and earlier). View the code of conduct for posting guidelines.
Forums RSS Feed


 Back to Forum List | Back to SalesLogix Web Client (Pre-7.2) | New ThreadView:  Search:  
 Author  Thread: Changing Department Field on UserInfo table by SQL
Darren O'Donnell
Posts: 12
 
Changing Department Field on UserInfo table by SQLYour last visit to this thread was on 1/1/1970 12:00:00 AM
Posted: 05 Jan 07 8:36 AM
fiogf49gjkf0d
Hi All,

Firstly Happy New Year to All,

I written a stored Proc, to update, and keep updated, UserInfo & staff Contact/Address records, based upon our HR DB data, all is fine except the department field.

The SQL updates the field OK, and it displays OK in SQL, but within Administrator the field is not updated?

If I change the value in Administrator, the Department filed on the UserInfo Table gets updated?

Help please?? I have looked in other tables, but cannot find where the data is going.

We run reports at department level, with this discrepancy between data displayed in Administrator & what is in the SQL table, which one would take preference?

Regards

Darren

We are on SLX Ver 6.3 - Web Client
[Reply][Quote]
Timmus Agersea
Posts: 328
 
Re: Changing Department Field on UserInfo table by SQLYour last visit to this thread was on 1/1/1970 12:00:00 AM
Posted: 05 Jan 07 4:59 PM
fiogf49gjkf0d
SecCode is where you will find department info. Then reference SecRights to determine membership. Here is a sql statement that will list all users and the departments they are in:


SELECT
U.UserName, S.SecCodeDesc, SP.ProfileDescription
FROM
UserInfo U
INNER JOIN SecRights SR
ON SR.AccessID = U.UserID
INNER JOIN SecProfile SP
ON SP.ProfileID = SR.ProfileID
INNER JOIN SecCode S
ON S.SecCodeID = SR.SecCodeID
WHERE
S.SecCodeType = 'D'

The profile info is of little value when dealing with departments. I included it as you do care about the profile if you were researching team membership for example.

Hope this helps,

Timmus

[Reply][Quote]
Nick Hollis
Posts: 549
Top 10 forum poster: 549 posts
 
Re: Changing Department Field on UserInfo table by SQLYour last visit to this thread was on 1/1/1970 12:00:00 AM
Posted: 06 Jan 07 4:46 AM
fiogf49gjkf0d
h
[Reply][Quote]
Nick Hollis
Posts: 549
Top 10 forum poster: 549 posts
 
Re: Changing Department Field on UserInfo table by SQLYour last visit to this thread was on 1/1/1970 12:00:00 AM
Posted: 06 Jan 07 4:46 AM
fiogf49gjkf0d
Hi Darren,

How's it going? If your reports use just the text of the department field they should be fine even though in administrator they don't show up. In order for your routine to work completely pefectly is quite complex - you would have to get the seccodeid from the seccode table for that department, and create a secrights record for that user against that seccodeid. You can check these tables for the format they should have. You will also have to remove the secrights records for the department you are taking away for the user. Oh, and that assumes the new department already exists in Saleslogix! Make sense??
Cheers,
Nick
[Reply][Quote]
Darren O'Donnell
Posts: 12
 
Re: Changing Department Field on UserInfo table by SQLYour last visit to this thread was on 1/1/1970 12:00:00 AM
Posted: 08 Jan 07 4:28 AM
fiogf49gjkf0d
Cheers Guys,

I think I will take the wimpy route, and ensure our reports use the text value of the field.

Thanks for your assistance.

Regards

Darren
[Reply][Quote]
Timmus Agersea
Posts: 328
 
Re: Changing Department Field on UserInfo table by SQLYour last visit to this thread was on 1/1/1970 12:00:00 AM
Posted: 08 Jan 07 11:15 AM
fiogf49gjkf0d
Darren,

Please note that if you have written code that updates the userinfo.department column and you are not correctly managing the secrights and seccode records, you are "breaking the rules". If you need to use a simple text field for reporting I suggest using one of the Custom fields (Custom tab in the User Profile). If you opt to do so, you can find the data in the UserProfile table.

Timmus
[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 © 2024 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): 11/16/2024 1:15:59 PM