Perspective formatting query as JSON output

Ignition
,
1

I have a label in my Ignition Perspective project that is bound to a Query Binding. The label is supposed to display an integer, but it is displaying the integer in JSON format instead.
image
image

I have verified that my query is correct because the same query in Vision displays a plain integer, and in the testing section of Named Queries, it also shows the integer correctly. Why is the Query Binding giving me a JSON output instead of the plain integer only in a label? I have tried casting as a String in my SQL query but that just gets me [{"String here":0}] I know I am missing something but not sure what. New to Perspective and could use some help. Thanks!

2

Try setting the return format to scalar in the query binding.

3

Thank you, that did the trick. It was set to auto.