Is there an issue with the SalesLogix Web Administrator version 8.0 in regards to adding users to Team Membership?

Question: In my database, it appears two users belonging to the same teams, have access to a different amount of records.

I think there may be an issue with the Team Membership.

Answer:

The
following users have problems:

select
a.PARENTSECCODEID, c.SECCODEDESC ParentTeam, a.childseccodeid, d.SECCODEDESC
ChildTeam, b.accessid, e.USERNAME, t.ACCESSID from SECCODEJOINS a left join
SECRIGHTS b on a.CHILDSECCODEID=b.SECCODEID

left
join (select accessid, seccodeid from secrights ) t on
a.PARENTSECCODEID=t.SECCODEID and b.ACCESSID=t.ACCESSID

left
join SECCODE c on a.PARENTSECCODEID=c.SECCODEID

left
join SECCODE d on a.CHILDSECCODEID=d.SECCODEID

left
join USERINFO e on b.ACCESSID=e.USERID

where
a.PARENTSECCODEID<>a.CHILDSECCODEID and t.ACCESSID is null

 

I
believe the issue is that if you manage teams in the SalesLogix version 8.0 web client Administration
area,  it is not correctly utilizing the nested team relationship to correctly
populate the SECRIGHTS table.

 In
the LAN administrator, when you add a team as a member of another team it adds
all users in that “child” team to the “parent” team. 
If you then add a new user to the “child” team it correctly updates
the “parent” team definition to include the user added to the
“child” team.

 The web client administration area is not doing
this.  If you add a user to a team that is a child team to a parent team,
the parent team is not getting the user added to the access rights of that
parent team. 

 

Submit a Comment

Your email address will not be published.

Subscribe To Our Newsletter

Join our mailing list to receive the latest Infor CRM (Saleslogix) and Creatio (bpm'online) news and product updates!

You have Successfully Subscribed!