Grid objects and methods (client-side reference)

 

Applies To: Dynamics CRM 2015

With Microsoft Dynamics CRM Online 2015 Update 1 you can do more with sub-grid controls in forms by using new events and objects. More information: Write scripts for subgrids

Important

For Microsoft Dynamics CRM Online organizations, this feature is available only if your organization has updated to Dynamics CRM Online 2015 Update 1. This feature is not available for Dynamics CRM (on-premises).

In this topic

• GridControl
  Events and methods for the GridControl: OnLoad event, addOnLoad, getEntityName, getGrid, getViewSelector and removeOnLoad.

• Grid
  Methods for the Grid returned by the GridControl.getGrid method: getRows, getSelectedRows, and getTotalRecordCount.

• GridRow
  The getData method for the GridRow returned by the **Grid.**getRows and **Grid.**getSelectedRows methods.

• GridRowData
  The getEntity method for the GridRowData returned by the **GridRow.**getData method.

• GridEntity
  Methods for the GridEntity returned by the **GridRowData.**getEntity method: getEntityName, getEntityReference, getId, and getPrimaryAttributeValue.

• ViewSelector
  Methods for the ViewSelector returned by the GridControl.getViewSelector, getCurrentView, isVisible and setCurrentView

GridControl

Before CRM Online 2015 Update 1 the only unique method for the subgrid control was refresh. When you know the name of the subgrid control you can access it using the following code, for example, to access the CONTACTS subgrid in the default account form.

var contactsSubgrid = Xrm.Page.getControl("Contacts");

Tip

To identify the names of subgrid controls in the form without opening the form editor, see the information in Use browser developer tools.

As an Xrm.Page.ui control, GridControl also has all the standard control methods: getControlType, Label methods, getParent, Visible methods, setFocus, and Notification methods as well as refresh. See Xrm.Page.ui control (client-side reference) for more information on these methods.

OnLoad event

Add event handlers to this event to run every time the subgrid refreshes. This includes when users sort the values by clicking the column headings. Use the GridControl.addOnLoad and GridControl.removeOnLoad methods to manage event handlers, usually in the form Onload event.

addOnLoad

Use this method to add event handlers to the GridControl OnLoad event.

Parameter type: Function

Example: Add the myContactsGridOnloadFunction function to the Contacts subgrid OnLoad event.

var myContactsGridOnloadFunction = function () { console.log("Contacts Subgrid OnLoad occurred") };
Xrm.Page.getControl("Contacts").addOnLoad(myContactsGridOnloadFunction);

getEntityName

Use this method to get the logical name of the entity data displayed in the grid.

Return value type: String

Example: Set the opportunitySubgrids variable to an array of subgrid controls that display opportunity records.

var opportunitySubgrids = Xrm.Page.getControl(function (ctrl, i) {
 if (ctrl.getControlType() == "subgrid") {
  return (ctrl.getEntityName() == "opportunity");
 }
 else {
  return false;
 }
})

getGrid

Use this method to get access to the Grid available in the GridControl.

Return value type: Grid

Example: Set the contactsSubgridGrid variable to the grid of the Contacts subgrid.

var contactsSubgridGrid = Xrm.Page.getControl("Contacts").getGrid();

getViewSelector

Use this method to get access to the ViewSelector available for the GridControl.

Return value type: ViewSelector

Example: Set the contactsSubgridViewSelector variable to the view selector of the Contacts subgrid.

var contactsSubgridViewSelector = Xrm.Page.getControl("Contacts").getViewSelector();

removeOnLoad

Use this method to remove event handlers from the GridControl OnLoad event.

Parameter type: Function

Example: Add the myContactsGridOnloadFunction function to the Contacts subgrid OnLoad event and then remove it.

var myContactsGridOnloadFunction = function () { console.log("Contacts Subgrid OnLoad occurred") };
Xrm.Page.getControl("Contacts").addOnLoad(myContactsGridOnloadFunction);
Xrm.Page.getControl("Contacts").removeOnLoad(myContactsGridOnloadFunction);

Grid

Use Grid methods to access information about data in the grid. Grid is returned by the GridControl.getGrid method.

getRows

Returns a collection of every GridRow in the Grid.

Return value type: Collection

Example: Set the allRows variable to a collection of GridRow from the Contacts subgrid.

var allRows = Xrm.Page.getControl("Contacts").getGrid().getRows();

Remarks:

See Collections (client-side reference) for information on the methods available to access data in a collection.

getSelectedRows

Returns a collection of every selected GridRow in the Grid.

Return value type: Collection

Example: Populate the selectedEntityReferences Array variable with entity references for selected rows from the Contacts subgrid.

//Get an array of entity references for all selected rows in the subgrid
var selectedEntityReferences = [];
var selectedRows = Xrm.Page.getControl("Contacts").getGrid().getSelectedRows();
selectedRows.forEach(function (selectedRow, i) {
 selectedEntityReferences.push(selectedRow.getData().getEntity().getEntityReference());
});

Remarks:

See Collections (client-side reference) for information on the methods available to access data in a collection.

getTotalRecordCount

In the web application or the Dynamics CRM for Outlook client while connected to the server, this method returns the total number of records that match the filter criteria of the view, not limited by the number visible in a single page.

When the Dynamics CRM for Outlook client is not connected to the server, this number is limited to those records that the user has selected to take offline.

For Microsoft Dynamics CRM for tablets and Microsoft Dynamics CRM for phones this method will return the number of records in the subgrid.

Return value type: Number

Example: Set the filteredRecordCount variable to the total number of records that match the filter criteria of the view.

