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

[somethingblue]

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.