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

[Steve Kenow]

It's something to do with this instance, not the core. Testing on another
instance doesn't have this issue.

Sorry to trouble you.

*[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 Fri, Feb 2, 2024 at 8:28 AM Steve Kenow <skenow at rdspos.com> wrote:

> 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/bd6c903f/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/bd6c903f/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/bd6c903f/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/bd6c903f/attachment-0005.png>