Project List / Sub-Item

[ixtest]

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

[ixtest · Accepted 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