[Mifos-issues] [JIRA] (MIFOSX-353) datetime column in custom table report causes violation

Mon, 13 May 2013 12:08:33 -0700

Issue Type: Bug Bug
Assignee: keithwoodlock
Created: 13/May/13 12:07 PM
Description:

If a datetime column is referenced in a custom report it gives a reference integrity on the datetime column, as it is trying to cast it as a date.

This happens with data in tables such as m_note or acc_gl_journal_entry where lastmodified_date or created_date are set as datetime.

Example to recreate:
INSERT INTO `stretchy_report` (`report_name`, `report_type`, `report_subtype`, `report_category`, `report_sql`, `description`, `core_report`, `use_report`)
VALUES ('Test', 'Table', NULL, NULL, 'select * from m_note', NULL, 0, 0);

Then run:
/api/v1/runreports/Test

Result:
{
"developerMessage": "The request caused a data integrity issue to be fired by the database.",
"httpStatusCode": "403",
"defaultUserMessage": "Invalid Lookup Type:DATETIME - Column Name: created_date",
"userMessageGlobalisationCode": "error.msg.invalid.lookup.type",
"errors": [

{ "developerMessage": "Invalid Lookup Type:DATETIME - Column Name: created_date", "defaultUserMessage": "Invalid Lookup Type:DATETIME - Column Name: created_date", "userMessageGlobalisationCode": "error.msg.invalid.lookup.type", "parameterName": "", "value": null, "args": [] }

]
}
Project: Mifos X
Priority: Minor Minor
Reporter: Sander van der Heyden
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira 
------------------------------------------------------------------------------
AlienVault Unified Security Management (USM) platform delivers complete
security visibility with the essential security capabilities. Easily and
efficiently configure, manage, and operate all of your security controls
from a single console and one unified framework. Download a free trial.
http://p.sf.net/sfu/alienvault_d2d
_______________________________________________
Mifos-issues mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/mifos-issues

Reply via email to