Table Settings
In MAF Cloud, you may come across AG-Grid tables which have several functions that you can utilise.
TABLE OF CONTENTS
General
You will be able to find context menus with certain user interactions. By hovering over the cell table's header, you will be able to find a button (represented by 3 horizontal lines) that allows you to access certain functions. To save the layout, please refer to Table Layout Settings.
Buttons | Name | Description | Interaction |
|---|---|---|---|
First Button (represented by 3 horizontal lines) | Pin Column | Pin selected column to the most left or right of the table, or reset the settings by selecting 'No Pin'. | |
Autosize This Column | Automatically resize the selected column to fit the information in the column. | | |
Autosize All Columns | Automatically resize all the columns in the table to fit the information in their respective columns. | | |
Group by... | Group information by the selected column. | | |
Un-Group by... | Un-group selected column to return to default table format. | | |
Reset Columns | Reset columns back to default. | | |
Regroup Columns | Regroup the column headers. | | |
Sort Dates | Sort columns by date. | | |
Second Button (represented by a filter funnel icon) | Filter by Row | Filter information by rows in the selected column by ticking the checkbox to customise information based on your needs. Once you filter your data, it will remain filtered whenever you return to the page, until you right-click/click on the 'Reset Filter' button | |
Second Button (represented by 4 vertical lines) | Filter by Column | Filter information by columns by ticking the checkbox to customise information based on your needs. | |
You will be able to group the rows by dragging the header names into the area (Drag here to set row groups).
For instance, you may drag PORTFOLIO NAME into the area and the trades will be grouped and displayed accordingly. All grouped rows on different levels will be shown in a different colour.
Right-Click in Table
By right-clicking anywhere in the table, you will be able to access the table's context menu to export data, reset layout, reset filters and expand/collapse data rows etc.
Name | Description |
|---|---|
Copy | Copy information in the table cell. |
Copy with Headers | Copy information in the table cell along with column header. |
Export | Export the entire table's information into .CSV, .xlsx or .xml format. |
Reset All Layout | Reset table layout to default. |
Reset Filter | Reset all of the table's filters. |
Expand All | Expand all grouped rows. |
Collapse All | Collapse all grouped rows. |
Date Filters
Date filters are available for any columns with dates (eg. 'CP/BL Date', 'Timebar Ref Date', 'Notification Timebar Date', 'Full Claim Timebar Date', 'Claim Date', 'Value Date', 'Last Updated' in 'Demurrage Claims Table' table).
There are 5 filters available:
"Equals to": Table will filter and display all the dates which are equal to the date you input
"Not equals to": Table will filter and display all the dates which are not equal to the date you input
"Lesser than": Table will filter and display all the dates which are earlier (lesser) than the date you input
"Greater than": Table will filter and display all the dates which are later (greater) than the date you input
"In range": Table will filter and display all the dates which are in the range of the 2 dates that you input. For example, if the 2 dates you input are "1 Jan 2020" and "10 Jan 2020", they will not be displayed (are not inclusive) and the table will only filter and display dates between "1 Jan 2020" and "10 Jan 2020", and exclude "1 Jan 2020" and "10 Jan 2020".