Why are my results displaying as "column name : row data" within an object?

I'd like it to display the column details without the column name for every item selected. I get the results that I want when I don't name dbselect. I'd also like it to display as a string and not within an object.

{note}Warehousing: {dbselect: SELECT Warehousing Information FROM Warehousing; space=5kbPatw9i6pgHMUU5twpjx; menu=yes; multiple=yes; name=whsDetails} {endnote}

Warehousing: {=whsDetails}

image

I figured out a solution.

{note}Warehousing: {dbselect: SELECT Warehousing Information FROM Warehousing; space=5kbPatw9i6pgHMUU5twpjx; menu=yes; multiple=yes} {endnote}

{if: warehousing information <> }Warehousing: {={=join(warehousing information,",")}}{endif}

image

Strange that it doesn't work when I give dbselect a name; If it does, please let me know what I'm dong wrong.

Hello!

If you know the name of the column, you can use map to go through the list and get each individual value, then join them in any way you want:

{list=[["warehouse":"one"], ["warehouse":"two"],["warehouse":"three"]]}

{=list}
{valuesList=map(list, (x) -> (x["warehouse"]))}
{=join(valuesList, ", ")}

1 Like