var filteredRecordCount = Xrm.Page.getControl("Contacts").getGrid().getTotalRecordCount();

GridRow

Use the **GridRow.**getData method to access the GridRowData. A collection of GridRow is returned by **Grid.**getRows and **Grid.**getSelectedRows methods.

getData

Returns the GridRowData for the GridRow.

Return value type: GridRowData

Example: Populate the allGridRowData Array variable with GridRowData for all rows from the Contacts subgrid.

var allGridRowData = [];
var rows = Xrm.Page.getControl("Contacts").getGrid().getRows();
rows.forEach(function (row, i) {
 allGridRowData.push(row.getData());
});

GridRowData

Use the **GridRowData.**getEntity method to access the GridEntity. GridRowData is returned by the **GridRow.**getData method.

getEntity

Returns the GridEntity for the GridRowData.

Return value type: GridEntity

Example: Populate the allGridEntities Array variable with GridEntity for all rows from the Contacts subgrid.

var allGridEntities = [];
var rows = Xrm.Page.getControl("Contacts").getGrid().getRows();
rows.forEach(function (row, i) {
 allGridEntities.push(row.getData().getEntity());
});

GridEntity

Use the GridEntity methods to access data about the specific records in the rows. GridEntity is returned by the **GridRowData.**getEntity method.

getEntityName

Returns the logical name for the record in the row.

Return value type: String

Example: Set the firstEntityType variable to the value of the entity logical name for the first row in the Contacts subgrid.

var firstEntityType = Xrm.Page.getControl("Contacts").getGrid().getRows().get(0).getData().getEntity().getEntityName();
// firstEntityType == "contact"

getEntityReference

Return value type: Lookup

Example: Set the firstEntityType variable to an entity reference for the first row in the Contacts subgrid.

var firstEntityReference = Xrm.Page.getControl("Contacts").getGrid().getRows().get(0).getData().getEntity().getEntityReference();
// firstEntityReference.entityType == "contact"
// firstEntityReference.id == "{13CD16BD-3EC4-E411-80CF-00155DB58496}"
// firstEntityReference.name == "Rene Valdes (sample)"

Remarks:

This lookup has the following properties:

Name	Type	Description
entityType	String	The logical name for the record in the row. The same data returned by the GridEntity.getEntityName method.
id	String	The id for the record in the row. The same data returned by the GridEntity.getId method.
name	String	The primary attribute value for the record in the row. The same data returned by the GridEntity.getPrimaryAttributeValue method.

getId

Returns the id for the record in the row.

Return value type: String

Example: Set the firstEntityId variable to the value of id of the record from the first row in the Contacts subgrid.

var firstEntityId = Xrm.Page.getControl("Contacts").getGrid().getRows().get(0).getData().getEntity().getId();
// firstEntityId == "{13CD16BD-3EC4-E411-80CF-00155DB58496}"

getPrimaryAttributeValue

Returns the primary attribute value for the record in the row.

Return value type: String

Example: Set the currentView variable to the current view of the view selector for the Contacts subgrid.

var firstEntityPrimaryAttributeValue = Xrm.Page.getControl("Contacts").getGrid().getRows().get(0).getData().getEntity().getPrimaryAttributeValue();
// firstEntityPrimaryAttributeValue == "Rene Valdes (sample)"

ViewSelector

Use the ViewSelector methods to get or set information about the view selector of the subgrid control.

Note

If the subgrid control is not configured to display the view selector, calling the ViewSelector methods will throw an error.

getCurrentView

Use this method to get a reference to the current view.

Return value type: Lookup object

Example: Set the currentView variable to the current view of the view selector for the Contacts subgrid.

var currentView = Xrm.Page.getControl("Contacts").getViewSelector().getCurrentView();

Remarks:

If the subgrid control is not configured to display the view selector, calling this method on the ViewSelector returned by the GridControl.getViewSelector method will throw an error.

isVisible

Use this method to determine whether the view selector is visible.

Return value type: Boolean

Example: Set the viewSelectorIsVisible variable to represent the visibility status of the view selector for the Contacts subgrid.

var viewSelectorIsVisible = Xrm.Page.getControl("Contacts").getViewSelector().isVisible();

Remarks:

If the subgrid control is not configured to display the view selector, calling this method on the ViewSelector returned by the GridControl.getViewSelector will throw an error.

setCurrentView

Use this method to set the current view.

Parameter type: Lookup object

Example: Set the ContactsIFollow variable to be the current view of the Contacts subgrid.

var ContactsIFollow = {
 entityType: 1039, // SavedQuery
 id:"{3A282DA1-5D90-E011-95AE-00155D9CFA02}", 
 name: "Contacts I Follow"
}
//Set the view using ContactsIFollow
Xrm.Page.getControl("Contacts").getViewSelector().setCurrentView(ContactsIFollow);

Remarks:

If the subgrid control is not configured to display the view selector, calling this method on the ViewSelector returned by the GridControl.getViewSelector will throw an error.

This Lookup has the following properties:

Name	Type	Description
entityType	Number	The object type code for the SavedQuery (1039) or UserQuery (4230) that represents the view the user can select.
id	String	The id for the view the user can select.
name	String	The name of the view the user can select.

See Also

What’s new for Microsoft Dynamics CRM Online 2015 Update 1
Write scripts for subgrids
Xrm.Page.ui control (client-side reference)
Collections (client-side reference)
Client-side programming reference
Write code for Microsoft Dynamics CRM forms
Write client application extensions

© 2016 Microsoft. All rights reserved. Copyright