ODBC and LLD Query

[Colttt]

Hello,

i hope someone can help me:

my original SQL-query looks like (postgreSQL):

select
 channel.id,
 channel.name,
 d_channels.local_channel_id

from channel
	left join d_channels on d_channels.channel_id = channel.id

so now i would like to use this for ODBC-LLD:

select '{''"data":[{"{#channelid}":"channel.id"}, "{#channelname}":"channel.name"}, "{#localchannelid}":"d_channels.local_channel_id"}, '']''}' from channel left join d_channels on d_channels.channel_id = channel.id

i know something its wrong (get error message: "Value should be a JSON format") can someone help me to do it correct?

thanks in davance!


UPDATE:
that works its in JSON format,

 select json_build_object('#CHANNELID',channel.id,'#CHANNELNAME',channel.id,'#LOCALCHANNELID',d_channels.local_channel_id) from channel left join d_channels on d_channels.channel_id = channel.id;

but i need "DATA" in front of it, but it dont work.. any ideas?

SELECT '"{data":[', (SELECT json_build_object('#CHANNELID',channel.id,'#CHANNELNAME',channel.id,'#LOCALCHANNELID',d_channels.local_channel_id) FROM channel LEFT JOIN d_channels ON d_channels.channel_id = channel.id),']}';
ERROR:  more than one row returned by a subquery used as an expression