You’re offline. This is a read only version of the page.
Hi.
if you try to use a DateTime filter, this results in "An error has occurred. The type 'System.DateTimeOffset' for the query operator is not Queryable!"
E.g. /data/Customers?$filter=CreatedDateTime%20gt%202017-01-01T01:01:01Z
No operators seem to work (eq, gt, ne).
I tried to search DevDocs for this, but didn't find any verfication if this is a (missing) feature or bug.
*This post is locked for comments
Ok. So you have created a extension of CustCustomerEntity and added CreatedDateTime field and named it as let's say ABCCreatedDateTime.
The major problem here is, Data entity extension does not allows regeneration/updation of staging table(as it will cause overlayering). So, to overcome this issue and make field available for Data import/export, its better to create an extension of staging table and add same field here.
However, it does not resolves your issue of filter on createddatetime field. Though, Other UTCDatetime/date fields can be used (via extension/standard) for filter without any issues.
However there are alternate ways for this task
1. Its not recommended, but you can use overlayering instead of extension for CustCustomerEntity then add ABCCreatedDateTime field here. And filter will work like anything.
2. Use a different approach and create a data entity which will be a exact replica of CustCustomerEntity in your working model. Then add ABCCreatedDateTime field from custtable datasource.
I am not sure whats going wrong with your entity, it should work after renaming as mentioned by sukrut. I've not checked it for Createddatetime field, but filter works perfectly for other utcdatetime fields
I've written a blog for Read operations, see if it helps you
dynamicsaxforall.blogspot.in/.../crud-with-odata-and-data-entities-in.html
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,188
Super User 2024 Season 2
#2
Martin Dráb
230,030
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (