HPE Software Products: Requirements Management Information and News
Share |

Enable to Change the Status of RequirementOpen in a New Window

 I mistakenly added an approver to the list of approvers. All the approved approvers approved the requirement P04-PRO-15 (ID 118) of the project RP3_GRA_RPA but the status did not pass to "for quality approval". I changed the list of approvers to remove the mistaken appleter (Marianne Brodeck) but the status has not changed.Is it possible to switch the status of this requirement to "for quality approval" so that the quality approver can approve it?

 

View or create a report to view releases tied to requirementsOpen in a New Window

Maybe we're using ALM incorrectly, but when we release a new version of our software, I go to Releases, then create a release, then create a scope item, then check the boxes next to the requirement that are part of that release.

I want a tabular report that shows requirement id with its release name.  I think the information I want is in the tables named req, req_releases, releases and qpm_scope_item but I cannot figure out how to write an SQL statement in the Analysis View that extracts the information correctly.

I've tried

SELECT rq_req_id, rq_req_name, sci_name, rel_name
FROM req, req_releases, releases, qpm_scope_item
where rq_req_id = rqrl_req_id
and rqrl_release_id = sci_id
and rel_id = sci_parent_id

as a test which works in a dummy project I set up, but not in the real project that we're using. 

Is there a way to get what I want from ALM?

 

 

 

Requirement Report mixed up in orderOpen in a New Window

Hi everyone,

We are using ALM (11.52) for our requirements and we are createing reports (Word) based on them.
The folder and requirements structure in ALM, is also what we need in our generated report. 
But the problem is, that the folders and requirements are mixed up within the same level.

I have checked all filters, both in the report and requirements view - nothing is selected.
The report checkbox for keeping hierarchy is checked.

Do you have any idea, why the order is different in the report than it is in the ALM Requirements view?

Thanks in advance
Philipp

Example like it is in ALM and the generated ReportExample like it is in ALM and the generated Report

 

 

 

Error requirements new field createOpen in a New Window

Hi,

 

I click new field button but i see error pop-up. But i can create new field on defect module.

 

Error code : 0x800413EC

 

Thanks a lot.

 

Cuneyt Cakir

 

 

Help me tweak a VBScript to link test cases to requirements?Open in a New Window

So we have a script working that automatically goes down the list of tests in Test Plan (you have to supply the folder path) and links every test to a requirement. The tests have a custom field called Req Ref ID, which we populate with the IDs of any requirements, and the requirements have a required field of the same name. The script simply checks the two fields, sees if there are any matches, and performs the linkage. The problem is: it crashes if it hits a test that has existing linkage. The solutions I could think of range from complicated to dangerous. The best option I can think of is to have it check whether a test has coverage or not, if no perform linkage, if yes wipe out existing coverage, then perform linkage. I'm not great at VBScript, though, and don't really know how to make it remove existing coverage. If anyone can help I'd greatly appreciate it... Here's the script:

'IN THE WORKFLOW SCRIPTS > PROJECT SCRIPTS > COMMON SCRIPT
'Use the following script to redirect this function to the module specific function:
Function ActionCanExecute(ActionName)
  'Use ActiveModule and ActiveDialogName to get
  'the current context.
  On Error Resume Next

  'Use the following script to redirect this function to the module specific function:
  Select Case ActiveModule

  '  Case "Defects"
  '    ActionCanExecute = Defects_ActionCanExecute(ActionName)
  '  Case "Test Lab"
  '    ActionCanExecute = TestLab_ActionCanExecute(ActionName)
    Case "Test Plan"

        If ActionName = "Link_T_to_Req" Then
          Call Link_T_to_Req()
        End If

    ' ActionCanExecute = TestPlan_ActionCanExecute(Link_TestP_to_Req)
   '   MSGBOX "IN TEST PLAN2"
     '  Case "Requirements"
  '    ActionCanExecute = Requirements_ActionCanExecute(ActionName)
  '  Case "Management"
  '    ActionCanExecute = Management_ActionCanExecute(ActionName)
  '  Case "Test Resources"
  '    ActionCanExecute = Resources_ActionCanExecute(ActionName)
  '  Case "Business Components"
  '    ActionCanExecute = Components_ActionCanExecute(ActionName)
  '  Case "Dashboard"
  '    ActionCanExecute = Analysis_ActionCanExecute(ActionName)
  '  Case "Business Models"
  '    ActionCanExecute = BusinessModels_ActionCanExecute(ActionName)
  '  Case "Test Runs"
  '    ActionCanExecute = TestRuns_ActionCanExecute(ActionName)
  End Select
  'ActionCanExecute = DefaultRes
  On Error GoTo 0
