DB syntax error when try to search deleted cases
Overview
Fix DB syntax error when try to search deleted cases.
Before
- open Cases > Find Cases
- select Deleted Cases checkbox
- click Search button
- result: DB Error: syntax error
After
Searching for deleted and non-deleted cases works fine.
Technical Details
There was invalid argument in getCaseActivityQuery() method - for $limit argument was used $cases['case_deleted']
-- invalid
$query = self::getCaseActivityQuery($type, $userID, $condition, $cases['case_deleted']);
-- fixed
$query = self::getCaseActivityQuery($type, $userID, $condition);