Transaction Groups Execution Update Status

Ignition
1

Hi All,

Can anyone help me out how to track update status of rows into DB after execution of Transaction Groups.

2

There some different ways you could go about doing this 1)You could Utilize the Database Query Browser in Ignition to directly query the target database table. After a Transaction Group executes, you can refresh the query or execute a new one to observe the updated or newly inserted rows.

  1. Within the Transaction Group configuration in the Designer, navigate to the "Status" tab. This tab displays metrics such as "Total Executions" and "Failed Executions," providing an overview of the group's activity and any errors encountered during database interaction.

  2. You could create advanced queries within the table that allow you to sort, fliter rows for updated rows.

3

Hi Thank you

I am trying in program to give user pop up message after execution of Transaction Group i Tried with SQL queries in program but it is not effective.

4

Transaction groups are unattended gateway scope operations. Why do you need to do this?

(If a user is triggering something in the user interface to trigger a transaction group, you should instead use named queries to do all of the work directly from that user interface.)

2 Likes
5

I want to generate user pop whether DB rows are inserted or not inserted after execution of Transaction group

6

Let me repeat, transaction groups are unattended gateway scope operations. What is to happen when no user is logged in when the group runs? What if multiple users are logged in? (Do they all get a popup?) What if they are running different projects from the project with the popup defined?

I suspect you should not be using a transaction group, but NQs in your UI instead. But you haven't given any details of your requirements, so, maybe?

2 Likes