How to avoid Slow Filter or million limit reached

Harald Hotz-Behofsits
edited May 2021 in
At the end both may have the same root cause.

If there is a filter query doing a downstream or upstream check having no restrictions on the project to search in.

In jama instances with millions of items this might result in long response times or million limit error messages.

How to restrict a subquery on a project, as project(s) are not selectable?
Ad into the subquery a check for ID contains projectkey*, then this subquery will only search in projects starting with that projectkey resulting in a quick response and avoiding the million error message.

Comments