Generating a list using ui_list-widget from MSSQL PLus

[nico25]

I´ve been struggling for a while now, to format my msg.payload in a way, that it is displayed in ui_list.

I found this entry here in the forum:

Mysql output as input for list node

I made a dashboard for learning IR and RF codes and execute them. Storage is in mysql. I have 99% working, but the last part wont . I like to fill a list node based on devices that are 'learned'and already saved in the mysql database. So i retrieve the unique names from the devices from mysql and try to fill the list node.. I added the flow and added the different content I see the structure that comes from mysql is not the right structure for the list node... Expanation content: orgdevi…

But I didn´t really get how to solve my problem.
Any feedback welcome.

[jbudd]

A snippet from the help for ui_list:

So does it work if you change your SQL query to
select Toolnr as title, Model from All_Tools where Loction = 'Werkzeugbau' ?

[nico25]

I could solve it after you made me aware, that the widget needs a message.payload.title.
So I wrote a function that iterates through the array and generates titles for every entry.

var schritt;
msg.test = msg.payload.length;
for(schritt = 0; schritt < msg.payload.length;schritt++)
{
    msg.payload[schritt].title = msg.payload[schritt].Toolnr + '-' + msg.payload[schritt].Model;

}

 return msg;

[Steve-Mcl]

You could just as easily have done the text concatenation and generated this title field SQL query.