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.
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.
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
Requirement user template entities - not visible or updateable in Requirement Module
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
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?
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?
Need to visibly show via the Requirements Grid or Tree view when a requirement has been baselined or changed after being baselined.
Is it possible to implement a new way of hiding fields from the Details menu when creating a requirement?
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.
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_USER_TEMPLATE_04 'Requirement.Threshold Platform Type'
order by rq_req_path asc
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.
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
Hi, what is parameter I need to add to Site Admin -> Site configuration for Requirements coverage from Test Lab (not from Test Plan) ?
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?
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?
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:
- Checked the Site Admin module for any specific settings. Also, checked various if I need to setup any parameters in “Site Configuration”
- Checked the Project setup for any specific setting.For the (1) and (2) did not find any find any leads
- 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 :
- 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?
- 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.
- Can you provide listing of all systems / application log/error file names with their path which can be used to troubleshoot issues?
I am using ALM 12 and have requirements which contain percent and greater than symbols. The problem is ALM is converting the % to # and the < to -= in the requirement description. Does anyone know a way to fix this so when I export the requirements, the symbols are exported correctly?
Version ALM 12.20
When creating a customized field that presents the requirement numbers that are traced to it, I have found the custom field updates as expected when the user is in the TDAdmin group but isn't able to execute it when they are in a different group. I have created a completely seperate group copied after the TDAdmin group and I am still unable to get the workflow script to execute. Only if they are in the TDAdmin group will it work.
I need all groups to be able to execute this code so that the traceability is displayed. This is used for a custom report that we can't change.
With HP ALM. I want to change the 'target cycle' and 'target release cycle' of all the requirements linked to the tests of a certain testset. Is this possible to do a certain filter on that with HP ALM?
Because now I have to do this manually one by one.
These requirements need to be have to correct 'Target release cycle' in order to have them included to generate the testfile with covered requirments of a certain release.
Thanks in advance.
Does anyone know if ALM 11, Enterprise Edition, has an option to create a requirements report from a basline? (If it does, what ALM standard role does a user need in order to see the option?)
According to what I've read (HP User Guide for ALM 11, Chapter 38 (Project Reports), Page 994 section 3e), I don't see any of the usual qualifiers that HP places on features that are specific to edition and version (e.g., ALM Version 11 or Premier Version 11). I started with the first page of the chapter, 991, and read through to page 994. The only qualifier I found was, "Note: To create a baseline report, all report sections must support baselines." Here's how the User Guide sets up the option:
"At the Document root level, you assign templates and define settings that apply to the overall design and content of the project report.
a. In the Configuration tab, select the Document root node. For user interface details, see "Configuration Tab – Project Reports" on page 1000.
b. Set the document output format.
c. Assign document, style and history templates, or keep the default templates. For details on the template types, refer to the HP Application Lifecycle Management Administrator Guide.
d. Click Edit Document Field Values to type values for custom fields in areas such as the title page, headers and footers, as defined in the document template.
e. To create a baseline report, select Select a Baseline, and select a baseline."
However, I can't find "Select a Baseline" anywhere in the Dashboard-->Analysis view.
Thanks for your time.
I have found some old topics related to this but I haven't been able to solve my issue so I had to make my own topic around this, I really appreciate any help and answers! :)
I have a list of requirement ID pairs, containing "old" requirement ID in column A and a "new" requirement ID in column B:
A | B
old_ID | new_ID
The "old" requirements have test cases linked to them and I would like to copy this test coverage to the "new" requirements. I had planned using business view excel report and then Excel add-in to import/modify/export the coverage from ALM and then back to ALM but I quite fast learned that test coverage cannot be modified with Excel Add-in :(
So now I'm using business view Excel report to generate the ID pairs and then planning to write Excel VBA script to copy coverage from "old" to "new". Can anyone advice if this can be done this way? I don't want to waste anymore time doing something that doesn't work in the end.
I haven't really written VBA scripts in a long time and this is the most complicated VBA I've ever tried to write so socondly I would like to get some help/advices how to do this. This is the general logic that I'm trying to script:
Get the first "old" reqID from the worksheet (column A1)
Find oldReqID from RC_REQ_ID and copy RC_ENTITY_ID:s to a list (?)
get the first "new" reqID from the worksheet (column B1),
find newReqID from RC_REQ_ID and paste RC_ENTITy_ID's
Then maybe remove the coverage from the "oldReqID" (this is not mandatory)
So would the script work if I manage to write it? Any restrictions from the application side?
And here's the beginning (really raw scetch!) of the script that I struggle to write:
...firstly, the tdc connection (it's working so I'm not putting it here)...
dim coverable as CoverableReq
Dim regF As tdc.ReqFactory
Dim TestId As Integer
Dim oldReqID () As variant, a As Long
oldReqID = Application.Transponse(Range("A1:A65541").Value)
GetCoverageTestsByReqFilter(oldReqID) As List
Am I on the right track here?