Connected to the database using excel (for reporting). Trying to get all user feedback (ratings and comments to the estimates). Found in what table is stored the rating, but I can't find where are the comments to the reviews from customers. Please help. Which database table stores the comments for evaluations

1 answer

0 vote

Hi,

When you say the "comments to the reviews"

One piece of advise is that your add-ons will show which tables they use if you go to System > Advanced > Plugin Data Storage.  Here are the tables listed in my instance for Structure:


    AO_8BAD1B_VIEW
    AO_8BAD1B_FOLDER
    AO_8BAD1B_PROPERTY
    AO_8BAD1B_STRUCTURE
    AO_8BAD1B_HISTORY_PROJECT
    AO_8BAD1B_PROCESS_STATE
    AO_8BAD1B_HISTORY_CHANGE
    AO_8BAD1B_NODE_SIGNS
    AO_8BAD1B_STRUCTURE_TO_VIEW
    AO_8BAD1B_ROW
    AO_8BAD1B_ITEM_EVENTS
    AO_8BAD1B_SYNC_EVENT
    AO_8BAD1B_VIEW_TO_STRUCTURE
    AO_8BAD1B_SYNC_AUDIT_RECORD
    AO_8BAD1B_HISTORY_ISSUE
    AO_8BAD1B_ORDERING
    AO_8BAD1B_BOOTSTRAP
    AO_8BAD1B_FAVORITES
    AO_8BAD1B_PERSPECTIVE
    AO_8BAD1B_SYNC_INSTANCE
    AO_8BAD1B_HISTORY_ENTRY
    AO_8BAD1B_STRUCTURE_PROPERTY
    AO_8BAD1B_STATISTICS
    AO_8BAD1B_S_ITEM_PROPERTY
    AO_8BAD1B_FOREST_CHANGE
    AO_8BAD1B_GENERATOR
    AO_8BAD1B_ISSUE_INDEX
    AO_8BAD1B_ITEM_TYPE
    AO_8BAD1B_FOREST

If you're unable to find the comment you're looking for take a look in the jiraaction table.  If you do find the comments there you'll need to join it with the jiraissue table to find the issue it came from.  The Database schema document has more information on the layout of the Jira tables.

Cheers,

Branden

unfortunately, jiraaction keeps a history of correspondence problems. A comment to the assessment is stored in a separate field of "Quality customer service" and for some reason the grading scale is stored in the customfieldvalue table, but the comments somewhere.

Suggest an answer

Log in or Sign up to answer
How to earn badges on the Atlassian Community

How to earn badges on the Atlassian Community

Badges are a great way to show off community activity, whether you’re a newbie or a Champion.

Learn more
Community showcase
Published Jul 10, 2018 in Marketplace Apps

If you’re an Atlassian app developer, you’ll want to know about Atlas Camp!

This September 6-7, hundreds of Atlassian App developers will flock to Barcelona Spain to build skills, discover product roadmaps, meet face-to-face with the Atlassian team, and learn how to extend t...

183 views 0 4
Read article

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