Hello everyone and congratulations for the speed and quality with which the new dashboard was put into production! Is it possible to hide a column in the dashboard v2 table? I ask because I need to hide the table IDs, which are used to associate the selected rows with those in the database but take up space and are of no use to the operator when viewing the table. Thanks to those who will answer
If you are on dashboard-2.0, you may want to look at @omrid01/node-red-dashboard-2-table-tabulator, which gives you the full range of functionality (add, update, delete, query, edit, show/hide, filter, style etc.). For your specific requirement, any column can be defined as visible or not.
1 Like
Thank you, it's definitely an alternative, if no one has answered so far it's probably because it's not possible to do it with dashboard 2
As the node properties are not dynamic, it looks unlikely that you can alter what columns are shown easily. The only way I see as it stands is to remove the column data from input array. Also there is know way to know which column was clicked, so you would have to use button nodes to enable showing and hiding the columns you wish.
1 Like
I agree, I had already evaluated this solution but it is not practical.
Maybe a Dropdown node would make it more practical.
[{"id":"8ba5a4a9a542b31d","type":"inject","z":"d1395164b4eec73e","name":"","props":[{"p":"payload"}],"repeat":"","crontab":"","once":true,"onceDelay":0.1,"topic":"","payload":"[{\"name\":\"data\",\"THERMOSTAT_COMMAND_1\":\"074142C524C524\",\"THERMOSTAT_STATUS_1\":\"070142E125E125FF\"},{\"name\":\"dgn\",\"THERMOSTAT_COMMAND_1\":\"1FEF9\",\"THERMOSTAT_STATUS_1\":\"1FFE2\"},{\"name\":\"fan mode\",\"THERMOSTAT_COMMAND_1\":\"00\",\"THERMOSTAT_STATUS_1\":\"00\"},{\"name\":\"fan mode definition\",\"THERMOSTAT_COMMAND_1\":\"auto\",\"THERMOSTAT_STATUS_1\":\"auto\"},{\"name\":\"fan speed\",\"THERMOSTAT_COMMAND_1\":33,\"THERMOSTAT_STATUS_1\":33},{\"name\":\"instance\",\"THERMOSTAT_COMMAND_1\":7,\"THERMOSTAT_STATUS_1\":7},{\"name\":\"operating mode\",\"THERMOSTAT_COMMAND_1\":\"0001\",\"THERMOSTAT_STATUS_1\":\"0001\"},{\"name\":\"operating mode definition\",\"THERMOSTAT_COMMAND_1\":\"cool\",\"THERMOSTAT_STATUS_1\":\"cool\"},{\"name\":\"schedule mode\",\"THERMOSTAT_COMMAND_1\":\"01\",\"THERMOSTAT_STATUS_1\":\"00\"},{\"name\":\"schedule mode definition\",\"THERMOSTAT_COMMAND_1\":\"enabled\",\"THERMOSTAT_STATUS_1\":\"disabled\"},{\"name\":\"setpoint temp cool\",\"THERMOSTAT_COMMAND_1\":21.2,\"THERMOSTAT_STATUS_1\":30},{\"name\":\"setpoint temp cool F\",\"THERMOSTAT_COMMAND_1\":70.1,\"THERMOSTAT_STATUS_1\":86},{\"name\":\"setpoint temp heat\",\"THERMOSTAT_COMMAND_1\":21.2,\"THERMOSTAT_STATUS_1\":30},{\"name\":\"setpoint temp heat F\",\"THERMOSTAT_COMMAND_1\":70.1,\"THERMOSTAT_STATUS_1\":86},{\"name\":\"timestamp\",\"THERMOSTAT_COMMAND_1\":\"1726025068.333129\",\"THERMOSTAT_STATUS_1\":\"1726025066.253274\"}]","payloadType":"json","x":170,"y":2200,"wires":[["1f833dce62939f77"]]},{"id":"1f833dce62939f77","type":"change","z":"d1395164b4eec73e","name":"","rules":[{"t":"set","p":"table_array","pt":"flow","to":"payload","tot":"msg","dc":true}],"action":"","property":"","from":"","to":"","reg":false,"x":210,"y":2260,"wires":[["4daa596977ced887","e1fb89e71607fbb6"]]},{"id":"4daa596977ced887","type":"change","z":"d1395164b4eec73e","name":"","rules":[{"t":"set","p":"payload","pt":"msg","to":"$$.payload~> |$|{},[$$.columns]|","tot":"jsonata"}],"action":"","property":"","from":"","to":"","reg":false,"x":480,"y":2260,"wires":[["7c7c221cfb49f6da"]]},{"id":"e1fb89e71607fbb6","type":"change","z":"d1395164b4eec73e","name":"","rules":[{"t":"set","p":"options","pt":"msg","to":"$keys($$.payload[0])","tot":"jsonata"}],"action":"","property":"","from":"","to":"","reg":false,"x":440,"y":2160,"wires":[["cf08e16a8ef3198b"]]},{"id":"2e55aacb6cc78373","type":"change","z":"d1395164b4eec73e","name":"","rules":[{"t":"move","p":"payload","pt":"msg","to":"columns","tot":"msg"},{"t":"set","p":"payload","pt":"msg","to":"table_array","tot":"flow"}],"action":"","property":"","from":"","to":"","reg":false,"x":860,"y":2160,"wires":[["4daa596977ced887"]]},{"id":"7c7c221cfb49f6da","type":"ui-table","z":"d1395164b4eec73e","group":"9d83cd8b3d5ee33c","name":"","label":"text","order":1,"width":0,"height":0,"maxrows":0,"passthru":false,"autocols":true,"showSearch":false,"selectionType":"click","columns":[],"mobileBreakpoint":"sm","mobileBreakpointType":"defaults","x":650,"y":2260,"wires":[["ad1c6238be52e4a3"]]},{"id":"cf08e16a8ef3198b","type":"ui-dropdown","z":"d1395164b4eec73e","group":"9d83cd8b3d5ee33c","name":"","label":"Select columns to hide","tooltip":"","order":0,"width":0,"height":0,"passthru":false,"multiple":true,"chips":false,"clearable":false,"options":[],"payload":"","topic":"topic","topicType":"msg","className":"","typeIsComboBox":true,"x":660,"y":2160,"wires":[["2e55aacb6cc78373"]]},{"id":"ad1c6238be52e4a3","type":"debug","z":"d1395164b4eec73e","name":"debug 2567","active":true,"tosidebar":true,"console":false,"tostatus":false,"complete":"true","targetType":"full","statusVal":"","statusType":"auto","x":810,"y":2260,"wires":[]},{"id":"9d83cd8b3d5ee33c","type":"ui-group","name":"Group1","page":"c694d0ebe0d2b702","width":"6","height":"1","order":1,"showTitle":true,"className":"","visible":"true","disabled":"false"},{"id":"c694d0ebe0d2b702","type":"ui-page","name":"Page1","ui":"1805777f90e92057","path":"/page1","icon":"home","layout":"grid","theme":"a965ccfef139317a","order":2,"className":"","visible":"true","disabled":"false"},{"id":"1805777f90e92057","type":"ui-base","name":"dashboard","path":"/dashboard","includeClientData":true,"acceptsClientConfig":["ui-notification","ui-control"],"showPathInSidebar":false,"showPageTitle":true,"titleBarStyle":"default"},{"id":"a965ccfef139317a","type":"ui-theme","name":"HN Theme","colors":{"surface":"#5c5c5c","primary":"#00fdff","bgPage":"#383838","groupBg":"#4f4f4f","groupOutline":"#858585"},"sizes":{"pagePadding":"12px","groupGap":"12px","groupBorderRadius":"4px","widgetGap":"12px"}}]
I'll try tank you
This topic was automatically closed 30 days after the last reply. New replies are no longer allowed.
