

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
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
Accepted Solutions


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
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


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
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