1
Automation Interface, Add-Ins and Tools / Re: Requirements Export to Excel CSV
« on: January 19, 2005, 06:38:45 am »
Thank you very much for answering. Your recommendation was of great use for us. My collegue managed to export all data to Excel we were looking for. He used the following statement:
SELECT q_object.PackageName, q_object.Object_Type, q_object.Name, t_objectrequires.Requirement, t_objectrequires.Status, t_objectrequires.Priority, t_objectrequires.Difficulty, t_objectrequires.Stability, q_object.Note, t_objectrequires.Notes, t_objectrequires.LastUpdate, q_object.Stereotype, t_objectrequires.ReqID, q_object.Object_ID, t_objectrequires.Object_ID
FROM q_object q_object, t_objectrequires t_objectrequires
WHERE q_object.Object_ID = t_objectrequires.Object_ID
SELECT q_object.PackageName, q_object.Object_Type, q_object.Name, t_objectrequires.Requirement, t_objectrequires.Status, t_objectrequires.Priority, t_objectrequires.Difficulty, t_objectrequires.Stability, q_object.Note, t_objectrequires.Notes, t_objectrequires.LastUpdate, q_object.Stereotype, t_objectrequires.ReqID, q_object.Object_ID, t_objectrequires.Object_ID
FROM q_object q_object, t_objectrequires t_objectrequires
WHERE q_object.Object_ID = t_objectrequires.Object_ID