starred/SuiteCRM-SuiteCRM

mirror of https://github.com/SuiteCRM/SuiteCRM.git synced 2026-03-02 19:16:58 -05:00

Report conditions equal to related module not working #5327

New issue

Open

opened 2026-02-20 16:59:40 -05:00 by deekerman · 0 comments

deekerman commented

2026-02-20 16:59:40 -05:00

Owner

Originally created by @gunnicom on GitHub (Jun 13, 2025).

Issue

SuiteCRM 7.14.6
Reproducible on the demo instance of SuiteCRM.

Steps to reproduce:

Create a Report for Module "Accounts"
Add some Fields
Create a condition "Account->Contact->Department" "Equals" "Annual Revenue"

Report will fail because the query builder wuilds the WHERE condition as if "Annual Revenue" is in the "Contact" table

Possible Fix

No response

Steps to Reproduce the Issue

1.
2.
3.
...

Context

No response

Version

7.14.6

What browser are you currently using?

Chrome

Browser Version

No response

Environment Information

PHP 8.2

Operating System and Version

Ubuntu 24.04

Originally created by @gunnicom on GitHub (Jun 13, 2025). ### Issue SuiteCRM 7.14.6 Reproducible on the demo instance of SuiteCRM. Steps to reproduce: - Create a Report for Module "Accounts" - Add some Fields - Create a condition "Account->Contact->Department" "Equals" "Annual Revenue" Report will fail because the query builder wuilds the WHERE condition as if "Annual Revenue" is in the "Contact" table ### Possible Fix _No response_ ### Steps to Reproduce the Issue ```bash 1. 2. 3. ... ``` ### Context _No response_ ### Version 7.14.6 ### What browser are you currently using? Chrome ### Browser Version _No response_ ### Environment Information PHP 8.2 ### Operating System and Version Ubuntu 24.04

deekerman added the

Priority:Important

Severity: Major

labels

2026-02-20 16:59:40 -05:00

Sign in to join this conversation.

No labels

Area: Campaigns

Area: Clean Up: Performance

Area: Databases

Area: Developer Tools

Area: Elasticsearch

Area: Elasticsearch

Area: Emails:Campaigns

Area: Emails:Cases

Area: Emails:Compose

Area: Emails:Config

Area: Emails:Templates

Area: Environment

Area: Installation

Area: Upgrading

Area:Activity Stream

Good First Issue

PR:Community Contribution

PR:Type:Enhancement

Priority:Critical

Priority:Important

Priority:Moderate

Severity: Major

Severity: Minor

Severity: Moderate

Status: Requires Code Review

Status: Requires Updates

Status: Team Investigating

Status:Assessed

Status:Fix Proposed

Status:Needs Assessed

Status:Requires Automated Tests

Type:Deprecated

Type:Discussion

Type:Suggestion

Type:Suggestion

No milestone

No project

No assignees

1 participant

Notifications

Due date

The due date is invalid or out of range. Please use the format "yyyy-mm-dd".

No due date set.

Dependencies

No dependencies set.

Reference

starred/SuiteCRM-SuiteCRM#5327

No description provided.