Discussions

Hi,

I have a question about querying work orders that have been modified or created in the last 24 hours.

Initially, we used LastActionDateUtc to capture the latest updates and new work orders. However, we found that this field does not update for all action types. So, we switched to using ActionLogRecords.SystemDateUtc as our query filter, which successfully captures all updates. However, we are now pulling a large number of old work orders that only have an "Archived" TypeId action log entry for the queried date. This is significantly increasing our response volume.

We tested adding ActionLogRecords.TypeId NotEqual "Archived" to our query conditions and it worked to filters out those archived records. But, before we go ahead with this approach, I have a couple of questions:

1. What does the "Archived" TypeId in action log records represent? Does it indicate any meaningful update to the work order data, or is it purely a system housekeeping action?
2. Are there any downsides or risks to filtering out "Archived" action log records from our query? Could we miss any work orders that have real updates alongside an archive action?