SQL Query question

Question

SQL Query question

fredericoagent (IS/IT--Management)

(OP)

23 Feb 10 08:08

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 (MIS) · Answer 1 · 2010-02-23 11:25:35

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 (IS/IT--Management) · Answer 2 · 2010-02-23 13:27:04

what am doing wrong

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

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

carp (MIS) · Answer 3 · 2010-02-23 13:59:49

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.

Come Join Us!

Posting Guidelines

SQL Query question