[Vtigercrm-developers] Results for filters on dates in reports not matching filters in lists - v7.5.0

[Steve Kenow]

A little more information - I've created a completely new report using the
same primary/secondary modules and conditions. The issue still occurs when
changing the date interval and regenerating the report. When I remove the
organization module and only use the ticket module as the basis for the
report, the recalculation occurs properly when changing the data interval.
To change, add, or remove conditions (any condition) with multiple modules,
I have to click on Customize and go through all the steps to get an
accurate report.

*[image: RDS Logo]*
*Steve Kenow*
Manager, End-User Services and Support - RDS MN
<https://www.rdspos.com/Minneapolis-Minnesota-Grocery-Point-of-Sale-System>
Direct: (952) 392-2686
Office: (952) 934-4001
Email: skenow at rdspos.com

[image: Icon 1]
<https://mailtrack.io/trace/link/d5e46ac8cfdec7b8ebdc539696dd45306644b800?w=anNrb2xha0ByZHNwb3MuY29t&url=https%3A%2F%2Fwww.rdspos.com%2FProducts-Solutions%2FGrocery&userId=3091118&signature=18b062316c510b1b>
[image:
Icon 2]
<https://mailtrack.io/trace/link/b0fdfdd837e0d187e174cae0c9479c9b847c4e36?w=anNrb2xha0ByZHNwb3MuY29t&url=https%3A%2F%2Fwww.rdspos.com%2FProducts-Solutions%2FQuick-Service%2FPoint-of-Sale-Solutions&userId=3091118&signature=b26cf2b23255a2a2>
[image:
Icon 3]
<https://mailtrack.io/trace/link/9c1116af49d5de3a851b38185dbd7ba07d27def2?w=anNrb2xha0ByZHNwb3MuY29t&url=https%3A%2F%2Fwww.rdspos.com%2FProducts-Solutions%2FRestaurant%2FPoint-of-Sale-Solutions&userId=3091118&signature=78db9a7d4392c7ed>
[image:
Icon 4]
<https://mailtrack.io/trace/link/c5c6a63b04b163898650fb7e2fdd7312ca923cdf?w=anNrb2xha0ByZHNwb3MuY29t&url=https%3A%2F%2Fwww.rdspos.com%2FProducts-Solutions%2FGeneral-Retail&userId=3091118&signature=1ec7a1d9db94a0f1>
[image:
Icon 5]
<https://mailtrack.io/trace/link/9d0a121b09b0d5e1ba1c5be04c5c2b8d969b7d2c?w=anNrb2xha0ByZHNwb3MuY29t&url=https%3A%2F%2Fwww.rdspos.com%2FProducts-Solutions%2FConvenience-Store%2FNCR-Radiant-Convenience-Store-POS-System&userId=3091118&signature=112f29b42fe5a787>
[image:
Icon 6]
<https://mailtrack.io/trace/link/16b4ffb1c4363203009e09666cb41ce82f3a39c1?w=anNrb2xha0ByZHNwb3MuY29t&url=https%3A%2F%2Fwww.rdspos.com%2FProducts-Solutions%2FRDS-Payment-Services&userId=3091118&signature=84ffb1248e80fb55>
------------------------------

Support Questions/Issues? Email rdshelp at rdspos.com (non-emergencies) or
call (952) 934-4002 24/7


On Thu, Feb 1, 2024 at 3:01 PM Steve Kenow <skenow at rdspos.com> wrote:

