Advanced Settings of the Entity Table widget allows:
To enter the Advanced mode and start adjusting the settings above, you should start by clicking on the Pencil icon (“Enter edit mode”) at the bottom right of the screen:
After, click on the Pencil icon (“Edit widget”) at the upper right corner of the Entity Table widget itself:
Then, go to the Advanced cell:
ThingsBoard doesn’t have any restrictions associated with the name, both in symbols and character limit. Nevertheless, in case the title is too long, it won’t be shown completely on the Entity Table widget, but it will be finished with the three dots. However, after applying the changes and opening the widget in fullscreen mode, you will be able to see the full name of the widget. For example let’s use something simple for the title like “The Name of the Widget”.
After clicking on the orange checkmark in the upper right corner, the changed title will become visible.
These checkboxes allow you to customize the ability to search entities in the widget as well as the ability to select the columns you want to display, and the display of an entity name column.
You can change the title of the Column by inputting the text for it in the appropriate line:
After clicking on the orange checkmark in the upper right corner, the changed Column Title will be seen.
When the checkbox “Display entity label column” is checked, you are receiving an opportunity to add the label column and name it.
After clicking on the orange checkmark in the upper right corner, the label column with the custom name will appear in the widget.
The checkbox “Displaying entity type column” is responsible for appearing/hiding the appropriate column. The Entity type column is shown by default, but you can disable this feature by unchecking the box, therefore it will be hidden. To apply changes click on the orange checkmark in the upper right corner.
By default, the Widget shows how many items per page can be visible and how many pages there are in general. The displaying of this information is optional. It changes by checking/unchecking the box called “Display pagination”. If the box will be unchecked the information about items per page and number of pages won’t be displayed. To apply the changes click on the orange checkmark in the upper right corner.
Please, note: to understand the next settings, we need to check the “Display pagination” box back to see the number of items per page.
The page size by default is set to 10 items per page. If you need to change this number you can type the digits manually or use the arrows at the end of the line to do it for you. To apply the changes click on the orange checkmark in the upper right corner. Now, there will be 15 items per page as is shown on our Table Widget.
To apply the changes click on the orange checkmark in the upper right corner. Now, there are 15 items per page as it is shown on the Entity Table Widget.
The default sorting order for the data in the Table widget is ascending. If the values in the column are lowercase (for example entityName/entityType), then sorting will be done according to the rules of alphabetical order.
If you’d like to sort the data, for instance, by the telemetry data key type (temperature, humidity, etc.), you can do this by inputting the name of your value in the Default sort order line. In the example, the temperature is used, so it looks like this:
As was mentioned, the default sort order is ascending.
If you need to make the sort order descending, you should type the “-” (minus) symbol in front of the data key name in the Default sort order line.
Be sure to click on the orange checkmark in the upper right corner to apply the changes to see the difference. Now, the telemetry data is sorted in the descending order we needed.
For the changes to be applied and saved, you necessarily need to click on the orange checkmark in the bottom right corner of the screen.
After doing this, you can be positively sure that the changes to the Table Widget are applied and saved correctly.