Skip to main content

Datagrids

Datagrid is used throughout the app and is designed to be consistent across. Here are some of the Datagrid features you would want to know about.

Filter Rows

Rows Filtering is about searching for some text and showing only the rows that match the search term. See Search Term to understand how to specify the search term.

Keep in Mind
  • Rows Filtering works only on the rows that are shown in the datagrid. Make sure you fetch all matched records in Query Datagird if you are looking to filter across all records.

Search All Columns

To search across all columns, enter the Search Term. App will go through all rows and all columns in those rows and identifies the rows matching the search term. If any one column of a Rows matches the search term, then that Row is considered matched and will show up.

To clear the search, click on the x icon in the search input box.

Search Specific Columns

While Search All Columns works across all columns, you can also search for specific columns. To select lit of columns to search for, click on the down arrow next to the search input box and select the list of columns you want to include in the search.

If you had already entered a search term, then when you select the columns, the app will perform the search again using that search term.

Search by Column

Search by Column allows you enter search term in a column where you want to search. To search by column,

  1. Hover over the column where you want to search
  2. Click on the small Filter icon that shows up
  3. Select the search operator (defaults to contain)
  4. Enter the search term
  5. App will start filtering rows as you enter the search term

To clear the search, click on the Reset button column filter menu. You can search in multiple columns, and in such cases, rows matching all searched columns will be shown.

Keep in Mind
  • This feature has its own way to specifying search term and doesn't follow the Search Term pattern.
  • When a column has filter applied, the small Filter icon is shown even after you hover over.

Search by Context Menu

This feature adds a set of Menu Actions to the Datagrid context menu and is basically shortcuts to perform Search by Column search.

To use this feature:

  1. Select a cell in the column where you want to search
  2. Right-click and goto Filter menu
  3. Select one of the available submenu items. See table below to understand what each of the menu actions does.
MenuDescription
Show Rows with Selected ValuesShows rows which equals selected cell value
Hide Rows with Selected ValuesHide rows which equals selected cell value
Show Rows with Blank ValuesShows rows which where selected column value is blank
Hide Rows with Blank ValuesHides rows which where selected column value is blank
Clear Selected FiltersClears filters from selected columns
Clear All FiltersClears all Row Search filters

Filter Columns

If Datagrid tend to have a lot of columns, especially like SOQL Datagrid, app enables Filter Columns search input. Search term entered there will be used to find matching fields and show only those columns. See Search Term to understand how to specify the search term.

Search Term

Both while filtering Rows or Columns, you can enter a search term. While most of the time, you enter some text and show rows/columns that contain that text, app allows you do some advanced searches using some conventions as outlined below.

  • Search text must be more than a single char
  • Enter any text to filter records. Data is considered matched if any searchable column cell value contains the search term
  • Search term separated by space will be treated multiple sub-terms, which would be a data cell if both terms matches that cell. For ex., entering contact role would match OpportunityContactRole, ContactContactRole but not Contact or AccontRole
  • Special chars in the cell values are replaced with space, and each word in the cell value is matched against the search term
  • Enclose in quotes (single or double) to do the exact match. For ex., "Task" or 'Task'
  • Start with ^ to do starts with match. For ex., ^Account would match Account and AccountContactRole but not My_Account__c
  • Start with $ to do ends with match. For ex., $Account would match Account and My_Account but not AccountContactRole
  • Enter multiple search terms separated by comma (,) to show matches which matches any of the terms. For ex., entering Contact,Account would match Account, Contact, OpportunityContactRole etc.,

Row Grouping

Datagrid Row Grouping feature enables you to group the data, apply various aggregations to non-grouped columns and view the report. It also allows you to export the Group Summary for further consumption. See this video guide on how to use the feature and its capabilities.

Compare Values

Compare Values feature helps you compare any two cells in Datagrid. If cells you want to compare are adjacent, select those two cells, right-click in the cells, select Compare -> With Each Other to open the compare values dialog.

If cells are not-adjacent, you can copy one of the cell contents into clipboard and compare with the other cell via Compare -> With Clipboard

Export Records

All Data grids allow you to export data. To export Right-click on the datagrid -> Export Other -> <export option>. You can select the appropriate export option as per your needs.

Brobench supports exporting to the following formats.

  • CSV Files
  • Excel Files
  • Google Sheet

Copy Other

Essential

Copy Other feature allows you to copy Datagrid data in various other ways or change the source of the data. You can access this by right-clicking in datagrid and going to Copy Other menu item.

OptionWhereExample
Copy as SoqlObject Fields GridCopies the selected fields as SOQL
Copy as LWC ImportObject Fields GridCopies the selected fields as LWC Import
Copy as LWC Get RecordObject Fields GridCopies the selected fields as LWC Import and Get Record Code
Copy Executed QuerySoql DatagridCopies the executed query to clipboard
Copy as Apex InsertSoql DatagridCopies the selected rows/columns as Apex Insert script
Copy as Apex UpdateSoql DatagridCopies the selected rows/columns as Apex Update script
Copy as Apex DeleteSoql DatagridCopies the selected rows/columns as Apex Delete script
Copy as In Clause StringAll GridsCopies selected cells as In Clause compatible string which you can straight put into a where clause in a Soql
Copy as JsonAll GridsCopies selected rows/columns as Json Object
Copy as Json ArrayAll GridsCopies selected cells as Json Array
Copy as Text TableAll GridsCopies selected range as Text Table
Copy as MarkdownAll GridsCopies selected range as Text Table
Copy Header as CsvAll GridsCopies just the header names as csv string
Copy Selected (n) Columns as CsvAll GridsCopies selected columns as Csv data
Copy Selected (n) Range as CsvAll GridsCopies selected ranges (whatever is highlighted) as Csv data
Copy Selected (n) Records as CsvAll GridsCopies selected records as Csv data
Copy All (n) Records as CsvAll GridsCopies all records in the grid as Csv data

View Values

Essential

View Values feature enables you to view long text content in Records or from Debug Log in a separate dialog with the ability to search/filter/extract part of content with syntax coloring and formatting.


It can be launched from the following places.

  • Datagrid: Right-click on any single or range of cells and select View Values menu item
  • Debug Logs: Right-click on any text selection and select View Value or View Value as Json menu item

App will show the following dialog with content of the selection.