Tag Reporting

[Phil A]

Is it possible to create a report to see when a tag was added to an incident? I have created a database view to join label_entry and incident table and I can report on when the tag was created but I need to know when a particular tag was added to an incident? Thanks

[kevinlenienweav]

Hi Phil,

So the tables in play here are label which contains the definition of the tag, label_entry which contains the individual instances of a tag and the incident table in your case.

If you have joined label_entry and incident already you should only need to filter on the particular label you want to look for.

Each label_entry record's creation time is when it was added to the particular incident.

Let me know if you have any more questions.

-Kevin Leinenweaver

[Phil A]

Hi Kevin ,

Thanks for the quick reply. I'm not sure if my report is in correct but I can only get the report to output the date the label was created and not added to an individual incident. I've joined incident and label_entry tables ; the 'where clause' is inc_sys_id=tag_table_key. Ive added the 'created' field to the report but it shows the same date and time when I query a specific tag which is the date / time the tad was created rather than the date/time it was added to the incident (see attached), Any ideas?

[kevinlenienweav · Accepted solution]

So I see that you are using Label.Created, this is dot walking from the Label_entry table to the label table and getting it's created date, which is not what you are looking for.

If you instead add the field "Created(tag_sys_created_on)" you should get the data you are looking for.

See below for my screenshot after I created the same database view you have:

Take a look and let me know what you see.

-Kevin

[Phil A]

Thanks Kevin, all working, just need an ACL on the db view so user can access the report