> Has anyone else seen this happen? We recently migrated to 7.5.0 from 6.5.0
> and we're working through a handful of things, the latest of which is when
> I run a report that filters the results by date (createdtime), the number
> of records doesn't match what I get with the same criteria in list view,
> and the result indicator can be 0 (zero) when there are results. Exporting
> to see how many records there are when it shows is unproductive - 0 rows
> are exported.
>
> And, if I search for create dates in the previous year, no records are
> returned, not even in the list.
>
> Report results - primary module is Organizations, secondary is Tickets
>
> [image: image.png]
>
> When I change the date range to extend it, then the results are wrong -
> [image: image.png]
>
> But - there are records shown. 🤷
>
> [image: image.png]
>
> I've seen issues for the date selector, which is working. I've also seen
> issues for the user's date format being different than the creator of the
> report - I've tested and that's not affecting this.
>
> Now, one thing I just thought of - the dates I'm searching in the past are
> records that were created on vTiger 6.5.0. The upgrade was performed on
> January 6-7. Testing that theory, I ran the report for January 1 - 6 and
> got all the results and the proper number of records at the top.
>
> Is it a data problem?
>
> *[image: RDS Logo]*
> *Steve Kenow*
> Manager, End-User Services and Support - RDS MN
> <https://www.rdspos.com/Minneapolis-Minnesota-Grocery-Point-of-Sale-System>
> Direct: (952) 392-2686
> Office: (952) 934-4001
> Email: skenow at rdspos.com
>
> [image: Icon 1]
> <https://mailtrack.io/trace/link/d5e46ac8cfdec7b8ebdc539696dd45306644b800?w=anNrb2xha0ByZHNwb3MuY29t&url=https%3A%2F%2Fwww.rdspos.com%2FProducts-Solutions%2FGrocery&userId=3091118&signature=18b062316c510b1b> [image:
> Icon 2]
> <https://mailtrack.io/trace/link/b0fdfdd837e0d187e174cae0c9479c9b847c4e36?w=anNrb2xha0ByZHNwb3MuY29t&url=https%3A%2F%2Fwww.rdspos.com%2FProducts-Solutions%2FQuick-Service%2FPoint-of-Sale-Solutions&userId=3091118&signature=b26cf2b23255a2a2> [image:
> Icon 3]
> <https://mailtrack.io/trace/link/9c1116af49d5de3a851b38185dbd7ba07d27def2?w=anNrb2xha0ByZHNwb3MuY29t&url=https%3A%2F%2Fwww.rdspos.com%2FProducts-Solutions%2FRestaurant%2FPoint-of-Sale-Solutions&userId=3091118&signature=78db9a7d4392c7ed> [image:
> Icon 4]
> <https://mailtrack.io/trace/link/c5c6a63b04b163898650fb7e2fdd7312ca923cdf?w=anNrb2xha0ByZHNwb3MuY29t&url=https%3A%2F%2Fwww.rdspos.com%2FProducts-Solutions%2FGeneral-Retail&userId=3091118&signature=1ec7a1d9db94a0f1> [image:
> Icon 5]
> <https://mailtrack.io/trace/link/9d0a121b09b0d5e1ba1c5be04c5c2b8d969b7d2c?w=anNrb2xha0ByZHNwb3MuY29t&url=https%3A%2F%2Fwww.rdspos.com%2FProducts-Solutions%2FConvenience-Store%2FNCR-Radiant-Convenience-Store-POS-System&userId=3091118&signature=112f29b42fe5a787> [image:
> Icon 6]
> <https://mailtrack.io/trace/link/16b4ffb1c4363203009e09666cb41ce82f3a39c1?w=anNrb2xha0ByZHNwb3MuY29t&url=https%3A%2F%2Fwww.rdspos.com%2FProducts-Solutions%2FRDS-Payment-Services&userId=3091118&signature=84ffb1248e80fb55>
> ------------------------------
>
> Support Questions/Issues? Email rdshelp at rdspos.com (non-emergencies) or
> call (952) 934-4002 24/7
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.vtigercrm.com/pipermail/vtigercrm-developers/attachments/20240202/7d8a0c17/attachment-0001.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image.png
Type: image/png
Size: 37199 bytes
Desc: not available
URL: <http://lists.vtigercrm.com/pipermail/vtigercrm-developers/attachments/20240202/7d8a0c17/attachment-0003.png>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image.png
Type: image/png
Size: 31832 bytes
Desc: not available
URL: <http://lists.vtigercrm.com/pipermail/vtigercrm-developers/attachments/20240202/7d8a0c17/attachment-0004.png>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image.png
Type: image/png
Size: 132932 bytes
Desc: not available
URL: <http://lists.vtigercrm.com/pipermail/vtigercrm-developers/attachments/20240202/7d8a0c17/attachment-0005.png>