[
https://issues.apache.org/jira/browse/FINERACT-2535?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=18069168#comment-18069168
]
Leonardo Alunno commented on FINERACT-2535:
-------------------------------------------
Hi! I am a GSoC 2026 applicant and I'm working on this task as part of my
contribution evidence. Could a committer please add the
*{{gsoc-fineract-evidence}}* label to this ticket?
I'd like it to be correctly indexed in the project's GSoC tracking list so that
mentors can easily review my work and progress during the evaluation period. I
don't have the permissions to edit labels myself. Thank you!
> Data type 'BOOLEAN' is not supported in runreports endpoint
> -----------------------------------------------------------
>
> Key: FINERACT-2535
> URL: https://issues.apache.org/jira/browse/FINERACT-2535
> Project: Apache Fineract
> Issue Type: Task
> Reporter: Victor Romero
> Priority: Major
>
> 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)