What do rollup values really look like?

Lita Gribben
Lita Gribben Member, Data Exchange, Jama Connect Interchange™ (JCI) Posts: 90
edited March 13 in Peer-to-Peer Support Forum

I'm testing out the usage of a rollup field to show whether downstream TBD items are resolved, since a requirement could have multiple TBDs. When I add/remove relationships to see the percentages change, I notice some odd behavior on the rollup field. 

I can tell that it takes about a minute for the rollup calculation to be updated, which is fine, but if I do a filter to see the items that have a rollup value less than 100% it still shows items with 100%, not all, only a couple. And if I try sorting the results of such filter by the rollup field column it won't sort correctly either, if I go from low to high, the 100% items don't appear at the bottom, but if I sort from high to low they do appear at the top. 

What is even more unusual is that if I go and manually do an index of the project then the results of the filter become accurate and the 100% items don't show anymore (filter was looking for rollup that wasn't 100). We can't count on indexing all the time to correct this behavior, is there anything else I'm missing? Is this expected behavior? should the filter be configured different?

------------------------------
Lita Gribben
Blue Origin
------------------------------

Comments

  • [Deleted User]
    [Deleted User] Posts: 152
    edited August 2023

    Hi Lita, 

    This sounds like it may be a defect, and we'd like to dig in deeper with you. Please file a ticket here to partner with our Support team, and include a link to this thread in the ticket description -- as a heads up, we'll likely need HAR files from the current environment as well as a support bundle.

    ------------------------------
    Carly Rossi // she/her/hers
    Community Program Manager // Jama Software
    Portland, OR
    ------------------------------
    -------------------------------------------
    Original Message:
    Sent: 08-24-2023 08:56
    From: Lita Gribben
    Subject: What do rollup values really look like?

    I'm testing out the usage of a rollup field to show whether downstream TBD items are resolved, since a requirement could have multiple TBDs. When I add/remove relationships to see the percentages change, I notice some odd behavior on the rollup field. 

    I can tell that it takes about a minute for the rollup calculation to be updated, which is fine, but if I do a filter to see the items that have a rollup value less than 100% it still shows items with 100%, not all, only a couple. And if I try sorting the results of such filter by the rollup field column it won't sort correctly either, if I go from low to high, the 100% items don't appear at the bottom, but if I sort from high to low they do appear at the top. 

    What is even more unusual is that if I go and manually do an index of the project then the results of the filter become accurate and the 100% items don't show anymore (filter was looking for rollup that wasn't 100). We can't count on indexing all the time to correct this behavior, is there anything else I'm missing? Is this expected behavior? should the filter be configured different?

    ------------------------------
    Lita Gribben
    Blue Origin
    ------------------------------
  • Lita Gribben
    Lita Gribben Member, Data Exchange, Jama Connect Interchange™ (JCI) Posts: 90
    edited August 2023

    Thanks Carly, I did open a ticket and turns out this is logged already under defect SOS-DEF-4044

    ------------------------------
    Lita Gribben
    Blue Origin
    ------------------------------
    -------------------------------------------
    Original Message:
    Sent: 08-31-2023 11:18
    From: Carly Rossi
    Subject: What do rollup values really look like?

    Hi Lita, 

    This sounds like it may be a defect, and we'd like to dig in deeper with you. Please file a ticket here to partner with our Support team, and include a link to this thread in the ticket description -- as a heads up, we'll likely need HAR files from the current environment as well as a support bundle.

    ------------------------------
    Carly Rossi // she/her/hers
    Community Program Manager // Jama Software
    Portland, OR
    ------------------------------

    Original Message:
    Sent: 08-24-2023 08:56
    From: Lita Gribben
    Subject: What do rollup values really look like?

    I'm testing out the usage of a rollup field to show whether downstream TBD items are resolved, since a requirement could have multiple TBDs. When I add/remove relationships to see the percentages change, I notice some odd behavior on the rollup field. 

    I can tell that it takes about a minute for the rollup calculation to be updated, which is fine, but if I do a filter to see the items that have a rollup value less than 100% it still shows items with 100%, not all, only a couple. And if I try sorting the results of such filter by the rollup field column it won't sort correctly either, if I go from low to high, the 100% items don't appear at the bottom, but if I sort from high to low they do appear at the top. 

    What is even more unusual is that if I go and manually do an index of the project then the results of the filter become accurate and the 100% items don't show anymore (filter was looking for rollup that wasn't 100). We can't count on indexing all the time to correct this behavior, is there anything else I'm missing? Is this expected behavior? should the filter be configured different?

    ------------------------------
    Lita Gribben
    Blue Origin
    ------------------------------

Categories