Database mapping of Repository to Run table
I'm having trouble working out the relationship between the Repository table and the Run table in the project databases. There must at least be an indirect relationship between the two, since Repository stores things like the Results.xml for an automated test run.
Can anyone help me out?
Edit: and yes, I've tried the QC database reference, no luck so far there either. [img]/images/graemlins/wink.gif[/img]
Re: Database mapping of Repository to Run table
I've been scratching my head all day with this, but the answer was right in front of me.
So fyi for the rest of you:
I was trying to work out the relationship between those two tables so I could locate the Results.xml for a given automated test run.
RN_PATH in the Run table maps to RP_NAME for one row in Repository. Then combine RP_PARENT_PATH and RP_PATH_ID (and maybe a / on the end) from that row and search in the same table for rows that match that. This gives you a list of files for that automated test run, including the Results.xml.