3/29/2024 0 Comments Type and grid![]() These filters are specific to each interface component that pulls in the record data. You can easily filter this data by configuring one or more filter conditions. When you select a record type as the source of your grid, your grid will automatically populate with the data used in your record list. If you're using a data store entity to return your grid data, you can use a!queryEntity() or a!queryLogicalExpression() to configure an expression with a list of filters. Filter related records from a one-to-many relationship.If you use a record type as the source of your grid, you can: There are a few ways to filter the data in your grid depending on your source. Learn more about using the fields parameter in a!recordData(). If someone other than a manager views the grid, then a different set of fields will be queried.Ī!recordData ( recordType: recordType!Case, fields: if ( local!managers, ) ) Then, you can write an expression using conditional logic (like the if() or a!match function) to specify when certain fields should be queried.įor example, the following expression will only query certain fields when a manager views the grid. To configure the fields parameter of a!recordData(), click FIELDS in the grid's component configuration. To alter this default behavior, you can specify when the grid should query the fields in your columns using the fields parameter in a!recordData(). Even when columns are hidden from the grid, those fields will still be queried since they're specified in the columns parameter of the grid. This default behavior can potentially impact performance if your grid includes dynamic behavior since it may result in querying more data than necessary.įor example, let's say you configured the showWhen parameter on the columns in your grid so that certain columns only appear to managers. Fieldsīy default, a grid will query and display all the data specified in the columns, pagingSaveInto, and selectionSaveInto parameters. See Using the backgroundColor parameter for more information about conditionally formatting background colors. You can choose background colors to customize the overall look of your grid, or use conditional formatting so the background color of each cell depends on the cell's value. Background colors are configured on each column individually, so make sure to update all of the columns in your grid as needed. You can choose the background color for each column. In the grid's Data ( data) parameter, you can choose one of the following data sources to power your grid: Data SourceĪ query to a data store entity generated by the query editor.Ī rule input or local variable defined in that interface that returns an array of data or a list of dictionary.Īn expression defined directly in the read-only grid. The sections below provide more details around each step in building a quick grid. Adjust the column spacing, height, and border style in the STYLING section.Configure the grid's page and sort options in the PAGING & SORTING section.Click ADD USER FILTERS to allow users to filter the data displayed in the grid.Click FILTER RECORDS or FILTER RELATED RECORDS to filter the data displayed in the grid.Click ADD COLUMNS to add any additional columns to the grid.Enter the name of the record type you want to use as the grid's data source in the Search record types field.Leave the default Data Source selection as a Record Type.Drag the READ-ONLY GRID component from the COMPONENT PALETTE onto your interface.The basic workflow for creating a quick and easy read-only grid is: You can quickly create a grid in design mode by selecting a record type as the data source. This is why these grids are often referred to as records-powered grids. ![]() The grid will even populate with your record list configuration by default, allowing you to build your grid faster. In addition, when you use a record type as the grid's data source, you can bring in records-specific components, like record actions and user filters. The grid can display data in various formats, provide advanced filtering, paging, and sorting options, allow row selection, and pass record data to other components in the interface. The read-only grid component is a modern interface component that is designed to handle your data intelligently. Data returned from querying a database table.Record data returned from a record type.The read-only grid component can be used to display the following types of data: Grids are how we display data in a tabular format. This page explains the main elements of the read-only grid, and how to configure them. Eager to get started with the new grid? Check out the Grid Tutorial for the fastest and easiest way to create a read-only grid. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |