#23470 Grid: merging filter and sort buttons in column header

Enhancement

Critical

#22685

PostgreSQL support

#23383

Form Editor

#23471

Context menu

#23854

Theme editor

#24071

Theme "discreet

#24085

Create new views in the application

#24188

TL Script Editor with Context Help

#24863

Model export to the development environment

#24926

JavaDoc for Top-Logic

#24936

Translation service

Major

#23468

Grid: Unification of selection behavior

#23469

File upload via drag&drop directly from the client's file system

#23470

Grid: merging filter and sort buttons in column header

#23681

Tables: Evaluation row

#23912

Control rendering via templates

#23962

XML editor with syntax highlighting

#24044

Replace hardcoded icon references with theme variables

#24122

Create ConfigurationDescriptor from XML file

#24158

Themes export and import

#24255

Allow sending emails that have recipients only in CC or BCC

#24375

Simplify the "Document lock" function.

#24377

Comment field for documents

#24378

Persistence of settings in selection dialogs

#24461

Optimized Jetty Startup in the IDE

#24464

Simplified layout templates with calculated alias variables

#24499

TL script: Count function

#24540

Create values for composite attributes inline

#24620

Migration: Rewriter that transforms attribute with XSL

#24679

Representation of foreign objects in BPE

#24701

Transferring specialist definitions to BPE Ex/Importer

#24728

Optionally inherit type default from attribute annotations

#24729

Set model annotations to table definitions

#24733

Internationalizable log messages

#24757

Typed configuration: allow properties with ValueFormat and ValueBinding simultaneously

#24760

Enter translations for `ResKey`s in declarative forms

#24888

Exact version information on the monitor page

#24905

New login page

#24997

Automatic data migration for newly created tables

Detail

#23917

Parameterize renderer

#23919

Generalize Config Item Templates to Rendering Templates

#23969

LockStrategy for Interfaces

#23970

BreadcrumbComponent

#23973

Upload binary data in declarative forms

#24024

Theme configurations in a separate file

#24167

Dialog for creating multiple ConfigurationItems

#24196

Update Jetty to 9.4.22

#24200

Use model factory with default name without factory annotation

#24210

Upload option of fonts in theme editor

#24318

GUI assertion FormField#isMandatory()

#24319

Configurative "Mandatory" Override for Properties in Declarative Forms

#24367

Typed configuration: serialize BinaryData properties by default

#24373

Script recorder - export/import of templates

#24374

Script Recorder: Make "Select Server Script" hideable.

#24376

Make TLKafkaProducer extensible.

#24407

Layout refactoring: restructure (admin) layouts so that .layout.xml and component XML are adjacent

#24410

MigrationProcessor for deleting the saved application model

#24419

Multiple inheritance for themes

#24457

External module for PostgreSQL driver

#24492

Using TL Script Editor for Script Attributes and Properties

#24494

Annotate width of text field at model attribute

#24495

Title for table definitions in workflow steps

#24503

Possibility to open an editor in dialogs in edit mode

#24516

Display of non-process attributes

#24521

General layout option: resetInvisible

#24524

No points in environment variables

#24535

GenericObject as default database table

#24537

Service inspection

#24538

remove loginscreen.png in POS

#24548

Configurable exception lists in EditAttributedComponent

#24552

Grid: Deselection with Ctrl-Click

#24561

Automatic text wrapping for long lines for the code editor

#24567

TL-Script expression to evaluate a dynamic attribute

#24569

LabelProvider by expression

#24570

Main properties for MetaAttributes table

#24580

Customization of grid layouts in the Element module

#24581

ShowSystemEnvironment.jsp: Alphabetical sorting.

#24584

Remove hard icon reference in grid.xml

#24588

Use of labels of subject objects in messages

#24590

BPE: Unify task transition error text and condition

#24656

Display of "_self" column in FormEditor table

#24672

Display of a static HTML in the form editor

#24673

Enable "Standard" Links in WYSIWYG Editor

#24692

Migration: Enable version downgrade

#24697

Directory (LDAP) Account Sync without explicit group access

#24703

Scripting: ModelNamingScheme for the selection of selectables

#24715

Dealing with large file sizes during uploads through file drops

#24716

FileDropHandler: Improve error messages

#24718

Improving the completion of a task

#24744

Dynamic dialog titles

#24745

Missing JSP attribute "wholeLine" for basic:fieldset

#24747

Macro as GUI element in the form editor

#24755

Introduce feature sets in StructuredTextConfigService

#24756

Typed configuration: no error when accessing mandatory properties that are not set

#24758

ResKey: Optional key for literal `ResKey`s, better XML format

#24765

com.top_logic.layout.form.template.model.Template for HTML code

#24768

Make FormEditor dialog in a programmatic dialog

#24803

Better positioning of administration components

#24813

