General Reporting - Which Table holds What data?

[Don Bisset]

I need to create a report on Assignment Groups, I'm trying to find the data table where Assignment Groups are defined. 

To that point is there look up - search to explore what tables hold what data.

Thanks Don

[Maik Skoddow]

Hi @Don Bisset 

table sys_user_group stores all user groups which also act as assignment groups

Kind regards
Maik

[Don Bisset]

Thanks Maik - much appreciated

[Maik Skoddow]

Hi @Don Bisset 

In case you think I was able to answer your question, I would be happy if you mark the appropriate response as "correct" so that the question will appear as resolved for other users who may have a similar question in the future.

If not, please tell me what you are still missing!

Many thanks & kind regards
Maik

[Hitoshi Ozawa]

As Maik replied, assignment group is in sys_user_group table.

Following steps can be used to find which table the field is associated with

1. Open list
2. Right click on the list header
3. Select "Configure" > "Dictionary"
   
4. Search on "Column label" = "Assignment Group"
   
5. Click on "Group" link. The name of the table appears as the value of Name.