End Function



'IN THE WORKFLOW SCRIPTS > PROJECT SCRIPTS > TEST PLAN MODULE SCRIPT
Sub Link_T_to_Req()
   Dim strNessage
   strMessage =Inputbox("Enter the sub-root folder name: ","Input Required")

   If (strMessage <> "") AND   (strMessage <> " ") Then
  ' strNodeByPath = "Subject\" & "Test"         '  CAN REQUEST FOLDER NAME AS PARAMETER
       strNodeByPath = "Subject\Project EMEE\"  &   trim(strMessage)
        MsgBox   strNodeByPath

        Call MyTestCases(strNodeByPath)
           MsgBox "WE ARE DONE! "

   Else
       MsgBox " ** YOU DID NOT ENTER A FOLDER !! **"
   End if
End Sub


   Function MyTestCases(strNodeByPath)
        ' Variable for adding the coverage
    Dim reqID
    Dim TestID
    Dim coverable
    Dim reqF
    Dim Req
    Dim tdc
    Dim arrRefID
    Dim inti
    Dim TestF, testL

    Dim TestSource
    Dim testListReq
    Dim reqItem
     Dim myfilter
     Dim temp
     Dim temp1
     Dim temp2

     Dim TreeMgr, TestTree, TestFactory, TestList
      Dim TreeMg1r, TestTree1, TestFactory1
       Set tdc = TDConnection
    Set TreeMgr = tdc.treemanager

     'Specify the folder path in TestPlan, all the tests under that folder will be exported.
    Set TestTree = TreeMgr.NodeByPath(strNodeByPath)
    Set TestFactory = TestTree.TestFactory
    Set TestList = TestFactory.NewList("") 'Get a list of all from node.

      'Specify Array to contain all nodes of subject tree.
    Dim NodesList()
    ReDim Preserve NodesList(0)
    'Assign root node of subject tree as NodeByPath node.
    NodesList(0) = TestTree.Path

    Temp = NodesList(0)
    'Temp1 =  NodesList(1)
    '   MsgBox  " NodesList(0) = " & Temp

    'Gets subnodes and return list in array NodesList
    Call GetNodesList(TestTree, NodesList)

    Dim Row, Node, TestCase
    Row = 2
    For Each Node In NodesList

        Set TestTree1 = TreeMgr.NodeByPath(Node)
        Set TestFactory1 = TestTree1.TestFactory
        Set TestList1 = TestFactory1.NewList("") 'Get a list of all from node.

        'Iterate through all the tests.
        For Each TestCase In TestList1   'Loop through all the test cases

                temp = "    TS_TEST_ID= " & TestCase.Field("TS_TEST_ID")  & " TS_USER_11= " & TestCase.Field("TS_USER_11")
'''               MsgBox  temp

            ' ignore if any of the test case do not have Ref ID field
           If (TestCase.Field("TS_USER_11") <> "") AND (TestCase.Field("TS_USER_11") <> " ") AND (TestCase.Field("TS_USER_11") <> vbNull)  Then

               TestID = TestCase.Field("TS_TEST_ID")
               RefID = TestCase.Field("TS_USER_11")
               Temp1 = Replace(RefID , vbCrLf, ",")       ' remove carriage return
               Temp1 = Replace(Temp1 , vbLf, ",")         ' remove line feed
               Temp1 = Replace(Temp1 , vbCr, ",")         ' remove line feed
               Temp1 = Replace(Temp1 , ",,", ",")          ' remove double comas as result of removing line feed
               Temp1 = Replace(Temp1 , ", ,", ",")         'remove as result of removing line control chars
               Temp1 = Replace(Temp1 , ",,", ", ")          ' remove double comas as result of removing line feed
               Temp1 = Trim(Temp1)

               RefID = Temp1
              ' MsgBox RefID            ' New
               arrRefID = Split(RefID, ",", -1, 1)


               temp = "   UPPER BOUND OF ArrRefID = " &  UBound(arrRefID)
             '  Msgbox    temp

               inti = 0
               For inti = 0 To UBound(arrRefID)     'Loop through the individual ref number (ref1)
                  Temp =    "     init = " & inti & "  arrRefID(inti) = " & arrRefID(inti)
'''                  Msgbox    Temp


                  If ((arrRefID(inti) = "") or (arrRefID(inti) = " ") or (arrRefID(inti) = vbNull) or (arrRefID(inti) = vbNullChar) or (arrRefID(inti) = vbNullString)) Then    'Nothing to compare
