function readOnly(count){ }
Sign Up ›
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
Learn More

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
Lakshmi SLakshmi S 

How to pass record id to report url for filtering purposes?

Hi Team,

I am using analytical report chart in visualforce page.
I want to pass the record id to report for filtering process? 
<apex:pageBlockSection title="Dashboard" columns="2">
                <analytics:reportChart reportId="00O4F000000JUVJ" filter="[{column:'HIGH_RISK_SUCCESS_FACTORS__C.ID',operator:'equals',value:'{!High_Risk_Success_Factors__c.Id}'}]" size="tiny" showRefreshButton="true" />
</apex:pageBlockSection>
I am getting error like, Invalid column variables.
Please let me know how can we resolve this?

Thanks
Lakhsmi
 
Raj VakatiRaj Vakati
Please refer this link 
  
https://gist.github.com/DouglasCAyers/aab0d360c4ecc5abc0cfe91b1502d96a
  
<analytics:reportChart reportId="00O4F000000JUVJ"
                        size="tiny"
                        cacheResults="false"
                        showRefreshButton="false"
                        filter="[{column:'HIGH_RISK_SUCCESS_FACTORS__C.Id', operator:'equals', value:'{!High_Risk_Success_Factors__c.id}'}]"/>

 
Lakshmi SLakshmi S
Hi Raj,

It is not working for me.
It shows below error.

[For the filter 1: Specify a valid filterable column because HIGH_RISK_SUCCESS_FACTORS__C.Id is invalid.]


Thanks
Lakshmi