# Bidirectional Transaction Groups Don't Update Null Date Values From DB

**URL:** <https://forum.inductiveautomation.com/t/bidirectional-transaction-groups-dont-update-null-date-values-from-db/66549>\
**Category:** Ignition\
**Tags:** ignition81\
**Created:** [November 15, 2022, 8:50pm UTC](https://forum.inductiveautomation.com/t/bidirectional-transaction-groups-dont-update-null-date-values-from-db/66549 "2022-11-15T20:50:52Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![zzeng2](https://avatars.discourse-cdn.com/v4/letter/z/3bc359/32.png) [@zzeng2](https://forum.inductiveautomation.com/u/zzeng2)\
**Post date:** [November 15, 2022, 8:50pm UTC](https://forum.inductiveautomation.com/t/bidirectional-transaction-groups-dont-update-null-date-values-from-db/66549/1 "2022-11-15T20:50:52Z")

</div>

I have set up a standard transaction group and configured a DateTime item to use bi-directional mode. The idea is that I can update values from either the DB or the tag and the other side will update as well. However, every time I put in a null value in either the tag or the DB, it gets rejected and written back to what it was. It works well with non-null values. Does anyone know how to make it work? I am using V8.1.22

---

<div class="post-metadata">

**Author:** ![avaughn](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/avaughn/32/38972_2.png) [@avaughn](https://forum.inductiveautomation.com/u/avaughn)\
**Post date:** [November 17, 2022, 6:52pm UTC](https://forum.inductiveautomation.com/t/bidirectional-transaction-groups-dont-update-null-date-values-from-db/66549/2 "2022-11-17T18:52:19Z")

</div>

Hello zzeng2,

Does that column in the database table have the Not-Null constraint configured? This would cause the NULL values to be rejected by the database. Could you also check to see if you have the transaction group configured to set NULL values back to default values in the Options tab?  
 ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/f/b/fbb7d2b3bca4d83be3b75702218968c01778abbc.png)

---

<div class="post-metadata">

**Author:** ![zzeng2](https://avatars.discourse-cdn.com/v4/letter/z/3bc359/32.png) [@zzeng2](https://forum.inductiveautomation.com/u/zzeng2)\
**Post date:** [November 17, 2022, 10:17pm UTC](https://forum.inductiveautomation.com/t/bidirectional-transaction-groups-dont-update-null-date-values-from-db/66549/3 "2022-11-17T22:17:17Z")

</div>

Thanks for replying. I did check the database and made sure the column is nullable. These options you mentioned are not checked in the transaction group. If it helps, I am running MySQL 8.0.15.

What's interesting is if I just use OPC to DB or DB to OPC one directional mode, null values are properly updated.