salesagility / SuiteCRM

SuiteCRM - Open source CRM for the world
https://www.suitecrm.com
GNU Affero General Public License v3.0
4.53k stars 2.09k forks source link

Unable to update parameters on reports #10561

Open kale1d0code opened 3 weeks ago

kale1d0code commented 3 weeks ago

Issue

It is not possible to update parameters on a report. If a user presses update on a Report detail view, the screen will refresh with an empty result

Possible Fix

undo any changes which prevent AOR Reports parameters from updating

Steps to Reproduce the Issue

1. create a report with parameters
2. view the report
3. press update
...

Context

makes reports much harder to use. users have to create duplicated reports with different default values for the parameters to regain similar functionality.

Version

7.14.4

What browser are you currently using?

Chrome

Browser Version

Google Chrome Version 129.0.6668.89 (Official Build) (64-bit)

Environment Information

MariaDB 10.9.4 | PHP 8.1.29

Operating System and Version

Debian GNU/Linux 10 (buster)

kale1d0code commented 3 weeks ago

After looking into this more closely, It seems to be a misunderstanding between the wording in the operators and the way they behave with different field types.

If an end-user uses the equals operator, updating parameters breaks the report. when using the one of operator, the report behaves as expected.

pgorod commented 2 weeks ago

Is this reproducible in the live demo?

kale1d0code commented 2 weeks ago

@pgorod I tested this against a text-field however I couldn't find any modules with a multiselect field in the live demo