URL Hack Button In Lightning Experience To Show Report

URL Hack button in Salesforce- Classic:
In this example, create a list button in Account object. When we click custom button on account detail page, it will redirect to the custom report. You can add URL parameter to the link that represents the report filter.
Go to Setup -> Account-> Buttons, Links, and Actions-> New Button or Link. Create a New  button and add to the Buttons in Account layout.

/00Ot0000000VeqV?pv0={!Account.ParentId}&pv1={!Account.Id)}


Here,

00Ot0000000VeqV : Report Id

pv0  : The “pv” in pv0 stands for “parameter value”, where “0” is the location of the value you want to set.
pv1 : “1” is the location of the value you want to set.




URL Hack button in Salesforce- Lightning:
Go to Setup -> Account-> Buttons, Links, and Actions-> New Button or Link. Create a New  button and add to the  Salesforce Mobile and Lightning Experience Actions in Account layout.

{!$Site.BaseUrl}/one/one.app#/sObject/00Ot0000000VeqV/view?fv0={!Account.ParentId}&fv1={!Account.Id)}

Here,
{!$Site.BaseURL} : Returns the base URL of the current site that references and links should use.
fv0 : fv0 (or filter-value-zero) — the first URL parameter which corresponds to the first custom report filter. 
f1: Second URL parameter which corresponds to the second custom report filter. 


Comments

Post a Comment

Popular posts from this blog

Syncing And Unsyncing Quote With Opportunity Using Flow And Process Builder

Image
Auto Sync And Unsync Accepted Quote with Opportunity Using Flow And Process Builder Synced Quote is field on opportunity object. This field is lookup field with Quote object.  IsSyncing field on Quote object is not a writable field. As we can not perform any action on IsSyncing field of Quote object. We have to make IsSyncing checkbox true using lookup filed (Synced Quote) on opportunity object.  To automate Quote Sync Process, you have to populate the value in the  Synced Quote field .   1 . Click on   Name | Setup | App Setup | Create | Workflows & Approvals | Flows 2 . Click on   New Flow , it will open flow canvas for you, now create one   Text   variable   VarT_QuoteId  to pass the Quote ID. We will use this variable in the flow, as shown in the following screenshot. Likewise, create one more   Text   variable  VarT_OpportunityId  to pass the Opportunity Id. 3 . The next st...
Read more
Image
Open Report in New Window on Record Page In Lightning We can open report in new window from record page in lightning Experience. We will pass report id 00O0K00000B0Egn from ShowReport.cmp. In NavigateToReport.cmp we will get record details of current page. We can fetch any fields on record using force:recordData. In controller, we can form url to navigate and pass paramters to filter values. We can open report in new window using, window.open(url ,'_blank','toolbar=no,location=no,status=no,menubar=no,scrollbars=yes,resizable=yes,width='+ w +'px,height='+ h +'px,top=50px,left=100px'); After this we will close modal using force:closeQuickAction. We need to create quick action to call ShowReport.cmp on record page button. Don't forget to add quick action in Mobile & Lightning Actions section in page layout . Loading Records - Make a record available for your UI components is to load it. Load the record by inclu...
Read more