Page History

The list interface includes the following elements:

1. Columns – names of columns of the current table. Click a column name to open the context menu. Change the columns set and order by clicking the gear icon Image Removed.
2. Funnel – click this icon to use the condition builder for filtering.
3. List Image Modified – click the icon to select the number is items diplayed per pageof items displayed per page. The number of records displayed by default is configured in the Preferences menu.
4. Gear icon  – click this icon to change the set and order of columns displayed.
5. Search boxes – click the magnifier icon to the left of column names to open the list search boxes. Here, enter the value that a column should contain to find certain records. You can also use the condition builder to filter records (click the funnel icon Image Removed).
6. List of records – records included in the table displayed in rows. You can select records using the checkboxes on the left to delete them or (in case it is a record picker) to select them for the list type field. By default, the records in lists are sorted by the ID column in descending order.
7. Information icon  – click this icon to see preview information about the record.
8. Cell – the column value of a certain record. You can change the value using inline editing.

Image Removed

You can edit field values of records in the list view. In other words, you do not need to open a record to change a field value.

To edit a field in the list view, follow these steps:

1. Double-click the cell containing the value you want to change.
2. Depending on the type of chosen column:
   • enter the value (text-like columns)
   • select value from the drop-down list (choice columns)
   • select a record from the dictionary by clicking the magnifier icon Image Removed (reference columns)
   • define the date and time by clicking the calendar icon Image Removed (date and time fields)
3. Click the check mark icon Image Removed to apply the changes (except for the choice-like columns).

Image Removed

Image Added

Configure the record number

To configure the number of records displayed in the lists, set the options in the simple.list.record_count_options.

To set the default number of record to be displayed in the lists, select the preferred option in the Number of records on lists field of the Preferences menu.

To set the number of record in specific lists, click Image Added and select the desired number of record to display per page. The selected user options will be saved in user preferences.

The list.pagination.enable_pages_calculation property enables the counting of items for pagination.

The list.per_page property allows you to customize the number of records for the list by default.

1. Navigate to System Properties → All Properties.
2. Find the property record you need using the list search boxes or the condition builder and open it.
3. In the Value field, enter the necessary value.
4. Click Save or Save and exit

If users do not have access rights to view some records, columns of Reference, List and Document ID types will display the Image Removedunavailable data text. 

If an ACL rule restricts access for the current user to the Display Name of a record, then the column will display the Image Removedunavailable title text. 

1. .

Configure inline editing

Anchor
configure inline editing configure inline editing

You can lock selected columns for editing to protect them from being changed, bypassing client scripts.

To lock columns for editing, follow these steps:

1. From the table form view, click Configure inline editing.
   
   A modal window appears.
   
2. Depending on your purpose, you can lock:
   • a single column: start typing in the input field and select an item from the auto-suggest list.
   • multiple columns:
     • click the magnifier icon Image Modified right to the input field. In the window that appears select the checkboxes corresponding to the columns you wish to lock and click Select items.
     • to remove a column from the input field, click the close button Image Modified on its badge.
   • all columns except for the selected ones: select Lock all columns except those specified below.
   • all columns: switch Lock all columns.

3. When all settings are done, click Apply.
   

   Note
   Unless Lock all columns is switched, you must fill in the Columns field to click Apply.

   
   

To revert the changes you have made, click Reset settings and click Reset in the dialog box that appears. The Reset settings button is only available if you made any configuration changes previously.

• Sort ascending – sorts records by the column value: from smallest to largest (including choices if they have numeric value), from A to Z, from earlier dates to later dates.
• Sort descending – sorts records by the column value: from largest to smallest (including choices if they have numeric value), from Z to A, from later dates to earlier dates.
• Group: {column} – divides records into groups by the selected column.

Tables can contain a lot of records, and it gets difficult to navigate through them and find the records you need. SimpleOne provides several ways to find, filter, group, and sort records.

List view provides three ways of searching and filtering records:

items in the column name context menu (to call it, click the column name)

items in the row context menu (to call it, right-click the cell)

Image Removed

Condition builder

Condition builder is a tool that allows for creating helps to create conditions to select fields with specific values and sort them in a particular order. 

It is available for the following elements:

• lists (click the funnel icon above the table)
• forms (conditionin Condition fields).
• record picker window (click the magnifier icon  by the reference fields)
• Related Lists area (click the funnel icon above the table).

To create filters, complete the following steps:

1. Click the funnel icon  to open the condition builder.
   
   Image Modified
2. Add dependencies complex conditions using the AND and OR buttons . Also, you can add high-level conditions using these buttons in the condition builder toolbar.
3. ClickRun to apply filters and get the selection of records.
   • You can also delete them by clicking theClear All button.

On lists and in dictionaries, you can find breadcrumbs by the funnel icon . They represent applied conditions:

See the Condition Builder article to learn more.

Search boxes appear above a table in the list view. To display them, click the magnifier button Image Removed at the right corner on the top of the list.

You can find the record you need by typing some characters, a word or several words. The search returns records that contain the specified input, that is, the condition equals:
[Column] contains [value]

Image Removed

Grouping on lists 

Anchor
grouping on lists grouping on lists

Grouping records on lists allows you to divide all records into groups basing on the defined column of any type. As the result, the list of records is divided into sublists. That is, records with the same value form a group with the corresponding heading. The function provides information on the number of records included.

Grouping is available only on lists. Records in related lists cannot be grouped.

To configure

Image Removed

For example, we need to group columns from the Columns (sys_db_column) table by the Column Type field. After configuring the grouping, the list will look like this:

Image Removed

the

number

of

groups

displayed on the page

, set the list

_groups.per_page

 property value.

To set up properties, follow the steps below:

1. Navigate to System Properties → All Properties.
2. Find the property record you need using the list search boxes or the condition builder and open it.
3. In the Value field, enter the necessary value.
4. Click Save or Save and Exit.

Create a report

Use the the title context menu by right-clicking the list titles and selecting one of the following options:

• Pie Chart – present data with the circular statistical graphics. See the Reports article to learn more.
• Bar Chart – present data with rectangular bars. See the Reports article to learn more.

Import and export

Use the title context menu by right-clicking the list titles and selecting one of the following options:

• Export Excel – export the list into an Excel file, to use it later for various purposes. Refer to See the Quick Export article for article to learn more information.
• Export to JSON – export the list view into a JSON-formatted file, to use it later for various purposes. Refer to the Quick Export article for more information.
• Import from JSON – import a JSON-formatted file, to insert records to the database directly. Refer to See the Quick Import article for to learn more information.