Whether to allow column reordering
Whether to allow column resizing
Whether to allow sorting
Default column settings - enables sorting, resizing
Fired when an entity link is clicked
ReadonlyExcelUnique DOM id pairing the unified Export/Excel disclosure trigger with its action popover.
Optional provider that returns the FULL result set for export. When the grid is server-side
paged, Data only holds the current page (default 100 rows), so exporting Data would silently
cap the export at the page size (bug B3/C1). A host that owns the query (with its parameters) can
supply this callback to fetch every matching row on demand; the grid awaits it when the user
exports without an explicit row selection. When not provided, export falls back to the loaded page.
Fired when grid state changes (for persistence)
Height of the grid container
Initial grid state (for restoring from persistence)
External loading state - when true, shows loading overlay
True while Open in Excel is building the workbook.
True while an export is fetching the full result set via ExportDataProvider.
ReadonlyOpenThe Open in Excel button's tooltip.
Fired when the user navigates to a different page
Current page number (1-based) for server-side paging
Page size for server-side paging
The parameter values of the query's last run. Open in Excel carries them into the workbook (never server-set ones); the host that ran the query supplies them.
Whether to automatically persist grid state (column widths, order, sort) to User Settings
If specified, this provider will be used for communication and for all metadata purposes. By default, if not provided, the Metadata and RunView classes are used for this and the default GraphQLDataProvider is used which is connected to the same back-end MJAPI instance as the Metadata and RunView classes. If you want to have this component connect to a different MJAPI back-end, create an instance of a ProviderBase sub-class like GraphQLDataProvider/etc, and configure it as appropriate to connect to the MJAPI back-end you want to use, and then pass it in here.
Fired when refresh is requested
Fired when a row is clicked
Fired when a row is double-clicked
Fired when selection changes
Selection mode for the grid
True while the unified Export/Excel toolbar action popover is open.
Whether to show export button
Whether to show the Open in Excel button. It appears only for a saved query, when the MemberJunction host serves the Excel add-in and every required parameter has a value.
Whether to show refresh button
Whether to show row count in toolbar
Whether to show selection count in toolbar
Whether to show the toolbar
Total row count for server-side paging (from RunQueryResult.TotalRowCount). When > 0 and TotalPages > 1, the data pager is displayed below the grid.
Visual configuration
StaticɵdirStaticɵfacTrue when the toolbar offers Open in Excel: a saved query is loaded, the host serves the add-in, and every required parameter the person fills in has a value from the last run.
Optional pre-built column configurations for ad-hoc queries without saved metadata. When provided, overrides both QueryInfo-derived columns and auto-inferred columns. Enables entity linking without requiring a saved Query or QueryInfo object.
Set this BEFORE setting Data to ensure columns are configured before the grid renders.
The query result data to display in the grid.
Returns either the default Metadata provider or the one specified in the Provider property, if it was specified
The QueryInfo metadata for the query being displayed. Used to derive column configurations and entity linking.
Returns either the default RunQuery provider or the one specified in the Provider property, if it was specified
Returns either the default RunView provider or the one specified in the Provider property, if it was specified
Closes the unified Export/Excel action popover, optionally restoring focus to the trigger button.
Closes the row detail panel
Export grid data directly without showing dialog
Optionaloptions: Partial<ExportOptions>Flushes any pending state changes immediately. Call this before destroying the component or switching queries to ensure all state changes are persisted.
Returns CSS classes for the container based on visual config
Navigate to the previous row in the detail panel
A callback method that performs custom clean-up, invoked immediately before a directive, pipe, or service instance is destroyed.
A callback method that is invoked immediately after the default change detector has checked the directive's data-bound properties for the first time, and before any of the view or content children have been checked. It is invoked only once when the directive is instantiated.
Handles Escape key dismissal inside the unified Export/Excel dropdown.
Invokes static snapshot export from the unified toolbar popover.
Invokes Open in Excel from the unified toolbar popover.
Handle entity link click from the row detail panel
Opens the export dialog with current grid data
Builds a workbook that loads this query, with the last run's parameters, in Excel, and downloads it.
Opens the row detail panel with the given row data
Toggles the unified Export/Excel action popover.
A data grid component for displaying query results with full interactivity. Features:
Example