Scripting - Update/Refresh component before SQL query starts

Ignition
1

I’m new to Ignition.

In my project some components are set (calendar dates etc.) and when the search button is pressed a script runs a SQL query. The execution time can be a while (depending on the date range). I want to indicate to the user that the project is running the query and not frozen. I tried disabling the search button and changing the label to “Please Wait” but it didn’t change. I tried linking to a tag and changing the text that way but no luck.

Is there a way to update/refresh components before the query starts or better way of informing the user of a running query?

Setup

  • Ignition Platform 7.6.6
  • SQL Bridge Module 5.6.6
  • Vision Module 6.6.6
  • Alarm Notification Module 1.6.6
  • Reporting Module 1.6.6
  • Symbol Factory Module 2.7.0
2

Don’t run queries from event scripts. Don’t run anything that takes more than a fraction of a second in an event script, or your whole client can freeze. Use system.util.invokeAsynchronous() to run a separate procedure in the background, and have that procedure use system.util.invokeLater to send progress to the foreground.

3

Thanks for the quick response.

I’ll look into those system utils.