'''                     MsgBox " NOTHING IN ARRAY VARIABLE   SKIP"

                  Else
                 'Connect to command object
                  Set com = tdc.Command
                  com.CommandText = "SELECT * FROM REQ WHERE RQ_USER_03 = '" & Trim(arrRefID(inti)) & "' "
'''                  MsgBox    com.CommandText
                  Set recset = com.Execute


                  'Validate the results
                   If recset.RecordCount > 1 Then
                       MsgBox "Duplicate Requirement Ref ID found under Req Module"
                      'If record found map against req
                   ElseIf recset.RecordCount = 1 Then
                       reqID = recset("RQ_REQ_ID")
                       temp2 =   "        FOUND ReqID= " &  reqID
'''                       MSGBOX temp2

                       Set reqF = tdc.ReqFactory
                       Set Req = reqF.Item(reqID)
                       Req.AddCoverage TestID, TDPOSITION_LAST
                   ElseIf recset.RecordCount = 0 Then
                       temp2 =  " Not Found " &   arrRefID(inti) & " in database "
'''                       MsgBox temp2
                   End If
                End If

                Next     'Loop through the individual ref number (ref1)

            Else  'No REF ID
            temp2 =  " No Req Ref ID for  Test.Field(TS_TEST_ID) = "   & Test.Field("TS_TEST_ID")
'''                MsgBox temp2

            End If

      Next    '  Loop TestCase In TestList
'''                MsgBox "No more TestCase in TestList"
    Next             ' Node In NodesList
         MsgBox "THE TRAVERSING THRU THE FOLDERS IS COMPLETE! "

    Set tdc = Nothing
    Set reqF = Nothing
    Set Req = Nothing
    Set TestFactory = Nothing
    Set TestList = Nothing
    Set TestFactory1 = Nothing
    Set TestList1 = Nothing
    Set recset = Nothing
    Set TestTree = Nothing
    Set TestTree1 = Nothing
    Set TreeMgr = Nothing

End Function



'Returns a NodesList array for all children of a given node of a tree.
'
'@param:    Node        Node in a Test  tree.
'
'@param:    NodesList   Array to store all children of a given node of a tree.
'
'@return:   No explicit return value.
Function GetNodesList(ByVal Node, ByRef NodesList)
    Dim i
    Dim Tmp
    'Run on all children nodes
    'MsgBox "  Function GetNodesList  Node = " & Node  & "  Node.Count = " &  Node.Count

    For i = 1 To Node.Count
        Dim NewUpper
        'Add more space to dynamic array
        NewUpper = UBound(NodesList) + 1
        ReDim Preserve NodesList(NewUpper)

        'Add node path to array
        NodesList(NewUpper) = Node.Child(i).Path

        'If current node has a child then get path on child nodes too.
        Tmp = " i = " & i & "    Node.Child(i).Count = " &  Node.Child(i).Count
        If Node.Child(i).Count >= 1 Then
           Tmp =   Node.Child(i)
     '      Msgbox "   Node.Child(i) = " & Tmp
            Call GetNodesList(Node.Child(i), NodesList)
        End If
    Next
End Function

 

 

How to move requirements to another folder automatically ?Open in a New Window

Hi all,

I have 3 folder in requirements module. One of them has the all requirements within. Every each requirements has a field which keeps information about folder that the requirement will be moved. I would like to move all the requirement to related folder automatically. 

For example;

Folder A -> 50 requirements

Folder B -> 0 requirement

Folder C -> 0 requirement

In Folder A, 20 requirements should be moved to Folder B, 30 requirements should be moved to Folder C. It will be specified by the special requirement field which should moved to which folder.

It can be SQL Procedure or action does not matter.

Thanks in advance.

 

You do not have the required permissions to execute this actionOpen in a New Window

Hello  Good Day All, 

In ALM 12.53 version Requirement module - when i change the status  for any of the requirement type am getting the below error- 

"You do not have the required permissions to execute this action . "

Its not allowing me to change even for the TD Admin , and for all other roles in project. 

