Knowledge Base

Expand all | Collapse all

Retrieve Filter ID

  • 1.  Retrieve Filter ID

    Posted 8 days ago
    Hi All,

    I want to retrieve filter id associated with the test case. I can pull document id from documentlist. Based on that i need to get filter id of that test case, if its added in any filter.

    Is there any DAO for this to get filterid?

    Thanks in Advance.

    ------------------------------
    Sathish Babu
    ------------------------------


  • 2.  RE: Retrieve Filter ID

    Posted 8 days ago
    Hi Sathish,

    To get filter ids of items that would be returned by running the filter, I think you'd need to run every filter, then get results from the filter, then run a query on the result sets for the item id. The filter returns results that can change at any time, and are not stored in the database, but calculated and potentially exported. Can I ask what this would be for, and if maybe we can go about getting what you need another way?

    Thanks!

    ------------------------------
    Sara Jensen
    Developer Support Engineer
    Jama Software
    Portland OR
    503.922.1058
    ------------------------------



  • 3.  RE: Retrieve Filter ID

    Posted 8 days ago
    Hi Sara,

    I am customizing the Review comments stats report based on my requirement.

    In that requirement i need to show filter id as a column in the excel file. For this purpose i have to retrieve filter id from jama using velocity code to show in the exported excel file.

    Can you please help me on this? Is there any method or DAO to get filter id using document id or document key?

    ------------------------------
    Sathish Babu
    ------------------------------



  • 4.  RE: Retrieve Filter ID

    Posted 7 days ago
    Do you need something like the jira feature that shows in which agile board an item appears?

    ------------------------------
    Harald Hotz-Behofsits
    Frequentis AG
    ------------------------------



  • 5.  RE: Retrieve Filter ID

    Posted 7 days ago
    Hi Harald,

    Below screenshot is my customized report

    With this i need to add one more column "FilterID". So final output will be


    I am using your trick only, to get review comments using query in velocity template. Please find the link below:

    https://community.jamasoftware.com/communities/community-home/digestviewer/viewthread?MessageKey=91dd7e69-09cb-4189-b6f7-20d9dd54eda0&CommunityKey=59a0baa5-fd21-4179-b5fa-7af3668817bb&tab=digestviewer#bm91dd7e69-09cb-4189-b6f7-20d9dd54eda0

    I hope you understand what i am expecting.

    Thanks in advance

    ------------------------------
    Sathish Babu
    ------------------------------



  • 6.  RE: Retrieve Filter ID

    Posted 7 days ago
    To the review belongs a baseline. Baseline has an attribute refId, this contains the filterId in case the scopeId=14.

    ------------------------------
    Harald Hotz-Behofsits
    Frequentis AG
    ------------------------------



  • 7.  RE: Retrieve Filter ID

    Posted 7 days ago
    the baselineId is in the revision, if you use the queries of my template, then you iterate thru the revisions, just have another query there that fetches the baseline using the baselineDao and then you have the filterId if the scopeId=14.

    ------------------------------
    Harald Hotz-Behofsits
    Frequentis AG
    ------------------------------



  • 8.  RE: Retrieve Filter ID

    Posted 6 days ago
    Hi Harald,

    Thanks for the update.

    I got it. As you said, by looping revisions i got refid and i shown te same in filter id column.

    ------------------------------
    Sathish Babu
    ------------------------------