Reporting on tags

[Philds]

Hi there, I've build a report showing new documents created last month and wanted to include a column in my table showing the tags associated with that document.

This worked out fine last month for documents created in May, example below from my PowerBI report:

However this month a new document wasn't showing any tags in my PowerBI report even though the document itself has tags assigned:

Looking back at the report I've built in Service Manager (instancename/admin/app/com.hornbill.servicemanager/reporting/reports), I've used the h_lib_documents.h_idx_tags field (labelled Index Tags) as this was the only field I could see in that table relevant to tags.

I've found there are many documents in this table without tags in h_idx_tags even though the document itself does have tags assigned in the Document Manager app. The fact that May's new docs had tags was a red herring as there's many docs without tags in that field going back years.

What am I missing about the h_idx_tags field and is there another table I should join to consistently get the tags of each document?

[Steve Giller]

I believe the actual links between Tags and Documents (and any other Entities) are stored in h_tag_links. so you'd need to join the document to it's tags via that.