Relative `TimestampCreated` filter not working

[emenslin]

Describe the bug
Original issue #7021, related to #7032. In query builder if you query on timestampCreated and use a relative filter (i.e. greater than 7 days in the past) all results are returned instead of the actual count. In statistics under the digitization category the counts show every record for each result instead of the actual count.

To Reproduce
Steps to reproduce the behavior:

In stats:

1. Delete collection preferences
2. Go to stats
3. Refresh the page
4. See incorrect counts.

In query builder:

1. Go to query buider
2. Select Collection Object
3. Add timestamp created
4. Select a filter (i.e. greater than)
5. Switch to relative date
6. Put in any parameter (i.e. 7 days in the past)
7. See all results retured

Expected behavior
Digitization counts should reflect the actual counts

Screenshots

Stats:

07-21_11.37.mp4

Query builder in main:

Query builder in 7.10.2.3:

Please fill out the following information manually:

• OS: Windows 11
• Browser: Chrome
• Specify 7 Version: 7.11.1
• Database Name: ojsmnh_2025_07_17
• Collection name: fossil invertebrates
• User Name: spadmin
• URL: https://ojsmnh20250717-main.test.specifysystems.org/specify/

[melton-jason]

This was because the changes from #7032 were never merged into main:

https://github.com/specify/specify7/pulls?q=is%3Apr+is%3Aopen+head%3Av7_11_0

main...v7_11_0

It's also not included in a v7.11.0+ release:
v7.11.0.2...v7_11_0

Was #7032 supposed to be included as a v7.11.0+ release? Or is it meant for v7.11.1? Either way, currently the chages from #7032 are on an isolated branch that is neither in v7.11.1 or v7.11.0.2.

[acwhite211]

Made a PR to apply the commits made to the v7.11 branch to main #7162