Solution Development
Breadcrumbs

Curation - Simple Datatable

Intended audience: end-users analysts developers administrators

AO Platform: 4.4

Overview

This section offers an overview of the Simple Datatable. The Simple DataTable provides a clean and effective way to display tabular data, with options for sorting and filtering to help users explore simpler datasets efficiently.

Example

image-20241216-120417.png


Configuration of Simple Datatable

image-20251111-135438.png
image-20251111-173210.png
image-20251111-135316.png

DATA Properties

Label

UI Widget

Default

Description

  • Columns 

Dropdown w/Expression and Additional Properties

 

The Column dropdown allows the user to select one or more MSO Field Properties to be included in the Simple Datatable App.

Column Properties

 

 

 

  • Display Name

Text Field

 

The Display Name field displays the name.

  • Value Format JS

Text Field w/Search

 

The Value Format JS in a Simple Datatable allows users to apply custom JavaScript code to format the values displayed in the table.

  • Cell Template JS

Test Field w/Search

 

The Cell Template JS allows users to customize the appearance and content of individual cells in a Simple Datatable using JavaScript.

  • Header Alignment

Dropdown

Auto

Select Alignment for Header, including Auto, Left, Center, or Right.

  • Alignment

Dropdown

Auto

Select Alignment for Column content, including Auto, Left, Center, or Right.

  • Adjust Width

Dropdown

Auto

Select how to Adjust Width, including Auto, By Pixels, or By Percentage.

  • Width in Pixels

Number Field

100

Enter the number of pixels for the Column Width. This property is only visible if the Adjust Width property value is By Pixels.

  • Wrap Text

ON/OFF Toggle

OFF

If enabled, the row height in the table will be based on the available text.

  • Hide Column

ON/OFF Toggle

OFF

If enabled, the table column will not show in the app.

  • Additional Properties

Key / Value - Text Fields

 

Optional Additional Properties - expressed as a Key/Value pair.

  • Column Display Order 

 

 

The Column Display Order allows the user to select the display order for one or more selected MSO field properties.

  • Auto Curate

ON/OFF Toggle

ON

The Auto Curate Toggle allows the user to enable or disable automated data curation for a dataset. When enabled, the system applies predefined rules and logic to automatically process and organize the data. When disabled, users have full control and can manually curate the dataset.

  • Show Vertical Gridlines

ON/OFF Toggle

OFF


  • Max Number of Records

Number Field


Enter the maximum number of records to include in the App.

  • Sort By Field 

Dropdown

 

The Sory By Field option allows the user to select a field to sort the data and also provides the flexibility to define a custom expression for more advanced sorting criteria.

  • Sort Direction 

Dropdown

 

Option to set the Sort order for data in the chart to either Ascending or Descending.

  • Apply When Shown from a Connected MSO

ON/OFF Toggle

OFF

If enabled, the data will be shown if it comes from a Connected MSO. If disabled, the curation will be suppressed.

  • Apply Curation Data Size Rules for the App Data

ON/OFF Toggle

OFF

If enabled, the Record Count rules will be applied. If the Record Count rules are not met, the series will not be shown.

  • Additional Properties

Key / Value - Text Fields

 

Optional Additional Properties - expressed as a Key/Value pair.

PAGINATION Properties

Label

UI Widget

Default

Description

  • Enable Pagination

ON/OFF Toggle

ON

If enabled, page numbers will be added as links below the table App
instead of allowing the table records to be scrolled vertically.

  • Pagination Type

Dropdown

Auto

Select from available options, including Auto or Custom. If Custom, the number of records to be shown per page can be added in the Page Size property.

  • Page Size

Number Field

10

Enter the number of records that will be shown in the table per “page”.

  • Add Empty Column

ON/OFF Toggle

OFF

If enabled, an extra empty column will be added as the last column of a table. This is useful if only a few columns are shown in a table in order to push columns with values closer together.








Contact App Orchid | Disclaimer