Display hidden attributes in shape editor

#24816

MediaQueryControl should be LayoutControlAdapter

#24853

Dynamically adjust the number of lines to the content of the code editor

#24856

Enhanced API for TypedAnnotatable

#24869

Specify a reason if lines cannot be removed

#24873

Typed configuration: use short cut format for item-value properties for serialization

#24884

Update Font Awesome to version 5.13.0

#24895

Focus tables

#24902

PropertyEditor for TLFormDefinition

#24906

FormBuilder for a type using the implicit FormDefinition.

#24913

Offer forms of super types as templates to extend

#24916

Buttons to reset the form

#24925

Provide checkAll to FormContainer

#24928

Be able to prevent recording of all actions in the dialog

#24932

Save layout back to file system

#24982

Assertion on the error text of a FormField

#24999

Treat deploy aspects like "normal" web apps

#25012

Show Teminplan in Tile Demo

#25013

#25027

Scripting of creation of new views

#25039

Display of the messages of an exception in the info service

#25040

Better error behavior if layout configuration is invalid

#25041

Declarative configuration shall extend programmatic

#25044

Differentiation between active and disabled buttons in the "modern" header

#25055

BinaryDataFactory: Create BinaryData from InputStream and name

#25067

Info type display without icon and header in info service

#25081

DefaultProvider via expression

#25083

Special group "Other attributes" in the shape editor

Nice to have

#23964

Abstract base class for ControlProvider for FormMember

#23979

TableData: getOwner() to be included in the API

#24195

ConfigurationItem for internationalized texts without description

#24197

TL-Sync: Set Kafka bootstrap servers via Java property

#24209

Replace hover classes loaded by javascript with hover pseudo classes

#24282

Typed configuration: utility for parsing with custom root tag

#24286

Utility to integrate Maven dependencies into a TL module

#24313

Assertion for selection in TreeTableComponent

#24340

Set default encoding of files in the project

#24485

Dump JSP into the standard maintenance pages

#24504

Remove static SQL statements, instead route dynamically via DBHelper

#24575

Wrapper generation for multiple modules

#24613

Service method for creating a SortConfig

#24750

TL-Script Macros: Allow dynamic content in protected attributes (SafeHTML)

Bugfix

Critical

#24984

Incorrect AssociationCache update in commit

Major

#24380

Configured resource provider is not found for historical objects

#24452

Possible infinite loop in AbstractKBCache

#24695

Structure editor: Different line height Flex vs Fix

#24721

Tree table renders checkboxes for all nodes

#24854

Incorrect dialog name in POSDelegateStructureHTMLTree

#24977

User can no longer create bookmark links

Detail

#23952

Mandatory attributes cannot be (temporarily) set to zero

#23955

Order of buttons in *SelectorContext not consistent with the rest

#23997

Session service logs only the Apache facade address

#24152

Burger menu rendering error

#24169

Removal of unnecessary inline styles

#24241

Add missing ThemeVariables

#24302

RiskItemFactory: Switch to typed configuration

#24346

Typed configuration: U.u. Incorrect "Outer" reference resolution

#24359

Time-dependent test in Project Demo

#24397

The callback URL configuration of the Pac4jConfigFactory does not serve as a fallback for the client configuration

#24412

Tooltips of non-executable commands in the burger menu are not displayed

#24490

Missing authorization for new workflow version

#24505

Saving script templates in the Script Recorder not possible

#24514

TLScript code completion plugin does not work in Internet Explorer

#24551

GUI Inspector dialog no longer opens for buttons

#24553

Table text filter count empty entries

#24558

Incorrect export/import of ScriptRecorderTemplates

#24619

Migration: Model update may delete attributes if their type changes

#24644

Upload of a document version via drag & drop without lock not possible

#24648

TL Script Editor: code block in the description of a completion not on one line in IE

#24669

Font Awesome is missing from the third-party libraries table

#24677

Unwanted margin in the Gantt page bar

#24680

Tree-Table: Selection is lost when collapsed

#24684

Swap order jsDiagram / Themes Modern in CP

#24696

Advanced search form for wide

#24698

Unwanted line break when displaying a URL

#24704

Inactive create button of a grid is too bright in sidebar theme

#24759

Change log configuration in the application no longer possible

#24764

LabelProvider for BinaryData objects

#24769

More errors in reactive forms

#24775

FileDropHandler: waitPane sometimes does not disappear

#24785

Maxmiert property with dialogs is lost

#24862

Incorrect filtering in tree tables with non-existing attributes

#24872

Update problem company detail view

#24901

Warnings in the log for layout files

#24917

Use `config-type` configured on attributes for ColumnConfiguration

#24939

Check-Changed on selection in BPMN diagram

#24950

Label column in token table does not exist

#24959

Webfolder is rendered too small

#24965

