Darren Rose Posted August 1, 2018 Share Posted August 1, 2018 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 More sharing options...
AlexTumber Posted August 1, 2018 Share Posted August 1, 2018 @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 1 Link to comment Share on other sites More sharing options...
Darren Rose Posted August 1, 2018 Author Share Posted August 1, 2018 thanks, @alextumber It was the links table I was missing 1 Link to comment Share on other sites More sharing options...
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