[Typo3] how to display access-groupname after menuitem?

[Peter Klein]

"Steffen Matzke" <stema at web.de> skrev i en meddelelse 
news:mailman.1.1124349581.26515.typo3-english at lists.netfielders.de...
> hello group,
>
> i want to display the name of the usergroup that have access to a 
> menu-item behind this corresponding menuitem in the front-end. So a user, 
> who has all access rights, is able to get an overview of the set access 
> rights in the frontend.
>
> this is my current solution, which only displays the usergroup-number:
>
> page.10.marks.V_MENU.2.NO.after {
>        field = fe_group
>        wrap = <div style="font-size: 9px; color: #666666; font-family: 
> Arial, Helvetica, sans-serif; display: inline; margin-left: 3px;">|</div>
>        }
>
> how can i display the usergroup name. is this join possible?
>

Hi Steffen. You can do a lookup in the fe_groups table, using the RECORDS 
object.

Here's an example:

-- cut --
temp.fe_groupName = RECORDS
temp.fe_groupName {
  source.field = fe_group
  tables = fe_groups
  conf.fe_groups = TEXT
  conf.fe_groups.field = title
}

page.123 < temp.fe_groupName
-- cut --

-- 
Peter Klein/Umloud Untd