It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

Structure DB plugins

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 votes
Branden McElveen Atlassian Team Oct 13, 2017

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
This widget could not be displayed.
This widget could not be displayed.
Community showcase
Published in Marketplace Apps & Integrations

Webinar alert! An IT Admin's Guide to Securing Collaboration at Scale

Hello, Atlassian Community! My name is Dave Meyer and I'm a Principal Product Manager at Atlassian. I wanted to give this community a heads up about an upcoming Webinar that might be of interest...

174 views 2 7
Read article

Community Events

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

Find an event

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

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you