GraphQL support for querying entity History / Activity Logs

API & Programming
1

If we had GraphQL support to query entity history / Activity Log, then we could make our own audit-log reports. Right now I see no good way to make audit investigations, like showing all changes made by a particular User in the past week.

Of course even better would be the ability to create such Views within Fibery :grinning_face:

1 Like
2

It would be amazing if we had more access to the activity log for entities and were able to leverage them in views to:

  • Identify entities where particular fields have changed within a timeframe (e.g. entities that had been assigned in the last week or entities where the last time the Phase changed was more than a month ago, … )
  • Identify entities based on the change itself (e.g. entities where the state had changed from Intake to In Progress or entities where the cost was increased by more than 5%, …)

It would also be great if you were able to access the information in automations to run actions:

  • Send a notification when value is changed from a certain value to another or when the magnitude of a change is within a certain threshold (e.g. the completion timeline for a task is extended by more than 2 weeks, or when an activity goes from “In Progress” to “On Hold” but not when it goes from “Intake” to “On Hold”)

There is a lot of insight and value in the change/audit log which is currently lost. I know we are able to use automation to create other entities to track changes, but that seems wasteful and redundant given that there is already a log.

I think being able to also query for changes using GraphQL would be a great interim options, so that we can at least generate these views externally.

2 Likes
Undo an automation or recover previous version of a rich text field/document
3

Our team members prepare small reports before daily meetings with tasks that have been moved to Ready to QA and Ready to Release, reassigned tasks, and so on. It would be great to have the ability to query entity history via API to do this automatically. I’ve found that Fibery AI assistant has access to history, and I’ve created a simple prompt to get this report, but it takes about 1.5 minutes for the assistant to answer. It writes code to query the activity log database every time and sometimes hallucinates.

Here is the prompt:

Please analyze the DEV Tasks database and for user ___ return this report (as a text) from the 3:30PM of ___ to 3:30PM of ___:

Bugs:
Fixed: {task keys}
Transferred: {task keys}
Rejected: {task keys}
Tasks:
Done: {task keys}

###
Fixed — entities with type = bug that have been moved to Ready to QA status
Transferred — entities that have been reassigned to another user.
Rejected — entities that have been moved to Rejected status
Done — entities with type = task that have been moved to Ready to QA status
###