Sorting and filter

Introduction > Beas user interface > Window control > Templates > Template Administration > Edit templates > Sorting and filter

 Top  Previous  Next
Expand/Collapse Toggles

A new sorting/filter is available on SQL-level and on window level (DW). Click the orange arrow to transfer the current sorting/filter from the window. That means the list can be sorted clicking on the field header and then this setting can be read and transferred out as SQL- or DW-syntax.

 

NOTE: If you switch from a template with sorting to a template without sorting, the filter and sorting are not removed.

 

PATH: Open list window > right-click Beas logo in the bottom right corner > select "Template Administrate" > Open an entry > "Sorting and filter" tab.

Template_admin_SortingFilter_2022.09

Window system_template_edit_page1.psr

 

Field Descriptions

Field

Descriptions

Sorting

Yellow arrow: Clicking on it automatically copies the default sorting and filter definition of the window.

 

Enter/edit the SQL-fragment following the "ORDER"-statement of the  SQL-command

Example: Item list, sort item descending

OITM.ItemCode desc

 

Filter

Yellow arrow (right of the Sorting field): Clicking on it automatically copies the default filter definition of the window.

 

Enter/Edit the SQL-fragment following "WHERE"

Example: item list, only items beginning with A

substring(OITM.ItemCode,1,1)='A'

 

Sorting (DW)

Use this option if a sorting on SQL-level is not possible, e.g. if lists are filled using an object or if a SQL-statement was used with "union all"

Sorting is entered in DW-Syntax. See Datawindow-Syntax

 

Enter ascending sorting with "asc", descending with "desc". Field names are entered in the screen (see Debug-Fenster) and not the SQL-name

 

Example: sort item number descending, but items of item group "material" first.

if(oitm_u_gruppe='material',1,2) , oitm_itemcode desc

 

Filter (DW)

Sorting is entered in DW-Syntax. See Datawindow-Syntax

See notes above.

 
Help URL: https://help.beascloud.com/beas202402/index.html?sorting-and-filter.htm