Forum Discussion

nmurarka's avatar
nmurarka
New Contributor
4 years ago

Seeking to Insert 75+ projects into Reporting filter easily

  I have multiple reports that run in Confluence that roll up 75+ JIRA Projects against test cycles that are all named the same for a release.  Therefore, I filter by name of test cycle.   T...
MisterB's avatar
MisterB
Champion Level 3
4 years ago

Hi,

 

I'll try to help.  Can you please describe how you have structured your test models in Zephyr Scale.  For example, do you have 75 projects, all with the same cycle names as in the example below?

 

Project 1

Test Cycle SameName1

Test Cycle SameName2

Project 2

Test Cycle SameName1

Test Cycle SameName2

...

Project 75

Test Cycle SameName1

Test Cycle SameName2

 

Thanks

  • nmurarka's avatar
    nmurarka
    New Contributor
    4 years ago

    Yes, thank you.  That's correct.

     

    I filter based on Custom Query (Cycle Name = XYZ) if XYZ was my cycle name shared across all projects.

    • MisterB's avatar
      MisterB
      Champion Level 3
      4 years ago

      Probably a stupid question but have you saved the URL to your reports after you've run them.  The URL is dynamic and will update based on the underlying criteria when it was run.  Would that help?

      • nmurarka's avatar
        nmurarka
        New Contributor
        4 years ago

        The filter is in confluence and I don't see a reference to a "URL" for that report generated in the description below.

    • MisterB's avatar
      MisterB
      Champion Level 3
      4 years ago

      Sorry, I can't quite understand what it is you're trying to achieve.  Are you able to provide a bit more detail?

      • nmurarka's avatar
        nmurarka
        New Contributor
        4 years ago

        I am using the Confluence Report "Test Execution Scorecard by Project."  I am able to access this report by:

        1. 1. Go to Confluence
        2. 2. Add Other Macros
        3. 3. Select Macro -> Reporting -> Test Execution By Scorecard
        4. 4. The following window shows up.  I then type individually 50+ projects since there is no way to insert project names via a csv or any sort of deliminated string.  

        I want to see if there is a way to copy and paste in these project references (to JIRA) automatically instead of having to manually continue to type them in for all the reports.  For instance, if I have project names such as:

        • Chair
        • Desk
        • Computer
        • Stand
        • Fan
        •  

        I have to individually type, "Chair" + enter + "Desk" + enter + Computer + enter + Stand + enter + Fan + enter for the projects to register.  I cannot paste something like:

        Chair, desk, computer, stand, fan

        Chair; desk; computer; stand; fan

        etc...

         

        I have to individually type in each one.  That's painful.