I have a custom object X (master) in a master-detail relationship with custom object Y. When I click on the Y related list it brings up the records 50 at a time, Scrolling down loads another 50 records. I have two issues:
1. Once I get to 1000 lines I can not load additional lines. Is some cases the related list has 5000+ records so I can literally not see 4000+ records. See attached screen shot
2. Is there anyway to load more that 50 records at a time? Scrolling though a long list is painful.
Has anyone else run into this??
So I came up with a workaround and wanted to share. I created a report for Object Y filtered by Object X's ID. I then used the new "Filter reports by URL in Lightning" feature along with a formula field to create a hyperlink to the report and pass in Object X's ID. I then put the link in the header of object X. So now the user can just click on the link and get a report with all 5K+ records.
Here's the formula I used (works in classic and LEX)
================
HYPERLINK(
/* If they're in Lightning */
IF($User.UIThemeDisplayed="Theme4d",
/* Use Lightning syntax, optimized to avoid full page reload */
"#/sObject/00O63000000LpWn/view?fv0=",
/* Otherwise use Classic syntax */
"/00O63000000LpWn?pv0=")
/* Append the Agreement ID */
&Id,
/* Specify the link text */
"All Products",
/* Keep it in the same browser tab to avoid full page reload */
"_self"
)
========================
Question: Does anyone know if it is possible to pass a URL parameter into a report in Napili??
@* Experience Cloud - Best Practices *
