Add report/dashboard to project that shows related projects via 'Associated project' typeahead field?

Question

I thought this would be easy, but so far it hasn’t worked.

We have a typeahead field called ‘Associated project’ that lets the user select another project in the system. I want to add a report/dashboard to the left panel of every project in the system that will show all the other projects that list the CURRENT project in their ‘Associated project’ field. The report works perfectly if I set it up with a prompt, but I can’t get it to work automatically when viewed within the project.

Is there a way to use text mode to filter the report based on the current Project ID?

Copilot says that this text mode expression will work, but so far it hasn’t, and I think it’s just hallucinating solutions:
!--scriptorstartfragment-->

parameterValues:Associated Project=$$PROJECT.ID

parameterValues:Associated Project_Mod=eq!--scriptorendfragment-->

skyehansen · Answer

I’m not sure what your text mode is doing but wanted to remind you that when you put a dashboard in a project it usually only shows the contents of the project it’s in. It definitely won’t show other projects.

Sign up

Login with SSO

Login to the community

Login with SSO

Scanning file for viruses.

This file cannot be downloaded