Using concat query for Database Values plugin

[Ramprasad Prabhakar]

I am using database values plugin, and I am trying to use the following query to retrieve the values from the DB:

sql.query=select concat(assetid,'|',asset) as assets from assetview where assettype='${_customfield_10250}'

Instead of seeing the values, I see the junk above. Could someone help with this issue ?

My DB is MySQL.

[Wim Deblauwe]

I don't really know what the problem is, but it looks like the toString() of a byte array. Can you try your query on the MySQL command line to see what the result is there?

[Radu Dumitriu]

Shouldn't be

SELECT CONCAT(CAST(assetid AS CHAR), asset) ... ?

Your problem is (most probably) that the result of the concat is casted at the

'largest' type interpretation, which seems to be a binary string or something.

My 2 cents.