I’m able to filter on any string mapped field but when I filter on a DateTimeValue mapped field, I get this error:
"exceptionMessage": "A binary operator with incompatible types was detected. Found operand types 'Edm.DateTimeOffset' and 'Edm.String' for operator kind 'Equal'."
Question: is there a specific way to filter on a datetime field?
"exceptionMessage": "Optimization cannot be performed.The following fields cause the error:\r\nCarrier: View Results has BQL delegate\r\nQty: View Results has BQL delegate\r\nServices: View Results has BQL delegate\r\nTrackingNumber: View Results has BQL delegate\r\nInventoryID: View Results has BQL delegate\r\nPOReceiptLine_lastModifiedDateTime: View Results has BQL delegate\r\nPOOrderNbr: View Results has BQL delegate\r\nReceiptNbr: View Results has BQL delegate\r\n"
{URL}}/entity/20.200.001/PurchaseOrder?$filter=LastModifiedDateTime ge datetimeoffset'2014-04-15' and LastModifiedDateTime le datetimeoffset'2022-04-29'
{URL}}/entity/20.200.001/PurchaseOrder?$filter=LastModifiedDateTime ge datetimeoffset'2014-04-15' and LastModifiedDateTime le datetimeoffset'2022-04-29'
This works fine for no-Generic Inquires using the Default entity. However, my question was for Generic Inquires like this (POReceiptPackages is my Generic Inquiry name):
https://sandbox.com/entity/INStockItem/22.200.001/POReceiptPackages?$filter=POReceiptLine_lastModifiedDateTime ge datetimeoffset'2024-06-03'
I receive this error back:
"exceptionMessage": "Optimization cannot be performed.The following fields cause the error:\r\nCarrier: View Results has BQL delegate\r\nQty: View Results has BQL delegate\r\nServices: View Results has BQL delegate\r\nTrackingNumber: View Results has BQL delegate\r\nInventoryID: View Results has BQL delegate\r\nPOReceiptLine_lastModifiedDateTime: View Results has BQL delegate\r\nPOOrderNbr: View Results has BQL delegate\r\nReceiptNbr: View Results has BQL delegate\r\n"
"exceptionMessage": "Optimization cannot be performed.The following fields cause the error:\r\nCarrier: View Results has BQL delegate\r\nQty: View Results has BQL delegate\r\nServices: View Results has BQL delegate\r\nTrackingNumber: View Results has BQL delegate\r\nInventoryID: View Results has BQL delegate\r\nPOReceiptLine_lastModifiedDateTime: View Results has BQL delegate\r\nPOOrderNbr: View Results has BQL delegate\r\nReceiptNbr: View Results has BQL delegate\r\n"
This works fine for no-Generic Inquires using the Default entity. However, my question was for Generic Inquires like this (POReceiptPackages is my Generic Inquiry name):
https://sandbox.com/entity/INStockItem/22.200.001/POReceiptPackages?$filter=POReceiptLine_lastModifiedDateTime ge datetimeoffset'2024-06-03'
GIs should use standard oData filters. Have you tried datetime’2024-06-03’
We use 3 different kinds of cookies. You can choose which cookies you want to accept. We need basic cookies to make this site work, therefore these are the minimum you can select. Learn more about our cookies.
