Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: Merged branch "DOC0000960" into parent

In SimpleOne, a list is the way to represent records. It consists of a number of elements and provides various ways to interact with records.

List The list interface includes the following elements:

  1. Columnscolumn names of columns of the current table. You can click on a column name to call open the context menu.
  2. Funnel Image Added – click this icon to use the condition builder for filtering.
  3. List Image Added – click the icon to select the number of 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 on the magnifier icon at to the left of the column names to open the list search boxes. Here, enter type the value which that a column should contain to find certain records. You Also, you can use the Condition Builder condition builder to filter records (click on the funnel icon ) as well.
  6. List of records – records included in the table are displayed in rows. You can select records using the checkboxes at the left to delete themTo delete a record, select the checkbox to the left of the record and click Delete in the top right corner.
  7. Information icon  – click on this icon to see preview the preview information about the record. 

    Info

    You can open a record from the preview form: click on the record information icon , and then click the Open record button.


  8. Cell – the column value of a certain record. To open a record form, click the first cell of the record on the list. You can change values of columns using the inline editing.

Image RemovedImage Added

Inline editing
Anchor
inline editing
inline editing


You can edit field values of records in the list view without opening a record form.

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

  1. Double-click on the cell containing the value you need to change.
  2. Depending on the chosen column:
    • enter the a new value.
    • select a value from the drop-down list.
    • select a record from the dictionary by clicking the magnifier icon .
    • define the date and time by clicking the calendar icon .
  3. Click the check mark icon to apply the changes.

Note
  • If you do not have access rights to view some records, the reference columns will display the unavailable data text. 
  • If ACL rules restrict access for you to the Display Name of a record, then the column will display the unavailable title text. 
  • If the referenced record is deleted, the column will display the record not found text.

Filtering
Anchor
filtering on column click
filtering on column click


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

Lists provide three The list interface provides four ways of searching and filtering records:

  • using the condition builder.
  • using the
  • Condition Builder
  • list search boxes.
  • using the following options from items in the column name context menu (to call open it, click on the column name).:

    Section


    Column


    Column
    • Sort ascending – sorts records by the column value: from the smallest to the largest, from A to Z, from earlier dates to later dates.
    • Sort descending – sorts records by the column value: from the largest to the smallest, from Z to A, from later dates to earlier dates.
    • Group: {column title} – divides records into groups by the selected column value.
    Info

    By default, the records in lists are sorted by the ID value in descending order.




  • items in using the following options from the row context menu (to call open it, right-click on the cell):

    Section


    Column


    Column


    Column
    • Show Matching – displays all records with the same column value.
    • Filter Out – sorts out all records with the same column value.
    • Group By – divides records into groups by the selected column value.




Condition

Builder

builder
Anchor
condition builder
condition builder


Condition Builder The condition builder is a tool that allows you to create conditions to select for selected fields with specific values and sort them in a particular order. To do thisso, complete the following steps:

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

Other available actions:

  • Sort – allows you to add conditions of for the field sorting.
  • Group – allows you to group the records by a specific column. 

  • Save – allows you to save the configured conditions. 

    Expand
    titleHow to save a filter
    1. Configure conditions you need.
    2. Enter Specify a name of the filter and click Save.
    3. The saved filter will be available in the hamburger menu Image Removed.To apply the filter, navigate to the hamburger menu, click Filter,and select the option with the desired filter name.condition builder field that is near the Group UI-action.


  • Close – hides the condition builder
  • Run runs the configured condition to apply the filter.

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

Tip

To clear filters of the

Condition Builder

condition builder:

    • click
  1. on
    • the arrow iconImage Modified to clear
  2. one
    • a condition
  3. at
    • to the right of the arrow.
    • click
  4. on the
    • a condition to clear all conditions except the selected one.Image Modified
  5. To add

To add a list filter to the Favoritesmenu, drag

and drop

the breadcrumbs to the Favorites navigation tab.

List search


Search boxes
Anchor
search boxes
search boxes


Search boxes appear above a table in the list view. To display them, click the magnifier icon at in the right left corner at 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. The condition equals to[Column] contains [value]and will be displayed in breadcrumbs.

Grouping on lists
Anchor
grouping on lists
grouping on lists


Grouping By grouping records on lists allows you to that appear on the list, you can divide all records into groups based on the defined column values. As the a 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.

To configure the grouping, click on the column title on the basis of which you need to group the records , then choose by and click Group: {column name}.

For example, you need to group reports from the Reports (sys_reports) table by the Type field. After configuring the grouping, the list will look like thislooks the following way:

In the list view, the following options are available to operate the groups are available:

  • Expand and collapse any group. To do itso, click on the group you need to.
  • Expand and collapse all groups. Open the context menu by clicking on one of the column titles or right-click clicking any line in on the list, and select the Expand all groups or Collapse all groups option in the context menu.
  • Sort groups in ascending or descending order by the group name or the number of records in it. Open the context menu by clicking on one of the column titles or right-click clicking any line in on the list and select the corresponding option.
  • Change the base column of grouping. To regroup records based on another column, click on the column title you need and select Regroup: {column name} in the context menu.
  • Open a group in a distinct list view. Point to the group you want to open and select Open a group in the list.
  • Ungroup them. To do itso, open a the context menu by clicking on one of the column titles or right-click clicking any line in on the list , and select the Ungroup option in the context menu.

Create reports

You can create reports directly in lists a report directly from a list without going to another menu category. Open the title context menu by clicking on the a column titles title and selecting one of the following options:

  • Open Pie Chartpresents data with represents data in the form of a circular statistical graphicsgraph. See the Reporting Reports article to learn more.
  • Open Bar Chart – presents data with – represents data in the form of rectangular bars.  See See the Reporting Reports article to learn more.

Configure personal list layout
Anchor
personal layout
personal layout


In SimpleOne, y
ou can configure your personal list layout: choose columns to appear in on the list and define their order.

To do thisso, click on the gear icongearbox.pngat to the top left of the list.

The Available layout area contains all table columns that can be added to the list. To add them, move them to the Selected layout area. Move elements by drag-and-dropping dragging them or using the the  and  buttons.

  • To remove or add all the columns, click the    or  buttons button.
  • To move several elements in a row, select them with the Shift key pressed and drag -and-drop from them from the Available layout area to the Selected one.
  • To move several scattered elements at once, select them with the Ctrl key pressed and drag -and-drop from them from the Available layout area to the Selected one.

List views


All created list views are available in the hamburger menu → View. In On this menu, select the view you need to set it as default.

Table of Contents
absoluteUrltrue
classfixedPosition
printablefalse