QC Query for finding field names in DEFECT page.

  • Questions
  • QC Query for finding field names in DEFECT page.
Tags:
Question ID: 104416
1
0

hi All,

I need to knowthe list of user defined fields for all the active projects in QC from the data base.

Can any one let me know the query or the way to query the database?

thanks in advance.

Marked as spam
Posted by (Questions: 1, Answers: 0)
Asked on November 28, 2011 3:43 am
5 views
Answers (1)
0
Private answer

This query will get you the answer, mostly. You'll have to do this in each project db. Beware,you can't tell which fields are displayed to the user on the forms, because that is handled in workflow, not stored in the db.

> SELECT SF_COLUMN_NAME,SF_USER_LABEL
>
> FROM
>
>
> SYSTEM_FIELD
>
> where
>
> SF_COLUMN_NAME
>
>
> like
>
> '%_USER_[0-9][0-9]'
>
>
> and
>
> SF_USER_LABEL is not null

![alt text][1]

[1]: /upfiles/2011-11-29_1507.png

Marked as spam
Posted by (Questions: 6, Answers: 167)
Answered on November 29, 2011 2:50 pm