We’ve just implemented the Skills attribute for our resources and wanted to start doing some reporting. I’ve been digging through the documentation on the Success Center and while there is a table where the work multi-select fields (MULTI_ATTRIBUTE), I can’t seem to find where the equivalent table exists for Resources. Any ideas? We are looking to add the Skills to the Resource Portfolio Dashboard.
Solved
Equivalent to Multi_Attributes table for Resources
+2Best answer by pamela.sargent
If you have the ability to query your database, everything you need to know about structures or fields can be found by the following two queries, including what table attributes can be found in. In the example here I have them focused on the Resource primary structure.
SELECT * FROM [ip].[structure_info] i where [prim_structure] = '$Res'
SELECT * FROM [ip].[field_info] i where [prim_structure] = '$Res'
Laurent is correct that the Criteria table is what stores the skill information.
select * from ip.criteria t where t.structure_name = ‘Skill’
You’ll then have to join this with the description table to be able to find the textual name.
This topic has been closed for replies.
+1Hello
I think the CRITERIA table is what you’re looking for. It stores the resources’ atributes, including the multi select data with primary indicator, efficiency data and place order.
+6If you have the ability to query your database, everything you need to know about structures or fields can be found by the following two queries, including what table attributes can be found in. In the example here I have them focused on the Resource primary structure.
SELECT * FROM [ip].[structure_info] i where [prim_structure] = '$Res'
SELECT * FROM [ip].[field_info] i where [prim_structure] = '$Res'
Laurent is correct that the Criteria table is what stores the skill information.
select * from ip.criteria t where t.structure_name = ‘Skill’
You’ll then have to join this with the description table to be able to find the textual name.
+2Thanks to Laurent and Pam for the info. I’m learning a lot!
Planview Customer Community
Already have an account? Login
Planview Customer Community
No account yet? Create an account
Login with SSO
Login with Planview Adminor
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
All Data Subject Access Requests (DSARs), and requests of “Do Not Sell My Personal Information” according to the CCPA, must be submitted through the Planview DSAR portal located here
Planview has appointed a Data Privacy Officer (DPO) to be responsible for overseeing our Privacy Management Program and related privacy compliance measures. DPO can be contacted at privacy@planview.com
Planview has appointed a Data Privacy Officer (DPO) to be responsible for overseeing our Privacy Management Program and related privacy compliance measures. DPO can be contacted at privacy@planview.com