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.

Sort data

Sorting allows you to reorganize your data in ascending or descending order so you can understand and visualize it better. There are two ways to sort data in the platform.

To sort the data for a particular column, click the column header and select the required sorting option. If you want to sort the entire table, click the Sort option in the grid and then follow these steps:

  1. In the Sort box, click Add another sort.

  2. Choose the required property and select the display order (ascending or descending).

Filter data

Filters help you to narrow down data based on specific attributes. In the Marketplace Platform, you can use various filters to display only the information you need and hide all other data from the page.

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 instance, when ordering new items, you could 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.

Follow these steps to create filters:

  1. Click the Filter option in the grid.

  2. In the Filters box, click Add another condition and then define the conditions:

    1. Choose the required property.

    2. Select the condition, such as, equal, contains, starts with, and so on.

    3. Choose a value from the list of preconfigured values or type the keyword.

  3. If needed, click Add another condition to add another condition and combine those conditions using the AND or OR operators.

    • 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.

As you define filters, the data in the grid is refreshed automatically. If no data matches your filters, the platform displays a message.

Show or hide columns and adjust column width

The Columns selector allows you to show or hide specific columns from the table. Use the checkboxes to hide or display columns as needed. 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.

Change 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 in the lower-right corner of the grid.

If a table 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.

Last updated

SoftwareOne is a trademark of SoftwareOne, Inc. "The Software Licensing Experts" is a service mark of SoftwareOne, Inc. VAR assist is a trademark of SoftwareOne, Inc. "It pays to partner" is a service mark of SoftwareOne, Incorporated.