How To Display All Rows From A SQL Query

[Mursel.BAKAY]

Hi,

I have created an item for showing sql query result. But it shows only the first row as result. I want to display all rows and show it on dashboard. Is it possible?

How can I do it?
Thanks a lot.

[vladimir_lv]

How looks your item?

[Mursel.BAKAY]

Hi,

I attached screens about my issue.
My item looks like item.png. When I test it, that looks as test.png. And my sql result have 280 rows but zabbix shows only 1 row. Also my query and its result showed at result.png.

Thanks for your help.

[vladimir_lv]

You can try to get an answer for your request as JSON and then parse it.
For example:

 SELECT CONCAT('[', my_result, ']') AS zabbix_hosts FROM ( SELECT GROUP_CONCAT('{', my_json, '}' SEPARATOR ',') AS my_result FROM (   SELECT      CONCAT     (       '"hostid":'   , '"', hostid   , '"', ','        '"host":', '"', host, '"', ','       '"uuid":'  , uuid     ) AS my_json   FROM hosts ) AS more_json ) AS yet_more_json;

[dimir]

In order to catch multiple lines use item key

db.odbc.get

instead of

db.odbc.select

More info here.

[dimir]

I'm afraid there's no such way currently. Would it be possible to filter out just what you need using item value preprocessing? Or, you could use dependent items, but in this case the number of values to save should be probably static.

Alternatively you can create your own module for Frontend.

[dimir]

Why are you using JSON? If you leave it just as multiline output isn't it shown correctly in the item widget?

[Mursel.BAKAY]

I'm not using JSON anyway. When I add item to dashboard, my result is like "value.png" as I attached. I don't know what to do.

[Mursel.BAKAY]

value.png has been attached.