I am making a call to my XData server with the following filter (although that's not the issue - I don't think)
$filter=((Visibility eq 'Everyone') or (Visibility eq 'AnyAdmin') or ((SubmittedBy eq 101) or (OwnedBy eq 101))) and (((Status eq 'New') or (Status eq 'Queued') or (Status eq 'Processing') or (Status eq 'Processed')) or (((Status eq 'Complete') or (Status eq 'Failed')) and (DateCompleted ge '2021-11-17')))&$OrderBy=DateSubmitted
This works most of the time and is called using a timer on a WebCore, but a client testing the system had the following exception
Status code: 500 Error Code: IBNativeException [FireDAC][Phys][FB]Attempt to reclose a closed cursor | fMessage::XData server request error. Uri: [as above]
Any ideas? thanks.