SQL Query question

fredericoagent · Feb 23, 2010

Hi All,

I have a question regarding SQL queries I hope somebody can help me with.

I am trying to create a query in a software called HP quality center in order to extract requirements but need some help.

Under the requirements section we created folders with the name (Name test1 , Type FOLDER)

Under each folder we created set of requirements. Is there an easy way to extract all requirements where folder name = foldername1

---
Select REQ.RQ_USER_03,REQ.RQ_USER_03
FROM
REQ

No how to I say only select the requirements if they are in located in a folder named test1 ?

thanks

carp · Feb 23, 2010

This is just a guess:

Select REQ.RQ_USER_03,REQ.RQ_USER_03
FROM req
WHERE folder = 'test1';

This assumes a column called "folder"; you may need to change this to fit your actual situation (or give us more information about your table structure).

fredericoagent · Feb 23, 2010

what am doing wrong

http://tinypic.com/view.php?pic=2j0z512&s=6

carp · Feb 23, 2010

The error message is fairly clear - RQ_FATHER_ID is an integer datatype; you are trying to compare it to a character string that cannot be converted to an integer.

Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

SQL Query question

fredericoagent

IS-IT--Management

carp

MIS

fredericoagent

IS-IT--Management

carp

MIS

Similar threads

Part and Inventory Search

Sponsor