What happens to the data when a user votes a Knowledge Base article as helpful?

Within JIRA Service Desk, when a user views an article they have the option to vote the article as helpful or not. I'm curious as to what happens to this data...? Does the helpfulness of an article change the order in which articles appear when a user inputs similar key words? (i.e. if an article has five helpful votes, does this appear higher in the list to one that only has three helpful votes?)

Is there a way you can view how many helpful votes an article has?

Appreciate there are a few questions here, but any help to understand this would be gratefully received smile

1 answer

Raised a Support Request with Atlassian in regards to the above questions. Answers were as follows:

  1. What happens to the data when someone votes the article helpful or not?
    1. They are stored into the database for reporting purposes. You can check out the Knowledge Base reports from the SD project's Reports menu.
  2. Does the helpfulness of an article change the order in which articles appear when a user inputs similar key words?
    1. No, this doesn't affect the Confluence pages themselves or the way they appear through search in the SD Customer Portal.
  3. Is there a way you can view how many helpful votes an article has?
    1. Yes, there is, but not through the GUI. You can run this SQL query in the db to find it out:

      SELECT sep.param_value as "Page Title", se.event_key as "Helpful / Not Helpful", count(se.event_key) as "Counts" FROM ao_0201f0_stats_event_param sep inner join ao_0201f0_stats_event se on sep.stats_event_id = se.id where sep.param_name = 'pageTitle' and se.event_key like '%helpful%' group by sep.param_value, se.event_key;

 

Suggest an answer

Log in or Join to answer
Community showcase
Sarah Schuster
Posted Jan 29, 2018 in Jira

What are common themes you've seen across successful & failed Jira Software implementations?

Hey everyone! My name is Sarah Schuster, and I'm a Customer Success Manager in Atlassian specializing in Jira Software Cloud. Over the next few weeks I will be posting discussion topics (8 total) to ...

2,760 views 11 18
Join discussion

Atlassian User Groups

Connect with like-minded Atlassian users at free events near you!

Find a group

Connect with like-minded Atlassian users at free events near you!

Find my local user group

Unfortunately there are no AUG chapters near you at the moment.

Start an AUG

You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs

Groups near you
Atlassian Team Tour

Join us on the Team Tour

We're bringing product updates and pro tips on teamwork to ten cities around the world.

Save your spot