Home

Does anyone know what database table houses Functional Teams in Agile PLM?

Answered

Looking to capture the Functional Team reported on the cover page for most entities in Agile PLM v9.3.3 but couldn’t seem to find Functional Teams captured anywhere within the database schema – would anyone know where this is?

Thanks very much in advance!

Agile User Asked on May 6, 2019 in Agile PLM (v9),   Product Lifecycle Analytics.
Add Comment
Cancel
2 Answer(s)
Best answer

The information for functional teams is in USER_GROUP – it is just another class (id=2000017166) under the User_Groups base class. The FUNC_TEAM attribute was added back in 9.3.2.0.
 The USER_GROUP table was added way back in 9.0.0.0, so it should be there, and Averify should call it out as missing if it is not there.

Cancel
Agile Angel Answered on May 7, 2019.

AndrewLGoldman

Thank you Kevin!  I will definitely investigate with IT and see what I can find

on May 7, 2019.
Cancel
Add Comment
Cancel

Hello Andrew

 Please check user_group table. Functional teams would be in a different subclass than the user_group/personal group. This is how it is in 936

 Hope this helps

– Raj

Cancel
Agile Angel Answered on May 6, 2019.

AndrewLGoldman

Huh – I wonder if the user_group table was added in a later release — for users, I think I only have AgileUser and Agile_USERS, sadly dont have a user_group table in 9.3.3 seemingly 🙁

on May 7, 2019.
Cancel
Add Comment
Cancel

Your Answer

By posting your answer, you agree to the privacy policy and terms of service.