Dynamic Reports and Interactive Charts. A powerful tool for SuiteCRM report creation and data analytics. Includes a variety of chart types, detailed, summary and pivot tables. This Reporting Tool is very user-friendly, no need for technical knowledge or SQL. The Sapiens.BI tool comes with over 100 pre-built reports that are ready to be used on day one.
#176 - Filter with "between" and datetimecombo-field not working correctly
Hello,
I'm trying to create a filter on a datetimecombo field with "between" but it's not working.
In the log-File I see the the following SQL:
SELECT t0.`id` AS `0_Incidents_id` , t0.`incident_date` AS `0_Incidents_incident_date` FROM incidents AS t0 WHERE (1=1 AND (1=1 AND `t0`.`incident_date` >= '2016-09-01' AND `t0`.`incident_date` <= '1') ) AND (1=1 ) LIMIT 0, 20
Looks like time values and second date will be ignored completely. Could you please check if there is an error on your code?
Thanks in advance, armin
palaphonOther add-ons of interest
Reporting
reports
reporting
analytics
reporting analytics
report analytics
data analytics
sale analytics
sales analytics
analytic reports
analytic reporting
Report
pivot tables
matrix
summary report
charting
sugarcrm charts
advanced reporting
sugarcrm reporting
sugarcrm advanced reporting
sugarcrm analytic reporting
sugarcrm analytic reporting tool
analytic reporting tool
reporting tool
advanced reporting tool
sapiens.bi
sapiensbi
7 years ago
Hello Armin,
Thank you for the feedback. We will take a look at this and let you know!
Best Regards, IT Sapiens Team
7 years ago
Hello Armin,
We have tried to get this issue reproduced on our side all possible ways - same version same module, same field, same date & time, but no luck, i.e. - it works correctly for us.
So the question is, can we get some temporary access to your system (we can start with admin user access to SuiteCRM, if lucky, we will need no more, otherwise we would need access to files as well). Or we can try to schedule TeamViewer session. BE CAREFUL, please do not send the access in here, as this is visible to public, please e-mail it to info@itsapiens.eu.
P.S. Sorry for being slow during holiday season. P.S2. HAPPY NEW YEAR, ARMIN!!! ;)
Best Regards, IT Sapiens Team
7 years ago
Hi IT Sapiens
First of all: Happy new year!!
No it's not possible to enable temporary access to the system from our customer. But I did another test with a default module on SuiteCRM and I reproduced the same issue.
Steps to reproduce the error: - Add some entries on module "Calls" in SuiteCRM. Insert some dummy data and set the start date/time. - Goto report builder and create a new report on module "Calls":
- Goto report and add some fields to display all results. You should see all calls.
- Add a filter on date_start with "between"-filter. No results will be displayed.
In the log-Files you'll find the following query:
Tested on SuiteCRM Version 7.2.2.
Thanks for your help, armin
7 years ago
Hello Armin,
Thank you for a good description, this helped us to identify and solve it. The issue is now fixed for the Basic version, you can upload it from SuiteCRM store, - please let us know, if you need any help here.
Best Regards, IT Sapiens Team
7 years ago
Hi IT Sapiens Team
New package resolved the issue.
Thanks for your support, armin