Server error?

[worldmiros]

I created an entity called Expenses, and when I want to createview of the entity's scope, I get the error below. Not sure why
Server side error 200: SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') AND expenses.deleted = '0' ORDER BY expenses.created_at DESC LIMIT 0, 5' at line 3


( [controller] => Expense ) , InputData: - SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') AND expense.deleted = '0' ORDER BY expense.created_at DESC LIMIT 0, 5' at line 3 [] [] [2016-02-26 15:19:56] Espo.ERROR: Display Error: SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') AND expense.deleted = '0' ORDER BY expense.created_at DESC LIMIT 0, 5' at line 3, Code: 42000 URL: /espocrm/api/v1/Expense?maxSize=5&offset=0&sortBy=createdAt&asc=fa lse&where%5B0%5D%5Btype%5D=primary&where%5B0%5D%5B value%5D=planned&where%5B1%5D%5Btype%5D=equals&whe re%5B1%5D%5Bfield%5D=accountId&where%5B1%5D%5Bvalu e%5D=565392a3bc859bb99 [] []

[yuri]

Unfortunately I can't reproduce.

[worldmiros]

Can't reproduce the error? Based on the error logs, I might be missing a right parenthesis. Which file executes this query? Maybe, i figure how to rectify it.

[worldmiros]

Is there anything I can do to resolve this error?

[worldmiros]

issue resolved. 'filters' was the issue. I filter the scope based on the account in the quote entity, and expense doesn't have parent of account; it has parent of case/matter.