Compute short text value base upon function user is a member of

[jsummers]

Has anyone used the function "user is a member of" as a coupted field. What I'm trying to do is automatically assign the department name to the field based upon the function user is a member of adgroupabc then department name is ABC or user is a member of adgroupcde the department name is CDE.

My thought was

Computation Values

if user is a member of abc = abc

[tketz]

Hi Joe,

you have some more information about your User and Group Configuration?

We also displayed the department behind the assigned user field.

Our solution:

- department filed = shorttext

- trigger setLDAPdepartment (every time the user changed)

- setLDAPdepartement asked the ldap for the department which is stored in the LDAP (AD) and set it in the department field

With the deparment you can do some nice reports e.g. open Defects sorted by departments.

Requirement is that you use ldap user!

update:

If you don't use LDAP, you can also make little script for that:

- check in which group the assigned user is stored (adgroupabc)

- use the letters after adgroup an set it to the department field

[jsummers]

We are using LDAP, I'll look in to this option as it should be some what like the Incident Ticket solution system that pulls the user's department and supervisor information.