What is this and how to use this?

General Discussion
1

INSERT.png1366×768 96.5 KB

How to use the Insert New Record fucntion?

Thanks

2

If you don’t use a trigger, your items will be stored in the database in a new row every time the group executes (per the pace you specify). If you do use a trigger, it will be checked at the pace specified, and a new row inserted whenever the trigger says to.

3

So the “where” box is no effect if specify the database columns with other tags?

4

The where clause can only choose DB rows to change (update) or DB rows to bring to Ignition (select, for DB=>OPC operations), as evaluated by the database. Databases don’t accept a where clause for insert. If you have a condition to check before inserting, make it your trigger. If you have multiple conditions you must use to decide whether to insert or not, you will need an execute-only expression item to produce a single trigger item. The trigger determines whether to run the group’s SQL statement, whichever kind it is.