# What about \`ma\_campaign\_lead\_event\_log.date\_triggered\` as ISO to microseconds?

**URL:** <https://forum.mautic.org/t/what-about-ma-campaign-lead-event-log-date-triggered-as-iso-to-microseconds/26085>\
**Category:** Development\
**Created:** [November 15, 2022, 12:20am UTC](https://forum.mautic.org/t/what-about-ma-campaign-lead-event-log-date-triggered-as-iso-to-microseconds/26085 "2022-11-15T00:20:06Z")\
**Posts on this page:** 7\
**Page:** 1

<div class="post-metadata">

**Author:** ![xmontero](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.mautic.org/xmontero/32/7499_2.png) [@xmontero](https://forum.mautic.org/u/xmontero)\
**Post date:** [November 15, 2022, 12:20am UTC](https://forum.mautic.org/t/what-about-ma-campaign-lead-event-log-date-triggered-as-iso-to-microseconds/26085/1 "2022-11-15T00:20:06Z")

</div>

I see that `ma_campaign_lead_event_log.date_triggered`has this format:

```
2022-11-13 23:25:03

```

I suggest to move to

```
2022-11-13T22:25:03.123456Z

```

so multiple “near-by” events will be properly sorted in order when displayed in the contact page.

Is any core-team developer seeing this as viable? I’m ready to help coding if needed and do a PR.

But I don’t want to devote time if it will not be merged.

---

<div class="post-metadata">

**Author:** ![joeyk](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.mautic.org/joeyk/32/11164_2.png) [@joeyk](https://forum.mautic.org/u/joeyk)\
**Post date:** [November 15, 2022, 8:01am UTC](https://forum.mautic.org/t/what-about-ma-campaign-lead-event-log-date-triggered-as-iso-to-microseconds/26085/2 "2022-11-15T08:01:32Z")

</div>

I think you should suggest it in the #dev channel in slack. I don’t think this is a bad idea, but have to think if it breaks reverse compatibility of the API.

---

<div class="post-metadata">

**Author:** ![xmontero](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.mautic.org/xmontero/32/7499_2.png) [@xmontero](https://forum.mautic.org/u/xmontero)\
**Post date:** [November 16, 2022, 12:21pm UTC](https://forum.mautic.org/t/what-about-ma-campaign-lead-event-log-date-triggered-as-iso-to-microseconds/26085/3 "2022-11-16T12:21:02Z")

</div>

Thanks, Joey. Didn’t know there’s a slack channel to get in touch with the devs.

Will try to join.

There’s a simple way to do not break API compat:

- In the API do not change the field, just add another field. The if one field is `whateverDate` the new field could be `whateverDateIsoUtcMicro` so any old client won’t break. Both fields answered.
- Any stored “old” value will be converted to `.000000Z` microseconds in the new field.
- Any stored “new” value will be rounded to seconds in the old field.
- The old field is marked deprecated and maintaned there until a major version is published.

---

<div class="post-metadata">

**Author:** ![joeyk](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.mautic.org/joeyk/32/11164_2.png) [@joeyk](https://forum.mautic.org/u/joeyk)\
**Post date:** [November 16, 2022, 12:45pm UTC](https://forum.mautic.org/t/what-about-ma-campaign-lead-event-log-date-triggered-as-iso-to-microseconds/26085/4 "2022-11-16T12:45:38Z")

</div>

Yeah I see your point.  
I would also want to see the event in the right order.  
I hope you can push it through.

---

<div class="post-metadata">

**Author:** ![xmontero](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.mautic.org/xmontero/32/7499_2.png) [@xmontero](https://forum.mautic.org/u/xmontero)\
**Post date:** [November 16, 2022, 12:53pm UTC](https://forum.mautic.org/t/what-about-ma-campaign-lead-event-log-date-triggered-as-iso-to-microseconds/26085/5 "2022-11-16T12:53:09Z")

</div>

Cannot join Slack. Something broken in the mautic website.

After entering my email address in the invite box and click, it says:

 ![image](https://us1.discourse-cdn.com/flex020/uploads/mautic/original/2X/c/cad60d786f97fab068a822b6c96400d392f63c49.png)

---

<div class="post-metadata">

**Author:** ![joeyk](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.mautic.org/joeyk/32/11164_2.png) [@joeyk](https://forum.mautic.org/u/joeyk)\
**Post date:** [November 16, 2022, 12:56pm UTC](https://forum.mautic.org/t/what-about-ma-campaign-lead-event-log-date-triggered-as-iso-to-microseconds/26085/6 "2022-11-16T12:56:09Z")

</div>

I wrote about it on slack, let’s hope someone can see it.

---

<div class="post-metadata">

**Author:** ![xmontero](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.mautic.org/xmontero/32/7499_2.png) [@xmontero](https://forum.mautic.org/u/xmontero)\
**Post date:** [November 16, 2022, 1:02pm UTC](https://forum.mautic.org/t/what-about-ma-campaign-lead-event-log-date-triggered-as-iso-to-microseconds/26085/7 "2022-11-16T13:02:57Z")

</div>

Thanks, Joey!
