Forum Discussion

newbie2000's avatar
newbie2000
New Contributor
3 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...
GUI Client
Reviews
  • melgage's avatar
    melgage
    3 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).

     

newbie2000's avatar
newbie2000
New Contributor

Hi Mel,

 

Thanks for your response. Currently the data I'm working with is just a set of XML files dumped from the SQL database, so I'm not sure how I'd go about accessing the Views. Is this something I'd have to reach out to my DB administrator for?

 

Thanks

melgage's avatar
melgage
Staff
3 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).