Hello, all my named queries work in the designer both in testing and when running specific views on the designer. But when I spin up the project nothing is going through and it is now giving me a web socket disconnection warning. The only other warning I am getting id missing views. Its worth it to add that I created one new view with a simple insert and that went through both on my project and my designer. Very confused by all this. Ignition Version : 8.1.44 Perspective, Designer is running on a separate PC, Project Queries does not work regardless of if I run it on the pc the designer is running, The pc hosting the gateway or any other device.
Welcome to the forum, Nicholas.
We'll need more specific information.
- You've mentioned "view" and that implies Perspective rather than Vision. Edit your question title and add the Perspective tag from the list (or Vision if you meant that).
- If you want to post code then please see Wiki - how to post code on this forum. And add a caption to the code to tell us where the code resides.3
- Which version of Ignition?
- Are you running Designer on the gateway or a separate PC?
How are you trying to use the queries in your views? Are you trying to use scripting or bindings? A little more details on how you've structured your connection to these queries will help.
If you are using scripting to call your named queries, please show the relevant code.
Please show how you have configured a non working Named Query?
Also, what Flavor of DB are you using MSSQL, Postgres, MySQL?
I missed some of these responses. The issue has been fixed, I had a navigation event occurring after my script event. This was causing the DB write to either be skipped or cut off too early. Scripting my navigation into the scripting event fixed the issue.
1 Like
Don't forget to mark your post as solution in case someone down the line has the same or similar issue due to events executing asynchronously.
1 Like