Committee tests fail if they are executed at certain times of the day

#24974

TopLogicServlet must not redirect to login in case of errors

#24987

Erroneous update of KBCache's

#24988

New document description is not displayed in other WebFolder views

#25005

Double button in the sidebar

#25007

Changes to the edited BPMN diagram can be lost

#25009

Wrong model update when switching to edit mode

#25010

BPE Process Editor does not save "Automatic" setting for branches correctly

#25014

ModuleLayout does not resolve workspace directory properly

#25028

Dialogs of external windows are displayed in the main window

#25048

ThemeVariables of the layout are not resolved correctly

#25056

Too many buttons in sidebar layout

#25059

NullPointer during drag'n'drop of selected ApplicationAction

#25061

ReplayHistory does not find its control on fast PageReload

Nice to have

#24647

Unnecessary import in SubtypesProvider

Administration

Detail

#25036

Optimization Memory Virtual Machines

Enhancement (User-visible)

Major

#23470

Grid: merging filter and sort buttons in column header

Code migration TableFilterSort

Instead of calling up filtering and sorting via two separate icons, sorting is to be included in the filter dialog in order to save space in the column headers - analogous to Excel. However, it should still be possible to deactivate sorting in a view of the application.

Improvement

The commands for sorting are now in the same dialog as the filter options and are displayed similar to a context menu. If the column is already sorted, the corresponding entry is highlighted. The dialog closes as soon as a sort is selected. \ \\ The icon to open the dialog changes depending on the state. It shows the current sorting state and also the filter state, as well as whether sorting or filtering is possible at all: \ \

Application

A BlockControl with the corresponding SortCommands is passed to PopupFilterDialogBuilder.createFilterDialogContent(TableFilterModel, DisplayContext, FormContext, BlockControl) to render it into the filter dialog. If BlockControl is null only the filter options are displayed in the dialog and the column is not filterable. \\ If a column is exclusively sortable, no dialog is created with the PopupFilterDialogBuilder, but a custom PopupDialogControl is created using the TableControl.OpenSortDialogAction.\.

By default, the filter and sort icons are Fontawesome icons whose color is based on the current font color. It can be adjusted with color in CSS. The following icons must be overridden in the theme-settings if changes are desired:

Column is sortable: com.top_logic.layout.table.renderer.Icons.SORTABLE
Column is sorted in descending order (not filterable): com.top_logic.layout.table.renderer.Icons.SORT_DESC
Column is sorted in ascending order (not filterable): com.top_logic.layout.table.renderer.Icons.SORT_ASC
Column is sorted in ascending order (filterable): com.top_logic.layout.table.renderer.Icons.SORT_ASC_SMALL
Column is sorted in descending order (filterable):com.top_logic.layout.table.renderer.Icons.SORT_DESC_SMALL
Icon for filter: com.top_logic.layout.table.renderer.Icons.FILTER

Also, FILTER_SORT_DIALOG_SORT_STATE can be overridden to change the color in which the current sort state is displayed in the dialog.\ The icons now have tooltips that indicate what they are doing and also indicate the current sort state (if sorted).\ Whether a column is sortable and/or filterable can be configured as before as well.

{{#!xml <column name="filterable column"

sortable="false"

/> <column name="sortable column"

filterProvider=""

/> <column name="not sortable or filterable column"

filterProvider=""
sortable="false"

/> <column name="sortable or filterable column"

<-- No specification required -->

/> }}}

Test

A table with all configurable columns and corresponding icons can be found at Technical Demo > Layout-Framework#1 > Tables > Filter and Sort-Icons. There you can check all states of the icon including the tooltips and also test their functions.

Code Migration

The following functions have got a new signature and have to be adapted:

TableControl.getFilterActivateElementID(String) became TableControl.getColumnActivateElementID(String)
DefaultTableRenderer.writeFilterTag(DisplayContext, TagWriter, RenderState, int) became DefaultTableRenderer.writeFilterSortTag(DisplayContext, TagWriter, RenderState, int)
CellRef.filterButtonId() became CellRef.sortFilterButtonId()
FilterDialogBuilder.createFilterDialogContent(TableFilterModel, DisplayContext, FormContext, Optional<BlockControl>) and the PopupFilterDialogBuilder and DummyFilterDialogBuilder implementations now also get an Optional<BlockControl> for the SortCommands. Can be empty, then no SortCommands are inserted and only a filter dialog is built.
TableFilter.openFilterDialog(DisplayContext, PopupHandler, Optional<BlockControl>) has also received an Optional<BlockControl> that can be empty (in which case no SortCommands are added).
DefaultTableRenderer.writeSortImage(DisplayContext, TagWriter, ThemeImage, String, String) now gets instead of TableControl, column index and two Boolean values a string with a CSS class to be used and a string with tooltip for the icon.