Report coding help - adding only OPEN and HIGH items from change requests and RAID Log to a report | Community
Skip to main content
O
OliviaMi
Level 4
August 24, 2020
Question

Report coding help - adding only OPEN and HIGH items from change requests and RAID Log to a report

  • August 24, 2020
  • 1 reply
  • 417 views

I’m trying to add Open and HIGH items from our change requests and RAID log‚Ķ we have a status that equals Open, and we have a risk rating field we created that can equal high, medium, low.

Here is the code I’ve come up with:

DE=Rating_Mod=in

displayname=RAID items

listdelimiter=<p>

listmethod=nested(issues).lists

projectPortfolioID_Mod=in

status=ARL

status_Mod=in

textmode=true

type=iterate

valuefield=description

valueformat=HTML

I can’t seem to get why it’s returning some closed items? And I can’t seem to have it show only the high items. Any ideas on what I am doing incorrectly here?

    This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.

    1 reply

    imgrund
    Adobe Employee
    imgrundAdobe Employee
    Adobe Employee
    August 25, 2020

    Hi Olivia - To my knowledge, you can't combine a filter and a collection. The trick is to change the valuefield to valueexpression and utilize IF statements. Some of your filters (like Project Portfolio ID are confusing me because I don't see the ID number.

    Here is what I think you want, but just replace 1234 with the portfolio ID. (Also, I did it so that Rating was on the issue level, if it is on the project level add "{project}." before {DE:Rating}

    displayname=RAID items

    listdelimiter=<br>

    listmethod=nested(issues).lists

    textmode=true

    type=iterate

    IF({project}.{portfolioID}="1234",IF({status}="ARL",IF({DE:Rating}="HIGH",{description},""),""),"")

    valueformat=HTML

    Hope this helps

      imgrund
      Adobe Employee
      imgrundAdobe Employee
      Adobe Employee
      August 25, 2020

      Actually, I just thought about this, do you need portfolio ID on the collection level? You could do that on the Project report itself (which might be better so you can do prompts or put dashboard in a layout template). So you might want

      displayname=RAID items

      listdelimiter=<br>

      listmethod=nested(issues).lists

      textmode=true

      type=iterate

      IF({status}="ARL",IF({DE:Rating}="HIGH",{description},""),"")

      valueformat=HTML

        Terms & ConditionsAccessibility statement

        Loading footer...