# Transaction Group -\> DB to Memory Tags

**URL:** <https://forum.inductiveautomation.com/t/transaction-group-db-to-memory-tags/80721>\
**Category:** Ignition\
**Created:** [October 19, 2023, 8:01pm UTC](https://forum.inductiveautomation.com/t/transaction-group-db-to-memory-tags/80721 "2023-10-19T20:01:04Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![tim.schultz](https://avatars.discourse-cdn.com/v4/letter/t/71e660/32.png) [@tim.schultz](https://forum.inductiveautomation.com/u/tim.schultz)\
**Post date:** [October 19, 2023, 8:01pm UTC](https://forum.inductiveautomation.com/t/transaction-group-db-to-memory-tags/80721/1 "2023-10-19T20:01:04Z")

</div>

One of my plant is entering process quality records into a database. The records are not necessarily put in to the DB in a timely manner, but there is a representative timestamp column; the table columns end up as Lane, Unit, Date, ProcessValue1, ProcessValue2, ProcessValue3, etc. The memory tags are named as such: Lane\_Unit\_ProcessValue1, Lane\_Unit\_ProcessValue2, etc.

My goal is to bring these values into the Ignition historian so that it can be aggregated and consumed alongside other historian data by external tools. I'm currently using a Standard Transaction Group to pull the most recent record (using a select max(timestamp) query tag as trigger tag). That is working well, but the problem is around the timing in the historian. Is there a way to set the "timestamp" part of the memory tag qualified value? I need the Lane\_Unit\_ProcessValue1 tag value & timestamp to match with the source DB record.

I attempted to set the Timestamp property as part of the 'Edit group tag window', but this did not work (note that group's mode=\>DB to OPC):

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