I have changed status from Any to Any , also workflow  but still no clue for this . 

PLease any one have any idea suggest me . 

Thanks & Regards

ArJUN

 

 

 

Requiremen​t user template entities - not visible or updateable in Requiremen​t ModuleOpen in a New Window

Requiremen​t user template entities - not visible or updateable in Requiremen​t Module

Hi

A project was set up with RQ_User fields created and then requirements(2800) had been captured..

Later I decided to create a template project and copied the original project customisation as a basis.

I now manage all access permisions and entities etc through this template project (the original project now being linked to this)

- our Bug User _Template entities work just fine - 

I now have added some new Rq_ User_Template entities and updated all the linked projects.

the problem is:-

1/ the requirement user template entities - are not  visible in the Requirement details view at all 

2/ Two of the new entities are Project Lists - and the list items/values are not visible in any of the requirement module views 

3/ these new entities are not updateable in any of the requirement module views

4/ all the new User Template entities are visible in the Customize/Project Entities/Requirements/User Fields - so they have been rolled out to the project

5/ even with TDAdmin access - I cannot amend these fields

6/ the Template Project does have the original User Entities as RQ_User_01 - 10 as well

any suggestions please?

can I put some coding in the Workflow to make these accesible - if so please could you supply this

is it because I have a mixture of User Entities (created and populated in the original project) and new User Template Entities?

 

I will be grateful of some help please  - I have 10+ projects linked to this and don't want to hard code this in each project, and iof course, any new ones. Plus I cannot lose any history/audit trail on any of the existing projects - so I cannot recreate/copy all the original fields/entities as template fields.

hope that is as clear as mud

please email

Thanks

Helen

 

Requirements - Automatic mails after changing with history, comments and attachmentsOpen in a New Window

Hi,

if we changed somethink in an existing requirements and the "Assigned To" is filled in, automatic mails will send... all right!

But is it possible to script that the history, all comments and the actual attachments will send by default, too? 

I know, that you can send all these points by checking the checkboxes for manual sending, but what is the script settings to send also for automatic mails?

 

Thanks, BR.

 

make validation errors more visible when importing requirementsOpen in a New Window

Is it possible to make the validation errors more visible when importing from MS Excel? Currently the litle red highligh is not enough. Can you highlight the entire cell in yellow?

 

Display on Requirements Tree View/Grid View when a requirement is baselined or changed afterwardsOpen in a New Window

Need to visibly show via the Requirements Grid or Tree view when a requirement has been baselined or changed after being baselined.

 

Hide requirement fields (details) when creating a new requirement (project -specific)Open in a New Window

Is it possible to implement a new way of hiding fields from the Details menu when creating a requirement?

 

Create 'project-specific' user fields for a requirement entity for a project linked to templateOpen in a New Window

When you have created a project from  a template, the user fields created for that requirement entity get passed along to the project. However, if you have a requirement user field that should only apply to one project, adding that user field to the template, applies that field to all projects linked to the template. We need to be able to add user fields for an entity specific to an individual project even if that project is linked to a template.

 

Requirements hiearchy excel reportOpen in a New Window

I know someone on here must know this one. I'm trying to produce an excel spreadsheet in QC replicating the tree view. I understand somehow the RQ_ORDER_ID and RQ_PARENT_ID are related, but that's about it. Looking in the DB reference it talks about a self-join but I do not know how to generate a script for that. Right now, we are referencing off Path which is not correct. We are using MS SQL Server and QC 12.01. Any help is appreciated.

SELECT   REQ.RQ_USER_TEMPLATE_01 'DOORS ID',
 REQ.RQ_REQ_NAME 'Requirement.Name',
 REQ.RQ_USER_TEMPLATE_04 'Requirement.Threshold Platform Type'

FROM  REQ
order by rq_req_path asc

 

Creating a requirement using REST APIs in HP QC ALM database with C/C++ Code for a Linux(Debian) SysOpen in a New Window

Hi,


Can someone guide me whether is it possible to create a requirement in HP ALM QC database using REST APIs.?

Thanks for the help in advance.

Regards,
Giri01

 

Store History on Tree structure changeOpen in a New Window

Little background.  The team that is in charge of the Requirements has full access to that module except they can't delete requirements.

I have setup a Requirement Folder called Trash which allows them to cut/paste or drag/drop requirements they don't want into that folder.  I have then setup Data Hiding so only the Admins can see requirements in that Trash folder.

