Jump to content

Reporting on Project TAGS


Darren Rose
 Share

Recommended Posts

Hi

I would like to report on the TAGS associated to a project. I've tried a few different ways this morning, but currently coming up short, so thought I'd reach out to the forum. 

I need to be able to do it as a report so that I can then use it in PowerBI.

Thanks

Darren 

Link to comment
Share on other sites

@Darren Rose great to hear you're making use of the new tags!

Tags are held in the db table h_tags. Note that this table holds all tags for your Hornbill instance so your 'WHERE' clause should be "h_tag_group = 'urn:tagGroup:projects'".

Links between tags and projects are then held in the db table h_tag_links. In this table you'll see the id of the tag, the tag group and the project that the tag is related to.

 

Alex

  • Like 1
Link to comment
Share on other sites

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 account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...