[
https://issues.apache.org/jira/browse/FINERACT-2607?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=18081108#comment-18081108
]
Yvana Kengne commented on FINERACT-2607:
----------------------------------------
[~hysnije]
database has *no entries at all* for:
e{{{}num_name = 'status'{}}}
So this endpoint:
{{SELECT enum_id, enum_message_property}}
{{FROM r_enum_value}}
{{WHERE enum_name = 'status'}}
will {*}always return empty results{*}, which is exactly why
{{/audits/searchtemplate}} shows no statuses.{{ }}
> Statuses are never returned on the /audits/searchtemplate endpoints
> -------------------------------------------------------------------
>
> Key: FINERACT-2607
> URL: https://issues.apache.org/jira/browse/FINERACT-2607
> Project: Apache Fineract
> Issue Type: Bug
> Environment: Demo
> Reporter: Hysnije
> Priority: Major
> Attachments: image-2026-05-15-10-31-54-598.png
>
>
> Statuses on {{audits/searchtemplate}} endpoint are retrieved from the
> r_enum_value table
> [https://github.com/apache/fineract/blob/develop/fineract-provider/src/main/java/org/apache/fineract/commands/service/AuditReadPlatformServiceImpl.java#L504]
> but this table never persists values for "status" enum, hence statuses are
> never returned
> !image-2026-05-15-10-31-54-598.png!
>
> They were persisted on old migration files
> [https://github.com/apache/fineract/blob/develop/fineract-db/old-schema-files/0002-mifosx-base-reference-data-utf8.sql#L50-L55]
> but not on new ones
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
