[
https://issues.apache.org/jira/browse/FINERACT-1630?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17545759#comment-17545759
]
Adam Saghy commented on FINERACT-1630:
--------------------------------------
{code:java}
// bad SQL grammar [select rule.id as id,rule.name as name, rule.office_id as
│
│ officeId,office.name as officeName, rule.description as description,
rule.system_defined as systemDefined, rule.allow_multiple_debits as
allowMultipleDebitEntries, rule.allow_multiple_c │
│ redits as allowMultipleCreditEntries, debitAccount.id AS debitAccountId,
debitAccount.name as debitAccountName, debitAccount.gl_code as
debitAccountGLCode, creditAccount.id AS creditAcc │
│ ountId, creditAccount.name as creditAccountName, creditAccount.gl_code as
creditAccountGLCode from m_office AS office, acc_accounting_rule AS rule LEFT
JOIN acc_gl_account AS creditAcc │
│ ount ON rule.credit_account_id = creditAccount.id LEFT JOIN acc_gl_account
AS debitAccount ON rule.debit_account_id = debitAccount.id WHERE
office.id=rule.office_id and system_defined │
│ =0 and office.hierarchy like ? order by rule.id asc]; nested exception is
org.postgresql.util.PSQLException: ERROR: operator does not exist: boolean =
integer │
│ Hint: No operator matches the given name and argument types. You might need
to add explicit type casts.
│
│ Position: 800] with root cause
│
│ org.postgresql.util.PSQLException: ERROR: operator does not exist: boolean =
integer
│
│ Hint: No operator matches the given name and argument types. You might need
to add explicit type casts.
│
│ Position: 800 {code}
> Not able to get Accounting Rules
> --------------------------------
>
> Key: FINERACT-1630
> URL: https://issues.apache.org/jira/browse/FINERACT-1630
> Project: Apache Fineract
> Issue Type: Bug
> Components: Accounting
> Affects Versions: 1.7.0
> Reporter: Ramveer
> Priority: Blocker
> Attachments: image-2022-06-02-16-46-43-176.png,
> image-2022-06-02-16-47-39-242.png
>
>
> {quote}{{GET
> [https://DomainName/api/v1/accountingrules|https://domainname/api/v1/accountingrules]
> }}
> {{GET
> }}{{{}[https://DomainName/api/v1/accountingrules?associations=all|https://domainname/api/v1/accountingrules]{}}}{{{}{}}}
> {quote}
> {{This GET API is failing to give 500 internal server error. This API in
> earlier versions was giving correct results. There seems some issue in this
> version.}}
> {{Screenshots are attached.}}
> {{!image-2022-06-02-16-47-39-242.png!}}
> {{!image-2022-06-02-16-46-43-176.png!}}
--
This message was sent by Atlassian Jira
(v8.20.7#820007)
