Hello,
I have a dashboard that worked all last year, but we recently upgraded to ArcGIS GIS Server 10.9 and now I encountered a BUG-00142623 so I now get a 'cannot access data' using a field that is text field with dates.
"The error message, "Invalid data type for expression <expression>." is returned when applying a query in a string field for values formatted as '1/1/2021 12:15:59' with hosted feature services in ArcGIS Server 10.9 relational or spatiotemporal ArcGIS Data Store. "
It is fixed in version 11.0, but our organization will not be upgrading to this for some time. Based on the support page below is the current work around.
"Workaround
Prefix the string with 'N'. For example, Where: test = N'1/1/2021 12:15:59'. "
How can I apply this in my dashboard for the category selector to work again with the dates as text field? I was trying to use a data expression, but so far have been unsuccessful.
This is very frustrating since it all was working fine.
Thanks in advance,
Kathy
