We are trying to make a get call for checks and payments screen to get all the checks along with application history tab details within a date range.
I have provided the lastmodifieddatetime for date range filter and it is working fine but when i add the history object to the API URL, I’m getting optimization cannot be performed error in the GET call.
I have used below URL.
http://localhost/MyInstance/entity/Default/20.200.001/Check?$filter=LastModifiedDateTime ge datetimeoffset'2022-02-08T23:59:59.99Z' and LastModifiedDateTime le datetimeoffset'2022-02-13T23:59:59.99Z'&$expand=History
"message": "An error has occurred.",
"exceptionMessage": "Optimization cannot be performed.The following fields cause the error:\r\nHistory.AmountPaid: View APPost has BQL delegate\r\nHistory.Balance: View APPost has BQL delegate\r\nHistory.CashDiscountBalance: View APPost has BQL delegate\r\nHistory.CashDiscountTaken: View APPost has BQL delegate\r\nHistory.DocType: View APPost has BQL delegate\r\nHistory.ReferenceNbr: View APPost has BQL delegate\r\nHistory.VendorRef: View APPost has BQL delegate\r\n",
What is the issue here? Can anybody suggest the solution to get all the checks with history tab details with date range filter in API?
Best answer by praveenpoView original