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!
|
|
Problem with remote user and Department
Posted: 07 May 08 11:38 AM
|
Hello everyone,
I have a problem
I created a Form that has different functions depending on which department or group the logan user belongs.
I do this validation on a global variable based on a query from seccodejoin and seccode tables.
This works correctly via lan(SalesLogix Client), but testing in remote client, I realized that seccodejoin table never synchronize its data, for this reason the global variable is not loaded and validation does not work.
Maybe someone has an idea what's going on and how I can resolve it.
Thank you for your help.
Patricia |
|
|
|
Re: Problem with remote user and Department
Posted: 07 May 08 12:15 PM
|
If your users have their correct departments in their SLX profiles I might get the userid with
Application.BasicFunctions.CurrentUserID and use the ID to look up the department in userinfo.department
|
|
|
|
Re: Problem with remote user and Department
Posted: 07 May 08 1:01 PM
|
Thaks Dan
That you say is rigth, but my problem is when I working with groups. Group user information is not store in userinfo table. I do the Following
Function IsUserFrom(strDptoTeam,strUID,strTipo)
dim str,sql
sql = "select parentseccodeid from SECCODEJOIN sj where childseccodeid = '"&Application.Users.Item(strUID).DefaultSecCodeID&"' and parentseccodeid <> childseccodeid and seccodetype in ('D','G')"
sql = "select seccodeid from seccode where seccodeid in("&sql&")"
sql = "select parentseccodeid from SECCODEJOIN where childseccodeid In ("&sql&") "
IsUserFrom = Nregistros("seccode","seccodeid in("&sql&") and seccodedesc = '" &strDptoTeam & "' and seccodetype = '"&strTipo&"'")>0
end Function
Where strTipo is 'D' or 'G' to identify if is department or group.
My problem is how to know what group user belongs in remote clients because seccodejoins don`t sync data
|
|
|
| |
| |
| |
|
Re: Problem with remote user and Department
Posted: 19 Sep 08 11:45 AM
|
| Is it possible to determine whether the user is a "direct" member (i.e. whether he was added to the team as an individual rather than via a sub-team) without using SECCODEJOINS? |
|
|
|
Re: Problem with remote user and Department
Posted: 20 Sep 08 8:06 AM
|
Nope....
Only the (wg)Admin app uses SECCODEJOINS. It's never used anywhere else.. including the SalesLogix Windows, Mobile or Web Client. They all use the "flattened" SECRIGHTS. |
|
|
| |
|