We are trying to integrate ALM to Servicenow using Tasktop. Since we only have one project in Servicenow, but multiple projects in ALM, we were told we needed to add a field to the ALM defect with the project name. I think I am overthinking this. Is there an easy way to do this (as it is displayed in the project itself, along the top of the ALM window)...?
Answer by jefptman · Apr 30, 2016 at 10:00 PM
There is a field that is setup as a dropdown list labeled “project”.
This dropdown list however is blank by default in Customization --> Project Lists
you would have to manually add your projects to the list then you could go through all the defects and select the correct project and any new projects would need to be manually added to this list.
The other option would be to add a custom field and then use the workflow to pull the project name from the TDConnection object
in Project customization you would need to go to project entities, click on Defects, and add a user defined field (make of note of the database column assigned (ex BG_USER_01).
Then you could go under workflow and add the following
under Defects Module Script --> Bug_New add the following
Sub Bug_New On Error Resume Next Dim bugProject bugProject = TDConnection.ProjectName Bug_Fields.Field("BG_USER_01").Value = bugProject On Error GoTo 0 End Sub
Under Defects Module Script --> Bug_MoveTo add the following
Sub Bug_MoveTo On Error Resume Next Dim bugProject bugProject = TDConnection.ProjectName If Bug_Fields.Field("BG_USER_01") = "" Then Bug_Fields.Field("BG_USER_01").Value = bugProject End If On Error GoTo 0 End Sub
Now whenever you open a new bug the workflow will automatically add the project name to the Defect and anytime you move to an existing Defect it will check the field and add the project name if needed.
Validate the drop down values 1 Answer