# Customize the data grid The Marketplace Platform uses data grids to display data. A data grid is a table with rows and columns, and it contains several operations that allow you to customize the display of information. You can sort and filter data, show or hide columns, adjust the column width, change the default rows per page, and more. This topic describes each of these tasks.

Use the data grid to view data in a structured way.

### Sorting data Sorting enables you to reorganize your data in ascending or descending order so you can understand and visualize it better. There are two ways to use the sort function in the grid. **Sort a single column** You can sort the data for a column by selecting the column header. When you select the header, the preconfigured sort options are displayed. You can choose any option from the list.

Use the available options to sort a single column.

**Sort multiple columns** If you want to apply multiple sorts, select<svg xmlns="http://www.w3.org/2000/svg" height="24px" viewBox="0 -960 960 960" width="24px" fill="#5f6368"><path d="M320-440v-287L217-624l-57-56 200-200 200 200-57 56-103-103v287h-80ZM600-80 400-280l57-56 103 103v-287h80v287l103-103 57 56L600-80Z"/></svg>**Sort** in the grid and then follow these steps: 1. In the **Sort** box, select **Add another sort**. 2. Choose the required property and select the display order (**Ascending** or **Descending**). To add another sorting rule, select **Add another sort**. You can add multiple rules. 3. Select **Close**. All columns that have sort conditions applied are highlighted in the table.

Sort multiple columns.

### Filtering data Filters help you narrow down data based on specific attributes. Depending on the type of data you are searching for, you can use a single filter or create multiple filters using different conditions and **AND/OR** operators. For example, when ordering new items, you can create a filter to show only the items with a specific name. Similarly, if you have multiple subscriptions, you could use the **AND/OR** operators to view subscriptions that are active AND have auto-renewal enabled. You can also use the **Search Query** filter to enter a search term to find matching records within other filter conditions, such as orders, agreements, and more. Additionally, you can use the second-level filter condition called **Add a conditional group** to build advanced filters by combining multiple rules and conditions.

Apply filter to easily find the data.

To start filtering data: 1. Select the <svg xmlns="http://www.w3.org/2000/svg" height="24px" viewBox="0 -960 960 960" width="24px" fill="#5f6368"><path d="M400-240v-80h160v80H400ZM240-440v-80h480v80H240ZM120-640v-80h720v80H120Z"/></svg>**Filter** option. 2. In the **Filters** box, do the following as necessary: * Enter the **search query** to find records matching a specific keyword or select a predefined property from the list (for example, Buyer name). * To add another condition and combine those conditions using the **And** or **Or** operators, select **Add another condition**. Then, define conditions as follows: 1. Select the desired **And** or **OR** operator. * **And** - If you select this operator, the results are displayed only if both conditions are met. * **Or** - If you select this operator, only one of the conditions needs to be met for the results to be displayed. 2. Choose the required property. 3. Select the condition, such as equal, contains, starts with, and so on. 4. Choose a value from the list of preconfigured values or type the keyword. * To add another condition, select **Add another condition** and define conditions as needed. * To add a conditional action, select **Add a conditional group** and use the dropdowns to select the criteria. If you want to add another condition within the same group, select **Add another condition**. As you define filters, the data in the grid refreshes automatically. If the platform is unable to find any data matching the filters, it displays a message. ### Managing columns **Show or hide columns** The <svg xmlns="http://www.w3.org/2000/svg" height="24px" viewBox="0 -960 960 960" width="24px" fill="#5f6368"><path d="M121-280v-400q0-33 23.5-56.5T201-760h559q33 0 56.5 23.5T840-680v400q0 33-23.5 56.5T760-200H201q-33 0-56.5-23.5T121-280Zm79 0h133v-400H200v400Zm213 0h133v-400H413v400Zm213 0h133v-400H626v400Z"/></svg>**Columns** selector in the data grid lets you show or hide a column. Using this option, you can view only the information you need and hide other columns from the page. You can use the checkbox next to each column name to hide or display a column. If you have hidden a column, you can make it visible again by selecting the same checkbox. Note that some columns are shown by default, and you cannot hide them.

Use the Columns selector to show oe hide columns.

**Adjust column widths** The **Columns** selector also contains options to adjust the column width. These options include: * **Default size** - This option resets each column in the table to its default size. You can use this option if you've made adjustments and want to return all columns to their original state. * **Fit to content** - This option resizes each column in the table to fit its specific content. It means that the width is adjusted to the content within the column. * **Fit to screen** - This option resizes each column to make the entire table fit your screen. ### Refreshing data If the data in the grid has changed, you can refresh the data to make sure you are working with the latest data at all times. Use the <svg xmlns="http://www.w3.org/2000/svg" height="24px" viewBox="0 -960 960 960" width="24px" fill="#5f6368"><path d="M121-280v-400q0-33 23.5-56.5T201-760h559q33 0 56.5 23.5T840-680v400q0 33-23.5 56.5T760-200H201q-33 0-56.5-23.5T121-280Zm79 0h133v-400H200v400Zm213 0h133v-400H413v400Zm213 0h133v-400H626v400Z"/></svg>**Refresh** option to fetch the latest data from the system.

Use the Refresh option to manually refresh the table.

### Changing default rows per page By default, the Marketplace Platform displays 10 rows of data on a page. You can change the default value by selecting another value from the **Rows per page** option on the lower-right side of the grid. You can choose to show 5, 10, 25, 50, or 100 rows per page.

Change the number of rows displayed on the page.

### Navigating between pages If the grid contains several rows, the rows are split into pages, and page numbers are displayed on the lower-left side of the table. You can view the page number you are currently on and navigate between pages using the **Next** and **Previous** options. You can also go to a page directly by entering the number in the **Page** field and pressing **Enter**.

Navigate to different pages within the table.

--- # Agent Instructions: Querying This Documentation If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question. Perform an HTTP GET request on the current page URL with the `ask` query parameter: ``` GET https://docs.platform.softwareone.com/marketplace-platform/platform-overview/preferences-and-settings/customize-the-data-grid.md?ask= ``` The question should be specific, self-contained, and written in natural language. The response will contain a direct answer to the question and relevant excerpts and sources from the documentation. Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.