Once a Grid has been configured, users can access it from the “Grids” tab or by using the embedded link. Embedded links are used to embed a grid in another page. For example in another web page as an iFrame, in a Salesforce Visualforce page, or in a SAP Hybris C4C mashup.
Grid URL Parameters
Most methods of providing access to a Grid require you to generate a Grid URL. A simple version of the Grid URL is generated for you on page 1 of the Grid Wizard. Below are some URL parameters that the Grid supports. Including these parameters provides more control over how a Grid initially loads.
| Parameter | Description |
|---|---|
| ea | “Expand All” option. A value of 1 shows all child related lists expanded by default. A value of show_related_objects shows all child related lists collapsed by default. A value of 0 hides all child related lists by default. Passing a list of object API names shows just those child related lists expanded by default, i.e. ea=Contact,Opportunity. This parameter only applies to multi-object grids. |
| fpf | “Filter by Parent Field” option. Specify the API name of a field on the grid parent object. Note, filter conditions defined in Grid Wizard 3 and in the user-defined filter widget will be applied in addition to the criteria specified by the fpf/fpv parameters. This parameter is only supported for fields with the following data types: id, lookup, text, picklist, email, URL, phone, boolean, date (literal (SAP only) and relative), and datetime (using relative dates). |
| fpf2-fpf5 | Additional “Filter by Parent Field” options. These can be added to grid URLs to filter grids further.
For example: fpf=Stage&fpf2=CloseDate&fpf3=ForecastCategoryName&fpf4=LeadSource&fpf5=Type. |
| fpv | “Filter by Parent Value” option. The value that the fpf parameter should evaluate to. Records that have this value for the fpf field will be displayed on the grid. Note, filter conditions defined in Grid Wizard 3 and in the user-defined filter widget will be applied in addition to the criteria specified by the fpf/fpv parameters.
Examples of filtering: https://www.gridbuddyconnect.com/grid/embed/E5AD7390-DC70-4E39-94DE-62F38E164B30?fpf=AccountID&fpv=1000065 https://www.gridbuddyconnect.com/grid/embed/E5AD7390-DC70-4E39-94DE-62F38E164B30?fpf=BillingState&fpv=CA |
| fpv2-fpv5 | Additional “Filter by Parent Value” options.
Example of filtering by Opportunity Close Date to show Opportunities closing this quarter with a Lead Source of Web: |
| recordid | Specify the ID of the parent record you want to filter child results by Detail Page Related Lists. This ID must be a valid Salesforce record ID matching the object type of the parent object you defined in page 1 of the Grid Wizard. When this parameter is specified, the “ea” parameter is automatically set to 1 and the “sh” and “ssb” parameter are automatically set to 0, expanding all records, and hiding the header and sidebar. |
Examples:
The URL below loads a Grid and will automatically expand all child records on load.
- https://gridbuddyconnect.com/grid/embed/E5AD7390-DC70-4E39-94DE-62F38E164B30?ea=1
The URL below only loads a grid with records with an ID of 0015000000HtRNX.
- https://gridbuddyconnect.com/grid/embed/E5AD7390-DC70-4E39-94DE-62F38E164B30?recordid=0015000000HtRNX
