Suitecrm: 7.11.8 Report Paramter not working

[Lehnerr]

Issue

I've created a report with a condition(modification Time) as parameter. When I run the report condition works fine.

As soon I select a different date and click on Update.

After Update the filter is cleared and all entries get displayed:

Expected Behavior

Filter should be get applied.

Actual Behavior

Possible Fix

Steps to Reproduce

1. create report with modification time filed as condition and as parameter
   2.
   3.
   4.

Context

Your Environment

• SuiteCRM Version used: 7.11.8
• Browser name and version (e.g. Chrome Version 51.0.2704.63 (64-bit)): actulal Firefox
• Environment name and version (e.g. MySQL, PHP 7): 7.0
• Operating System and version (e.g Ubuntu 16.04): Ubunto 16.04

[pavithra-selvam]

Hi
Yes I'm also facing this issue. if we use date field its working fine, otherwise date time field is not working.

[LeoZandvliet]

In my experience the only accepted date format in the parameter field is the database format yyyy-mm-dd. After saving the displayed value gets scrambled by some viewing mechanism. My workaround: remove those conditions as parameter and edit the report each time you want to create an different export (in my case I have to keep using the yyyy-mm-dd format).

[pavithra-selvam]

Hi @Lehnerr,
I found solution for this, myself its working fine. Can you please check and use it.
Version: 7.11.8
File Path: modules/AOR_Reports/AOR_Report.js
Line No:107
Add this below line
if($('#aor_conditions_value' + ln + '_date').hasClass('datetimecombo_date')) { fieldInput = $('#aor_conditions_value' + ln + '_date').val()+" "+$('#aor_conditions_value' + ln + '_hours').val()+":"+$('#aor_conditions_value' + ln + '_minutes').val(); }
like this
else { if($('#aor_conditions_value' + ln + '_date').hasClass('datetimecombo_date')) { fieldInput = $('#aor_conditions_value' + ln + '_date').val()+" "+$('#aor_conditions_value' + ln + '_hours').val()+":"+$('#aor_conditions_value' + ln + '_minutes').val(); } else { fieldInput = $("#aor_conditions_value\\[" + ln + "\\]").val(); } }

[gunnicom]

@LeoZandvliet I thought this problem was fixed, but would not be surprised if it is still there https://github.com/salesagility/SuiteCRM/issues/1624

[Dillon-Brown]

@gunnicom Yeah I remember this being fixed a few times as well.... It would be good to get some acceptance testing for this.

[Lehnerr]

Hi. @pavithra-selvam
The modification helps. It works now with DATE/Time paramter.
Would be great to get this in the next release.
thx

[Lehnerr]

A further problem occurs with parameter now . I've selected a text field or a relate field the values get cleared when I klick update.

[pavithra-selvam]

A further problem occurs with parameter now . I've selected a text field or a relate field the values get cleared when I klick update.

Hi @Lehnerr ,
I'm not able to reproduce, Can you please share screen shot for references.
Which version you are tested?

[Lehnerr]

It' solved, i forgott the last else statement
THX.