Victor Romero created FINERACT-2535:
---------------------------------------
Summary: Data type 'BOOLEAN' is not supported in runreports
endpoints
Key: FINERACT-2535
URL: https://issues.apache.org/jira/browse/FINERACT-2535
Project: Apache Fineract
Issue Type: Task
Reporter: Victor Romero
Data type 'BOOLEAN' is not supported in runreports endpoints
Database MariaDB version 12
Step to reproduce
1. Create a Custom SQL Report
SELECT * from m_client
POST
https://\{URL_BASE}/fineract-provider/api/v1/reports
{"reportName":"TEST_REPORT","reportCategory":"","description":"","reportType":"Table","useReport":true,"reportSql":"select
* from m_client","reportParameters":[]}
Run it
GET on https://\{BASE_URL}/fineract-provider/api/v1/runreports/LIST_CLIENTS
Response
{
"developerMessage": "The server is currently unable to handle the request ,
please try after some time.",
"httpStatusCode": "503",
"defaultUserMessage": "The server is currently unable to handle the request
, please try after some time.",
"userMessageGlobalisationCode": "error.msg.platform.service.unavailable",
"errors": [
{
"defaultUserMessage": "Data type 'BOOLEAN' is not supported ",
"parameterName": "id",
"developerMessage": "Data type 'BOOLEAN' is not supported ",
"userMessageGlobalisationCode":
"error.msg.database.type.not.supported",
"args": []
}
]
}
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
