# What is this and how to use this?

**URL:** <https://forum.inductiveautomation.com/t/what-is-this-and-how-to-use-this/20417>\
**Category:** General Discussion\
**Created:** [October 28, 2018, 2:01pm UTC](https://forum.inductiveautomation.com/t/what-is-this-and-how-to-use-this/20417 "2018-10-28T14:01:04Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![simon.ong](https://avatars.discourse-cdn.com/v4/letter/s/e79b87/32.png) [@simon.ong](https://forum.inductiveautomation.com/u/simon.ong)\
**Post date:** [October 28, 2018, 2:01pm UTC](https://forum.inductiveautomation.com/t/what-is-this-and-how-to-use-this/20417/1 "2018-10-28T14:01:04Z")

</div>

![](https://us1.discourse-cdn.com/inductiveautomation/original/2X/2/25cf8b72d79caf3061d6c8719b2de13fb46a3915.png)

How to use the Insert New Record fucntion?

Thanks

---

<div class="post-metadata">

**Author:** ![pturmel](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/pturmel/32/3295_2.png) [@pturmel](https://forum.inductiveautomation.com/u/pturmel)\
**Post date:** [October 28, 2018, 2:15pm UTC](https://forum.inductiveautomation.com/t/what-is-this-and-how-to-use-this/20417/2 "2018-10-28T14:15:06Z")

</div>

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.

---

<div class="post-metadata">

**Author:** ![simon.ong](https://avatars.discourse-cdn.com/v4/letter/s/e79b87/32.png) [@simon.ong](https://forum.inductiveautomation.com/u/simon.ong)\
**Post date:** [October 28, 2018, 3:17pm UTC](https://forum.inductiveautomation.com/t/what-is-this-and-how-to-use-this/20417/3 "2018-10-28T15:17:00Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![pturmel](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/pturmel/32/3295_2.png) [@pturmel](https://forum.inductiveautomation.com/u/pturmel)\
**Post date:** [October 28, 2018, 5:24pm UTC](https://forum.inductiveautomation.com/t/what-is-this-and-how-to-use-this/20417/4 "2018-10-28T17:24:00Z")

</div>

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.