Hey all, I have a SQL database linked and running a query that outputs a payload and I am able to select it individually by msg.payload.rows[0] etc, but when trying to display it on the UI I can't figure out how to display just the value inside quotations. Any assistance would be greatly appreciated…

show the output of debug 1. copy and paste.

Your problem will be made a bit simpler if you change your query a bit SELECT blah, blah, SUBSTR(CNTR_DESC, 1, 8) AS desc, blah, blah from blah... The value "1G030142" then becomes msg.payload.rows[0].desc or (in a template) msg.payload.rows.0.desc Edit: desc is no doubt a reserved word. Use some…

SELECT * FROM ( SELECT DISTINCT substr(cntr_desc, 1, 8) FROM v_rt_shift_oee_calc ORDER BY DBMS_RANDOM.RANDOM) WHERE rownum < 11 : msg : Object object payload: object metaData: array[1] rows: array[10] 0: object 1: object 2: object 3: object 4: object 5: object 6: object 7: object 8: obj…

rows: array[10] 0: object SUBSTR(CNTR_DESC,1,8): "1H080104" 1: object 2: object SUBSTR(CNTR_DESC,1,8): "1B010211"

sorry forgot to ask, is this dashboard 1 or dashboard 2.0 ? assuming, dashboard 1, try this in the ui-text [{"id":"91326ae9c1b76ad6","type":"ui_text","z":"4cde86148e5b95f7","group":"6339e2ead216512f","order":4,"width":0,"height":0,"name":"","label":"","format":"{{payload[0]SUBSTR(CNTR_DESC,1,8)}}…

UI Text Formatting

General

smanjunath211 20 August 2024 01:52 5

sorry, i wasn't clear. open any one object completely of the debug output and paste the value.
also, if you could follow @jbudd advice, the result will be simpler to implement

Topic		Replies	Views
How to display data from Mysql database in dashboard with text input General	5	3412	19 April 2021
MSSQL query sum value display in ui_text General	4	344	21 June 2021
View SQLite records show empty (but actually full) Dashboard	12	681	22 July 2020
How to get data from MYSQL Dashboard	11	3949	18 January 2021
How to Dynamically change the "Value Format" of ui_text? Dashboard	6	11429	10 July 2019

UI Text Formatting

Related topics