Hi ,
when i query for the count(*) using sql query and try to display that in text area it an object. Please help.
The query is returning a "data" object. This object has properties for each column or property that your query is returning. So, to access the count from the data you'd use {{query1.data.count}}
A good way to figure this out would be to run the query then use the ... button next to the query to "view state" and you can see the data and the structure of the object which should make it easier to understand how to access the properties you want to use. Hope this helps.
2 Likes