Datatable - further development and features

[marekmru]

Datatable Features

• persist settings

  • Sorting the columns
  • Visibility of the columns
  • Dense true false.
  • Elements per page
  • (column width)
  • ...

• lambda

• Advanced options

  • maximize
  • reset
  • dense
  • sorting of columns
  • visibility of columns

• Search

  • optional: search : true|false
  • not all datatables need a search
  • is executed from the backend

• no-wrap

  • the BE sends a no_wrap attribute for each column, the frontend deactivates the breaks for each column using CSS. Example: columns : [{ no_wrap; true, width: 320, hide: false, click: false, key: false, format: "{}",... }]

• Additional footer

  • Example:
  • sum line (not now)
  • Information about Datatable

• Header, Footer, Advanced Hide / Show Options (default)

• Individual formats for Datatable cells

  • bold
  • italic
  • color
  • ...

• Datatable actions Suggestion: Key-Value pairs of material-icons icon and Ajax endpoint. When clicking on an action, the frontend collects the id of the element and attaches it to the Api endpoint. Example: actions: [{ icon: remove method: DELETE, endpoint: '/aqis4/api/v2/placements' }, { icon: open_in_new method: GET, endpoint: '/aqis4/api/v2/placements' }]

  Click delete => DELETE /aqis4/api/v2/placements/781030 //TODO: What happens with UPDATE

• Column width user-defined / individualized

  • Variant 1: BE defines a width within the headers for individual or all columns. Example: columns : [{ width: 320, hide: false, click: false, key: false, format: "{}",... }]
  • Variant 2: The user can change the column size by drag&drop; the setting is persisted.

• Raw HTML

  • Instead of a string, the BE sends HTML; the frontend renders the HTML

• locale

  • is set to file zero by the frontend. Example: { 'data_loading': 'Data is loaded ...', advanced_options': 'Advanced settings', 'show': 'Show', drag_drop_column': 'Sorting the columns (Drag&Drop)', itemsPerPageAllText': 'All', itemsPerPageText': 'Elements per page'. }

[m-rau]

on persistence see #125

[m-rau]

how about export? We discussed this!?

[m-rau]

can we close this ticket?

[OlhaTodorashko]

No, not everything was done.

Still open issues:

• lambda
• Individual formats for Datatable cells
• Datatable actions
• Column width user-defined / individualized
• Raw HTML
• locale

[marekmru]

Open Issue:

• create installable vue plugin