Skip to main content
Planview Customer Success Center

Is there a way to include a filter parameter automatically for reports run outside of CP?(CP 2012 SP2)

QUESTION:
I am currently setting up some links in SharePoint to Changepoint reports. I followed the instructions in the 2012 installation guide and got the report to run by using the following URL:

https://Customer.changepointasp.com/...2-2FF84238366A

The documentation says however that additional parameters can be added by placing a ";" between each new one added. This would lead me to believe that the following URL should specify the same report but also filter on the project specified. However doesn't seem to be the case.

https://customer.changepointasp.com/...7-CDD6F5053247

Is there a way to filter the report based on a projectid?

I only know of one way, which is to use the "container" addition to the URL. This prompts the filter page, but I'm trying to allow for the filter to be automatic.

https://Customer.changepointasp.com/...2-2FF84238366A


ANSWER:
It is possible with a URL like this one:

http://mylocalweb/core/portlet.aspx?...d};bypass=true

The reportid and entityid are easy GUIDs to discover. The runtimefilterid not so much. If the report has been linked to the profile page you can get it by running fiddler when the page is launched from the profile page. (Assuming that they have properly linked the id). Another method would be to run the following sql query:

select * from runtimefilter where reportid = ‘{reportid}’

The output will look like the following:

ReportId ColumnId RuntimeFilterId DisplayName
7AB5F050-8A26-4882-99D2-6E42B3344304 B6C912E2-DD8D-4007-A544-7F4BCA19B888 AB06D6BC-359F-4ACB-BA5E-A7F4E1D4B1FF Project manager
7AB5F050-8A26-4882-99D2-6E42B3344304 FCCDEDD8-986C-4EAA-ABBE-05634AF23E43 24B506A0-7E19-45F0-AF83-F04A3DFFCEDA Project name
7AB5F050-8A26-4882-99D2-6E42B3344304 90267CD5-610D-4A21-9760-CB759B7C3B11 F80A5E09-D8A8-475F-BCC2-F1315B8E8AD7 Project status

The correct runtimefilterid is the one associated with Project Name.