Reports with related fields return no records for non-admin user #2895

New issue

Closed

opened 2026-02-20 15:30:17 -05:00 by deekerman · 2 comments

deekerman commented

2026-02-20 15:30:17 -05:00

Owner

Originally created by @CBeechey on GitHub (Mar 22, 2018).

Issue

Report containing related field(s) returns no records for non-admin user in security group with appropriate permissions to view own/group records.

Appears to be a re-occurrence of https://github.com/salesagility/SuiteCRM/pull/3155, fixed in 7.8.2. Issue reappears from 7.8.10 onwards.

Expected Behavior

Report should return records assigned to user or user group

Actual Behavior

Report returns no records

Possible Fix

Steps to Reproduce

add non-admin user to security group with role giving access to appropriate modules.
assign appropriate records to user
create report with related field(s)
run report as non-admin user

Context

Your Environment

SuiteCRM Version used: 7.8.10 onwards
Browser name and version (e.g. Chrome Version 51.0.2704.63 (64-bit)):
Environment name and version (e.g. MySQL, PHP 7):
Operating System and version (e.g Ubuntu 16.04):

Originally created by @CBeechey on GitHub (Mar 22, 2018).    #### Issue  Report containing related field(s) returns no records for non-admin user in security group with appropriate permissions to view own/group records. Appears to be a re-occurrence of https://github.com/salesagility/SuiteCRM/pull/3155, fixed in 7.8.2. Issue reappears from 7.8.10 onwards. #### Expected Behavior  Report should return records assigned to user or user group #### Actual Behavior   Report returns no records #### Possible Fix  #### Steps to Reproduce   1. add non-admin user to security group with role giving access to appropriate modules. 2. assign appropriate records to user 3. create report with related field(s) 4. run report as non-admin user #### Context   #### Your Environment  * SuiteCRM Version used: 7.8.10 onwards * Browser name and version (e.g. Chrome Version 51.0.2704.63 (64-bit)): * Environment name and version (e.g. MySQL, PHP 7): * Operating System and version (e.g Ubuntu 16.04):

deekerman

2026-02-20 15:30:17 -05:00

closed this issue
added the
Type: Bug

Area: Reports
labels

deekerman commented

2026-02-20 15:30:19 -05:00

Author

Owner

@connorshea commented on GitHub (Sep 23, 2019):

I think this is the same as #7552? @Dillon-Brown Since this is a regression that's occurred more than once, it should probably have some tests.

@connorshea commented on GitHub (Sep 23, 2019): I think this is the same as #7552? @Dillon-Brown Since this is a regression that's occurred more than once, it should probably have some tests.

deekerman commented

2026-02-20 15:30:19 -05:00

Author

Owner

@johnM2401 commented on GitHub (Mar 17, 2025):

Hey!

Thank you for raising this issue.

I've given this a try in the latest release (7.14.6) and this appears to be working well.
I think this may have been resolved via the PR: https://github.com/salesagility/SuiteCRM/pull/7898

To test, I've created a Report on Accounts, with the related Contact Name as a selected field.
I can view this report as Admin, a Non-admin with Roles and a Non-admin without roles.

I'm going to close this off for now, but please let us know if you're still experiencing this issue in the latest releases.
Thank you for your contribution!

@johnM2401 commented on GitHub (Mar 17, 2025): Hey! Thank you for raising this issue. I've given this a try in the latest release (7.14.6) and this appears to be working well. I think this may have been resolved via the PR: https://github.com/salesagility/SuiteCRM/pull/7898 To test, I've created a Report on Accounts, with the related Contact Name as a selected field. I can view this report as Admin, a Non-admin with Roles and a Non-admin without roles. I'm going to close this off for now, but please let us know if you're still experiencing this issue in the latest releases. Thank you for your contribution!

deekerman referenced this issue

2026-02-20 16:03:32 -05:00

Email campaign always tries to use "sendmail", and puts them in "Email Queue". #3300