Developer forum

Forum » Development » Where to find UserGroupName?

Where to find UserGroupName?

E-mail notifications

Reply
Posted on 30/06/2010 17:16:28
Im trying to write all the names of my usergroups in the frontend via the datalist module. I have the usergroup ID from the table AccessUser - but I can't find the names connected to the ID's. In wich table are they stored?

The UserGroupId I find looks like this: @1271@

Hope you can help.

/Rune



Replies

 
Nicolai Høeg Pedersen
Posted on 30/06/2010 17:26:41
Reply
Same table...

AccessUserType=2 or 11 are groups. So the @123@ you find is the ID of the group and that ID is in the AccessUserID.
 
Posted on 01/07/2010 09:11:20
Reply
Hmm, not sure we are talking about the same thing then.

What i need is the actual name - ie a group named "MG50".

The AccessUserType outputs "11" or "15", but what is this, or the output "@123@" related to, to output "MG50"?

The usergroup word "MG50" must exist in the DB somewhere, right?

Makes sense?

/Rune
 
Posted on 01/07/2010 10:04:34
Reply
This post has been marked as an answer

Opening the table AccessType will show that 11 and 15 corresponds to accessuser groups (rather than persons).

So, if you have a group named "MG50", this name will be found in the column AcessUserUserName of table AccessUser.

The "@123@" value of the AccessUserGroups tells which groups a user (person) is related to. The value "123" corresponds the AccessUserID of the group. Multiple groups will simply be listet like "@123@@456@".

Bottom line: Yes, the usergroup "MG50" is in table AccessUser (like NP stated), and the value is found in column AccessUserUserName.


Regards /Snedker

Votes for this answer: 2
 
Posted on 02/07/2010 13:10:55
Reply
Got it... Finally!

Thanks a lot!

/Rune

 

You must be logged in to post in the forum