Reporting on Issues within Projects | Community
Skip to main content
MaryMc1
MaryMc1
June 16, 2025
Solved

Reporting on Issues within Projects

  • June 16, 2025
  • 3 replies
  • 783 views

Hello,

We have users that are associating a custom project status and when they select that project status, they're supposed to enter an issue within the project with that status. I'm trying to build a report to see when projects have that status, show me only when the issue doesn't exist. It's basically an audit type report to ensure we're entering issues into projects with that status. I attempted to build it as a project report and if the issue id is blank which means it doesn't exist, but that's not a native option. Thoughts? Thanks!
Mary

Best answer by Sven-iX

Hi Sven,

You're correct, that's why I didn't built it as an Issue report. I attempted to use text mode and use the not exists options you noted and it didn't work. I found an alternative option, using ChatGPT actually, to search for projects in that status and if the number of open issues equals 0, that pulled what I was looking for. If you're able to get it to work via text mode to show in a Project report to show when an issue doesn't exist when a specific project status is selected, pass that along as I was striking out. Thanks!


Hi @marymc1 

here the exists block 

portfolioID=64d51cc....216048 status={special project status} status_Mod=in EXISTS:a:$$OBJCODE=OPTASK EXISTS:a:projectID=FIELD:ID EXISTS:a:status={special issue status} EXISTS:a:$$EXISTSMOD=NOTEXISTS

 

EXISTS works like this: 

  • check for OPTASK objects (issues)
  • that are linked to the project by projectID = the project's ID
  • where the status is {special issue status} (3-letters)
  • list only where such tasks DON'T exist

 

At the start the portfolio DI to limit the search (you may want that or not - alwasy try to make the filter as narrow as possible)

and the check for the project special status.

3 replies

Sven-iX
Community Advisor
Sven-iXCommunity Advisor
Community Advisor
June 17, 2025

Sounds like a project report filtering to that status, with an EXISTS block that looks for notexists, issues:status=XXX (special issue  status) would work? 

 

    Richard__Carlson
    Community Advisor
    Richard__CarlsonCommunity Advisor
    Community Advisor
    June 17, 2025

    I would consider building an issue report grouped by project

      Sven-iX
      Community Advisor
      Sven-iXCommunity Advisor
      Community Advisor
      June 17, 2025

      OP asked to see projects that "show me only when the issue doesn't exist" - if it's an issue report that won't work.

        MaryMc1
        MaryMc1Author
        June 18, 2025

        Hi Sven,

        You're correct, that's why I didn't built it as an Issue report. I attempted to use text mode and use the not exists options you noted and it didn't work. I found an alternative option, using ChatGPT actually, to search for projects in that status and if the number of open issues equals 0, that pulled what I was looking for. If you're able to get it to work via text mode to show in a Project report to show when an issue doesn't exist when a specific project status is selected, pass that along as I was striking out. Thanks!

        kautuk_sahni
        Community Manager
        kautuk_sahniCommunity Manager
        Community Manager
        July 29, 2025

        @marymc1 Just checking in — were you able to resolve your issue? We’d love to hear how things worked out. If the suggestions above helped, marking a response as correct can guide others with similar questions. And if you found another solution, feel free to share it — your insights could really benefit the community. Thanks again for being part of the conversation!

        Kautuk Sahni
        Terms & ConditionsAccessibility statement

        Loading footer...