# Alarm journal table update data every 20 seconds now() command

**URL:** <https://forum.inductiveautomation.com/t/alarm-journal-table-update-data-every-20-seconds-now-command/35859>\
**Category:** Ignition\
**Tags:** ignition79\
**Created:** [June 22, 2020, 12:12am UTC](https://forum.inductiveautomation.com/t/alarm-journal-table-update-data-every-20-seconds-now-command/35859 "2020-06-22T00:12:45Z")\
**Posts on this page:** 19\
**Page:** 1

<div class="post-metadata">

**Author:** ![marcg](https://avatars.discourse-cdn.com/v4/letter/m/bb73d2/32.png) [@marcg](https://forum.inductiveautomation.com/u/marcg)\
**Post date:** [June 22, 2020, 12:12am UTC](https://forum.inductiveautomation.com/t/alarm-journal-table-update-data-every-20-seconds-now-command/35859/1 "2020-06-22T00:12:45Z")

</div>

hi guys please help me, i want to update my alarm journal table every 20 seconds. the now(20000) commands is not working. Is there other way to solve this? thanks! when there’s new alarm it always show up on alarm journal after 1 second.

 ![image](https://us1.discourse-cdn.com/inductiveautomation/original/2X/a/a622f3c020611ce07736c140ade0d39ec8ab4a68.png)

---

<div class="post-metadata">

**Author:** ![Matrix\_Engineering](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/matrix_engineering/32/19781_2.png) [@Matrix\_Engineering](https://forum.inductiveautomation.com/u/Matrix_Engineering)\
**Post date:** [June 22, 2020, 12:28am UTC](https://forum.inductiveautomation.com/t/alarm-journal-table-update-data-every-20-seconds-now-command/35859/2 "2020-06-22T00:28:19Z")

</div>

Edit, different method coming

---

<div class="post-metadata">

**Author:** ![marcg](https://avatars.discourse-cdn.com/v4/letter/m/bb73d2/32.png) [@marcg](https://forum.inductiveautomation.com/u/marcg)\
**Post date:** [June 22, 2020, 12:31am UTC](https://forum.inductiveautomation.com/t/alarm-journal-table-update-data-every-20-seconds-now-command/35859/3 "2020-06-22T00:31:57Z")

</div>

I want a alarm journal that updates every 20 seconds at once, example theres new alarm at 9:15:10 and another new alarm at 9:15:15 on 9:15:20 the both alarm will show on my alarm journal.  
i’ll try this 1, thanks!

---

<div class="post-metadata">

**Author:** ![Matrix\_Engineering](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/matrix_engineering/32/19781_2.png) [@Matrix\_Engineering](https://forum.inductiveautomation.com/u/Matrix_Engineering)\
**Post date:** [June 22, 2020, 12:33am UTC](https://forum.inductiveautomation.com/t/alarm-journal-table-update-data-every-20-seconds-now-command/35859/4 "2020-06-22T00:33:01Z")

</div>

Yeah I edited my post while you were typing, let me get back to you…

---

<div class="post-metadata">

**Author:** ![Matrix\_Engineering](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/matrix_engineering/32/19781_2.png) [@Matrix\_Engineering](https://forum.inductiveautomation.com/u/Matrix_Engineering)\
**Post date:** [June 22, 2020, 12:35am UTC](https://forum.inductiveautomation.com/t/alarm-journal-table-update-data-every-20-seconds-now-command/35859/5 "2020-06-22T00:35:56Z")

</div>

So you want it to update 3 times a minute, no more (or less)?

---

<div class="post-metadata">

**Author:** ![marcg](https://avatars.discourse-cdn.com/v4/letter/m/bb73d2/32.png) [@marcg](https://forum.inductiveautomation.com/u/marcg)\
**Post date:** [June 22, 2020, 12:37am UTC](https://forum.inductiveautomation.com/t/alarm-journal-table-update-data-every-20-seconds-now-command/35859/6 "2020-06-22T00:37:10Z")

</div>

Yeah, but it depends if there’s new active alarm poped.

---

<div class="post-metadata">

**Author:** ![Matrix\_Engineering](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/matrix_engineering/32/19781_2.png) [@Matrix\_Engineering](https://forum.inductiveautomation.com/u/Matrix_Engineering)\
**Post date:** [June 22, 2020, 12:39am UTC](https://forum.inductiveautomation.com/t/alarm-journal-table-update-data-every-20-seconds-now-command/35859/7 "2020-06-22T00:39:20Z")

</div>

So if in a given minute there are no new alarms, don’t refresh at all?

---

<div class="post-metadata">

**Author:** ![marcg](https://avatars.discourse-cdn.com/v4/letter/m/bb73d2/32.png) [@marcg](https://forum.inductiveautomation.com/u/marcg)\
**Post date:** [June 22, 2020, 12:41am UTC](https://forum.inductiveautomation.com/t/alarm-journal-table-update-data-every-20-seconds-now-command/35859/8 "2020-06-22T00:41:23Z")

</div>

![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/f/3/f3f648ccfcb288059bf53e3a5c17d92163e36863.png) i tried this command, but it didnt work. i guess i want to refresh the alarm journal every 20 second even without new alarm. is that possible?

---

<div class="post-metadata">

**Author:** ![Matrix\_Engineering](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/matrix_engineering/32/19781_2.png) [@Matrix\_Engineering](https://forum.inductiveautomation.com/u/Matrix_Engineering)\
**Post date:** [June 22, 2020, 12:47am UTC](https://forum.inductiveautomation.com/t/alarm-journal-table-update-data-every-20-seconds-now-command/35859/9 "2020-06-22T00:47:06Z")

</div>

What if there are 10 alarms every 2 seconds in that 20 second window?

---

<div class="post-metadata">

**Author:** ![marcg](https://avatars.discourse-cdn.com/v4/letter/m/bb73d2/32.png) [@marcg](https://forum.inductiveautomation.com/u/marcg)\
**Post date:** [June 22, 2020, 12:50am UTC](https://forum.inductiveautomation.com/t/alarm-journal-table-update-data-every-20-seconds-now-command/35859/10 "2020-06-22T00:50:15Z")

</div>

they will show simultaneously at the 20 second mark. example if they’re active at 9:15:02, 9:15:04,9:15:06 and etc. on 9:15:20 they will show on alarm journal.

---

<div class="post-metadata">

**Author:** ![Matrix\_Engineering](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/matrix_engineering/32/19781_2.png) [@Matrix\_Engineering](https://forum.inductiveautomation.com/u/Matrix_Engineering)\
**Post date:** [June 22, 2020, 12:53am UTC](https://forum.inductiveautomation.com/t/alarm-journal-table-update-data-every-20-seconds-now-command/35859/11 "2020-06-22T00:53:52Z")

</div>

OK; so the pseudo code is:

```auto
If seconds == 00 or 20 or 40:
   Refresh the alarm journal table

```

---

<div class="post-metadata">

**Author:** ![marcg](https://avatars.discourse-cdn.com/v4/letter/m/bb73d2/32.png) [@marcg](https://forum.inductiveautomation.com/u/marcg)\
**Post date:** [June 22, 2020, 12:57am UTC](https://forum.inductiveautomation.com/t/alarm-journal-table-update-data-every-20-seconds-now-command/35859/12 "2020-06-22T00:57:21Z")

</div>

i see, if it works and do refresh the alarm journal every 20 seconds im fine with that. So how do i write the script? can you give me an idea buddy? thanks!

---

<div class="post-metadata">

**Author:** ![Matrix\_Engineering](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/matrix_engineering/32/19781_2.png) [@Matrix\_Engineering](https://forum.inductiveautomation.com/u/Matrix_Engineering)\
**Post date:** [June 22, 2020, 1:09am UTC](https://forum.inductiveautomation.com/t/alarm-journal-table-update-data-every-20-seconds-now-command/35859/13 "2020-06-22T01:09:42Z")

</div>

Try this;

 ![alarm poll 20](https://us1.discourse-cdn.com/inductiveautomation/original/3X/8/d/8d66b599afc8bda701728999da5a679df7ee4c69.png)

---

<div class="post-metadata">

**Author:** ![marcg](https://avatars.discourse-cdn.com/v4/letter/m/bb73d2/32.png) [@marcg](https://forum.inductiveautomation.com/u/marcg)\
**Post date:** [June 22, 2020, 1:18am UTC](https://forum.inductiveautomation.com/t/alarm-journal-table-update-data-every-20-seconds-now-command/35859/14 "2020-06-22T01:18:14Z")

</div>

![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/6/7/6770e8036cfe3212a3aa4a9e169f4e0cec45d104.png) im getting this error. \

---

<div class="post-metadata">

**Author:** ![Matrix\_Engineering](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/matrix_engineering/32/19781_2.png) [@Matrix\_Engineering](https://forum.inductiveautomation.com/u/Matrix_Engineering)\
**Post date:** [June 22, 2020, 1:20am UTC](https://forum.inductiveautomation.com/t/alarm-journal-table-update-data-every-20-seconds-now-command/35859/15 "2020-06-22T01:20:40Z")

</div>

Is your system V7.9 or 8.0?

It’s not select from group\_table in 7.9… do you have multiple databases?

---

<div class="post-metadata">

**Author:** ![marcg](https://avatars.discourse-cdn.com/v4/letter/m/bb73d2/32.png) [@marcg](https://forum.inductiveautomation.com/u/marcg)\
**Post date:** [June 22, 2020, 1:24am UTC](https://forum.inductiveautomation.com/t/alarm-journal-table-update-data-every-20-seconds-now-command/35859/16 "2020-06-22T01:24:09Z")

</div>

its 8.0, i only have 1

---

<div class="post-metadata">

**Author:** ![Matrix\_Engineering](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/matrix_engineering/32/19781_2.png) [@Matrix\_Engineering](https://forum.inductiveautomation.com/u/Matrix_Engineering)\
**Post date:** [June 22, 2020, 1:29am UTC](https://forum.inductiveautomation.com/t/alarm-journal-table-update-data-every-20-seconds-now-command/35859/17 "2020-06-22T01:29:15Z")

</div>

OK. At the top of this window is says ignition79, that means 7.9. Please select Ignition80 for future threads on 8.0

I only have one 8.0 instance. I will have to get back to you later.

---

<div class="post-metadata">

**Author:** ![marcg](https://avatars.discourse-cdn.com/v4/letter/m/bb73d2/32.png) [@marcg](https://forum.inductiveautomation.com/u/marcg)\
**Post date:** [June 22, 2020, 1:31am UTC](https://forum.inductiveautomation.com/t/alarm-journal-table-update-data-every-20-seconds-now-command/35859/18 "2020-06-22T01:31:10Z")

</div>

okay thanks for all the help buddy.

---

<div class="post-metadata">

**Author:** ![JordanCClark](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/jordancclark/32/83362_2.png) [@JordanCClark](https://forum.inductiveautomation.com/u/JordanCClark)\
**Post date:** [June 22, 2020, 11:49am UTC](https://forum.inductiveautomation.com/t/alarm-journal-table-update-data-every-20-seconds-now-command/35859/19 "2020-06-22T11:49:07Z")

</div>

Try this expression for EndDate:

```auto
toDate(dateFormat(now(), 'yyyy-MM-dd HH:mm:' + toStr(toInt(floor(getSecond(now())/20)*20))))

```