Ann Posted June 8, 2020 Posted June 8, 2020 Hi Please would it be possible to help? I am have created a report, however I am unable to add a column to show the resource's name or only projects with a tag associated to them of 'Test'. Please would it be possible to help with which table and column I would need to add in order to obtain these? Thank you. Kind Regards Ann
AlexTumber Posted June 10, 2020 Posted June 10, 2020 @Ann thanks for your post. In the Project Resources table, we only hold the resource type (currently only resourceType.person) as well as the primary key (user id). We have always planned to add additional resource types to Project Manager in the future, other than people. You will need to join the project resources table with h_sys_accounts in order to be able to get the resource's name. In terms of tags, the linking keys are all stored in h_tag_links under the tag group urn:tagGroup:projects. Hopefully when we add some much needed in app reporting to Project Manager you won't need to create a technical report to get this information. It will be selectable in an easy and intuitive interface. Alex
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now