Highlighted
Absent Member.. Absent Member..
Absent Member..
496 views

Project List / Sub-Item

Jump to solution

Hello

 

I have several Root Items in the Project List (BG_PROJECT)

 

With Bug_Fields("BG_PROJECT").Value can i found out what kind of value was chosen in a Defect.

 

How can I found out which Root Item is involved ?

 

 

BG_PROJECT

-RED(ROOT)

- -Project A

- -Project B

-BLUE(ROOT)

-- Project C

 

-> I would like to know, that Project A is Part of RED(ROOT)

 

regards

 

Emanuel

0 Likes
1 Solution

Accepted Solutions
Highlighted
Absent Member.. Absent Member..
Absent Member..

Re: Project List / Sub-Item

Jump to solution

This would be a possible solution:

 

Dim TD
Dim TDCmd

Set TD = TDConnection
 Set TDCmd = TD.Command


TDCmdText =  "select ls_name from lists where ls_Id = (SELECT ls_father_Id FROM LISTS where ls_name = (select bg_project from bug where bg_bug_id = " & Bug_Fields("BG_BUG_ID").Value  &  "))"

 

TDCmd.CommandText = TDCmdText

 

Set RS = TDCmd.execute

RS.first
RootProject =  RS.FieldValue(0)


MsgBox "from Sql: " &  RootProject

 

regards Emanuel

View solution in original post

0 Likes
1 Reply
Highlighted
Absent Member.. Absent Member..
Absent Member..

Re: Project List / Sub-Item

Jump to solution

This would be a possible solution:

 

Dim TD
Dim TDCmd

Set TD = TDConnection
 Set TDCmd = TD.Command


TDCmdText =  "select ls_name from lists where ls_Id = (SELECT ls_father_Id FROM LISTS where ls_name = (select bg_project from bug where bg_bug_id = " & Bug_Fields("BG_BUG_ID").Value  &  "))"

 

TDCmd.CommandText = TDCmdText

 

Set RS = TDCmd.execute

RS.first
RootProject =  RS.FieldValue(0)


MsgBox "from Sql: " &  RootProject

 

regards Emanuel

View solution in original post

0 Likes
The opinions expressed above are the personal opinions of the authors, not of Micro Focus. By using this site, you accept the Terms of Use and Rules of Participation. Certain versions of content ("Material") accessible here may contain branding from Hewlett-Packard Company (now HP Inc.) and Hewlett Packard Enterprise Company. As of September 1, 2017, the Material is now offered by Micro Focus, a separately owned and operated company. Any reference to the HP and Hewlett Packard Enterprise/HPE marks is historical in nature, and the HP and Hewlett Packard Enterprise/HPE marks are the property of their respective owners.