# Ability to query activity log as a normal DB

**URL:** <https://community.fibery.io/t/ability-to-query-activity-log-as-a-normal-db/9425>\
**Category:** Ideas & Features\
**Created:** [August 19, 2025, 2:38pm UTC](https://community.fibery.io/t/ability-to-query-activity-log-as-a-normal-db/9425 "2025-08-19T14:38:03Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![mkhsv](https://sea2.discourse-cdn.com/flex020/user_avatar/community.fibery.io/mkhsv/32/12462_2.png) [@mkhsv](https://community.fibery.io/u/mkhsv)\
**Post date:** [August 19, 2025, 2:38pm UTC](https://community.fibery.io/t/ability-to-query-activity-log-as-a-normal-db/9425/1 "2025-08-19T14:38:03Z")

</div>

To be able to chart the number of tasks created, the number of active records certain users work on, etc. Basically, to query this like a normal DB. But for admins and privileged users.

---

<div class="post-metadata">

**Author:** ![RonMakesSystems](https://sea2.discourse-cdn.com/flex020/user_avatar/community.fibery.io/ronmakessystems/32/14122_2.png) [@RonMakesSystems](https://community.fibery.io/u/RonMakesSystems)\
**Post date:** [August 19, 2025, 2:57pm UTC](https://community.fibery.io/t/ability-to-query-activity-log-as-a-normal-db/9425/2 "2025-08-19T14:57:21Z")

</div>

Not exactly what you are looking for, but “Historical Reports” do a lot of this. They query the data in the activity log to make reports.

---

<div class="post-metadata">

**Author:** ![mdubakov](https://sea2.discourse-cdn.com/flex020/user_avatar/community.fibery.io/mdubakov/32/10_2.png) [@mdubakov](https://community.fibery.io/u/mdubakov)\
**Post date:** [August 19, 2025, 3:02pm UTC](https://community.fibery.io/t/ability-to-query-activity-log-as-a-normal-db/9425/3 "2025-08-19T15:02:35Z")

</div>

Ron is right, this can maybe help

> **[Current vs Historical data in Reports](https://the.fibery.io/@public/User_Guide/Guide/Current-vs-Historical-data-in-Reports-168)**

> **[Historical and Cumulative Report examples](https://the.fibery.io/@public/User_Guide/Guide/Historical-and-Cumulative-Report-examples-59)**

---

<div class="post-metadata">

**Author:** ![helloitse](https://sea2.discourse-cdn.com/flex020/user_avatar/community.fibery.io/helloitse/32/498_2.png) [@helloitse](https://community.fibery.io/u/helloitse)\
**Post date:** [August 20, 2025, 9:18pm UTC](https://community.fibery.io/t/ability-to-query-activity-log-as-a-normal-db/9425/4 "2025-08-20T21:18:50Z")

</div>

Do historical reports track whetehr checkboxes have been checked now?  
I had to rework a few databases to use state fields after the fact and it skewed the accuracy of my data.