Forum Discussion

newbie2000's avatar
New Contributor
2 years ago

Can you map phaseId from database to Phase State

I'm currently working with XML files containing dumps of the database. One of the things I want to do is link Reviews with their phase state. The ReviewData table has an attribute called phaseId, and...
  • melgage's avatar
    2 years ago

    I'm not sure what SQL version you are using, or the process you're using to grab your XML dump, but from MySQL using the Workbench to grab the data, I can export it and have Views in the export by default. We can see the phase view show in my export list. A table contains data, a view is just a SELECT statement which has been saved in the database (more or less, depending on your database).