Works great, but we just found 3 requirements in the Trash that should not have been there and they want to know when and who put them there.  I looked and there is no history that shows this.

I think the field I need to enable History on is the RQ_FATHER_NAME but I can't enable History on that field.

Anyone have an Idea on how I can track in history when and who puts a requirement under the Trash folder?

I'm on ALM 12.01

Thanks,

Mike

 

Requirements coverage from Test LabOpen in a New Window

Hi, what is parameter I need to add to Site Admin -> Site configuration for Requirements coverage from Test Lab (not from Test Plan) ?

 

Requirement Module - Reset Req ID fieldOpen in a New Window

Hello

I need help.

If I upload requirements and found some error after the load (i.e. a few are wrong) and then I delete all of them, can I reset the req-id (auto generated) to start from beginning?

 

Custom Req Type IconOpen in a New Window

Am I able to load some additional Requirement Type Icons into ALM?

I have setup a Requirement Folder called Trash in each of my linked projects and have Data-Hiding enabled so whenever anyone "besides an admin" drags/drops requirements into that Trash folder they can no longer be seen by the users or show up in any of their reports.  This effectivly deletes the items for the user but I don't loose any requirements or History, and I am able to restore items if needed, again without loosing history.

Only problem is that people keep trying to delete/rename/mess with the Trash folder which is locked down but I'd like to update that to have a standard Recycle Bin icon so they stop trying to mess with it, but I don't see any way to upload a custom icon.  I'm also thinking about creating a new Requirement Type = Trash so I can more easily lock it down, but again, I'd like to have a good trash icon for it.

 

Is this possible?

Thanks,

Mike

 

Image display / viewing issue in Rich Text field of a RequirementOpen in a New Window

Hello,

   I am expriencing a similar issue as listed in the following post. Image (s) pasted in the “Rich Text” of a requirement are displayed to the “author” of the requirement but not to any other user, who accesses that same requirement. The message displayed is “This image does not exist”.

 Now, if any other user (different from the author), modifies that same requirement by pasting a few more image (s), he / she can only view them. But any other user including the Author, is not able to see those newly added images. The same message “This image does not exist” is displayed.

 Original Post : http://community.hpe.com/t5/Quality-Center-ALM-Practitioners/Requirement-quot-The-image-does-not-exist-quot/m-p/6850997/highlight/true#M96234

 Can you please help me with this issue? As we are heavily using the “Rich Text” a solution to this issue is extremely critical.

 So far, I have done the following analysis:

  1. Checked the Site Admin module for any specific settings. Also, checked various if I need to setup any parameters in “Site Configuration”
  2. Checked the Project setup for any specific setting.For the (1) and (2) did not find any find any leads
  3.   Also, checked the following tables :  

 SELECT * FROM CROS_REF where cr_entity='REQ' and cr_key_1=XXX order by CR_KEY_1

 SELECT * FROM AUDIT_LOG where AU_ENTITY_TYPE='REQ' and au_entity_id= XXX order by au_time

 SELECT * FROM SMART_REPOSITORY_LOGICAL_FILE SL,SMART_REPOSITORY_PHYSICAL_FILE SP

where SL.SRLF_PHYSICAL_ID=SP.SRPF_ID and SL.srlf_name like '%REQ_ XXX %'

order by SRLF_LAST_MODIFIED

                Where XXX = Req ID

 So essentially for every “image paste” action, an entry is made in the above tables. However, what I saw is the CRS_REF table is not getting updated for the majority of them.

 In addition, I would like to get details / recommendations on the following :

  1. The “Rich Text” data is not stored on the database. It is stored in the file system. Can you please clarify this a bit further? Is there a way I can validate the images / paths on the QC Server?
  2. We can store “Rick Text” on the DB but it is not recommended. However, since we are planning to use the “Rich Test” option heavily, do you foresee any issues in storing it on a DB? As loosing that data (stored in Rich Text) will be catastrophic.
  3. Can you provide listing of all systems / application log/error file names with their path which can be used to troubleshoot issues?

 Thanks!

Contact Us

Vivit Worldwide
P.O. Box 18510
Boulder, CO 80308

Email: info@vivit-worldwide.org

Mission

Vivit's mission is to serve
the Hewlett Packard
Enterprise User
Community through
Advocacy, Community,
and Education.