2 followers Follow

Data Query API sub query failed general database error


We have DEPT field on the task level. Multiple tasks could have same DEPT. If one of the tasks with same DEPT is changed by user today, we want to retrieve all the tasks for that same DEPT. 

Trying the below query but it is throwing general database error

q:"Select Name, LastUpdatedOn, CreatedOn, CreatedBy.Name, LastUpdatedBy.Name, C_DEPTID FROM Task WHERE C_DEPTID in (SELECT C_DEPTID FROM Task WHERE LastUpdatedOn = '08/24/2021')", paging: {"limit":10}


Vishal Patel Answered

Official comment


Hi Vishal,

Are you still experiencing this error? If so, could you please provide the reference ID?

Thank you,


Roland Pumputis
Comment actions Permalink

Please sign in to leave a comment.

1 comment