I am trying to setup an updatable date field in my UBAQ. When I go to Advanced Column Editor Configuration, the Data Type for the date field is empty, I cannot select the data editor or any other. I have setup updatable dates field before and never had this issue. This happens for all dates in my query. Any ideas?
I found the issue, my BAQ has multiple CTEs and Inner Sub Queries. When setting up the update, if I was not on the Top Level Query, the Data Type would be blank. After selecting Top Level Query the Editor Data Type would appear.