Skip to content

Report fails when using a date field with “plus” or “minus” value filters #10744

@urdhvatech

Description

@urdhvatech

Issue

When creating or running a report that includes a date-type field, the report fails to execute properly if the filter condition uses relative date values such as “plus” or “minus”

Image

Possible Fix

Pull Request Created
SuiteCRM/SuiteCRM-Core#796

Steps to Reproduce the Issue

1.Go to Reports module.
2.Create a new report on any module that has a Date field.
3.In the conditions choose the date field and operator as Equal, Type = Date and set a condition value Today using plus or minus (for example, “Date is greater than Today +7 days”).
4. when you click on Update button to retrieve result. 
5. It will show you blank page.
...


### Context

_No response_

### Version

8.9.0

### What browser are you currently using?

Chrome

### Browser Version

Version 142.0.7444.60

### Environment Information

MySql, PHP8.2

### Operating System and Version

Linux

Metadata

Metadata

Assignees

No one assigned

    Labels

    Area: ReportsIssues & PRs related to all things regarding reportsPriority:ImportantIssues & PRs that are important; broken functions, errors - there are workaroundsSeverity: MajorSignificant impact/severe disruptionStatus:Fix ProposedA issue that has a PR related to it that provides a possible resolutionType: BugBugs within the core SuiteCRM codebase

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions