The two dimension table view widget would show a list of objects (entity A) in a tile view. The vertical dimension of the widget references a different object (* to 1 entity B) and the horizontal dimension of the widget references another object (* to 1 entity C). The developer would be able to manipulate the contents of the table cells (objects of entity A) as well as the row headers (objects of entity B) and column headers (objects of entity C).
Let’s take an example
- we have a company that operates in different countries (entity B stores country information)
- the company offers different products to the market (entity C stores product information)
- the company now wants to visualize sales volume (entity A) for each country and product
How the developer would use the widget
- widget is dropped on page
- developer needs to connect entity A to the table cells, entity B (by association) to the row header and entity C (by association) to the column header
- developer is able to manipulate and define the UI of the table cell, row header and column header using mendix widgets
- the end user can see Country.Name on the vertical axis (row header)
- the end user can see Product.Name on the horizontal axis (column header)
- the end user can see Sales.Volume on each cell
The widget would then offer out-of-the-box functionality like searching, sorting, on-click events, etc.