Can you get a project level report to show which request types were or were not submitted | Community
Skip to main content
TimothyBr
TimothyBr
Level 4
March 11, 2025
Solved

Can you get a project level report to show which request types were or were not submitted

  • March 11, 2025
  • 1 reply
  • 352 views

Hello, and thanks for any support in advance! 

 

I am trying to run a project level report which would show all projects that DID NOT have a type of request submitted as an intra-project request. 

 

Overall example: We expect one of our teams to submit two intra projects requests; one at the start of a project and one at the end the "rank" the project. I am trying to think of a way without Fusion to flag when these HAVE NOT been submitted. Like a governing check to confirm who did not follow process. 

 

Thanks! 

    Best answer by skyehansen

    You can probably use EXISTS filters to get at a lot of this. However, it would depend on how you identify these requests, which isn't clear in your original post.

     

    For example, if each of your requests uses a unique custom form, you can filter on projects which do not have a request that has custom form A or custom form B (or both). 

     

    If the requests use a standard and consistent title, same: projects that do not have a request with title ABC or XYZ.

     

    Or if the requests utilize unique queue topic names.

     

    It's difficult to give you a more specific answer without some more information though -- as you can see, I've listed three different ways to submit these kinds of requests and each would be a different type of filter.

    1 reply

    skyehansen
    Community Advisor
    skyehansenCommunity AdvisorAccepted solution
    March 11, 2025

    You can probably use EXISTS filters to get at a lot of this. However, it would depend on how you identify these requests, which isn't clear in your original post.

     

    For example, if each of your requests uses a unique custom form, you can filter on projects which do not have a request that has custom form A or custom form B (or both). 

     

    If the requests use a standard and consistent title, same: projects that do not have a request with title ABC or XYZ.

     

    Or if the requests utilize unique queue topic names.

     

    It's difficult to give you a more specific answer without some more information though -- as you can see, I've listed three different ways to submit these kinds of requests and each would be a different type of filter.

    Terms & ConditionsAccessibility statement

    Loading footer...