I have a transaction group that counts the instances where a boolean tag is true. I use a named query SELECT count(count1_ndx) FROM count1 WHERE t_stamp > 1639054080257 to return the number of instances from a particular time stamp when I want to show it in binded in a label text it gives me an …

Ok so its been edited. Save your project and reload you view. See if this fixes your issue. Edit: I was able to recreate your basic problem. I created a named query that was SELECT 2 and bound that to a label text. Then I edited the query without saving it (which leaves it in italics) to SELECT…

The query is returning Null, which I will admit is a little odd. If you open the Named query and run the query from the Testing tab, do you get the results you expect?

And in the case you get the same thing in the Testing tab, what do you get if you run this query directly on your database? Just so we know the expected result.

[image] bkarabinchak.psi: You don’t happen to have the transform script enabled without anything inside of it do you? Python functions when they lack a return function will automatically return None. If you’re transform script is enabled but blank I imagine that could be causing it. I thought…

Yea I just tested it, doing a return None or erasing it does lead to a null result, not a class.org.python.core.PyNone. Agreed, it looks like it should be scalar, in which case I’m unsure what you would need a transform script for. But it does appear to be one configured no? @Resistor can you sho…

When I test the named query I get the numeric result back. [image] I only used the script to see which type of data it was returning, without it returns null… regardless of the return format(auto, scalar, etc.) [image]

So to summarize - we expect to see 18, when you just bind to the namedQuery directly you get a null, and when you add transform script this turns into a PyNone? Very odd indeed. I’m out of ideas then. Note you can always call Ignition Support, they’re very helpful, can remote in and help you tro…

Basically… and when I added the transform I used the type() function to see what type of data it was exactly. Thanks anyway. I didn’t want to call because I barely know how to use the software and thought they only help troubleshooting but you needed to know how everything works

Oh well if you’re returning type() in your transform then it I can see why you get the PyNone at least. You will get the most out of this forum generally speaking if you can show your code as well - that’s the only way any of us can really help you troubleshoot. However the larger issue of your na…

[image] Resistor: WHERE t_stamp > 1639054080257 im not sure this is the best way to filter a t_stamp tho might be mixing up second and milisecond based tstamps..

Of course [image] I just now changed the name to see if the space I had before could have caused the problem. But it’s the same as in the last image I showed

Inductive Automation Forum

Named query not working on label. PLZ help

Ignition

ignition80, database, scripting, perspective

show post in topic

Home
Categories
Guidelines
Terms of Service
Privacy Policy

Powered by Discourse, best viewed with JavaScript enabled