Hi, I have a column in a NexusDB table that is defined as a Date. A have set it as a TDate in the applicable entity entries but when I do a $filter on it in Swagger it fails as the query is still using timestamp instead of date. If I change the underlyying column type in the Nexus table to be a Dat…

Currently TMS XData doesn't understand a date literal. The only literals supported in $filter string is the complete one with date and time part. Thus, when such value is "forwarded" to the underlying SQL-generation mechanism (Aurelius) it's set as a date/time value.

XData NexusDB Date v DateTime Conflict

BIZ TMS XData

wlandgraf (Wagner Landgraf) May 4, 2023, 11:44am 6

Ok, thanks for adding the feature request.
We will try to implement this asap.

Topic		Replies	Views
Posting UTC datetime Value TMS XData	3	378	April 20, 2023
Date Manipulation in Filter TMS XData	3	165	June 13, 2023
Using XData/Modeller Joins in TMS Web App TMS XData	7	325	July 22, 2021
XData/NexusDB TGuid Filter TMS XData	3	185	April 5, 2023
TDateTime Field throws TJsonTypeConverter.EConvertFromJsonError when providing ISODateString TMS XData	3	474	August 15, 2022

XData NexusDB Date v DateTime Conflict

Related topics