I have some parameterization table (TableX) which have personnel number and its custom properties. This table is a data source for a simple form.
Now, I have to add to that form a column with department (from OMOperatingUnit.Name). I have added few new data sources to get information about department (HcmWorker -> HcmPositionWorkerAssignment -> HcmPosition -> HcmPositionDetail -> OMOperatingUnit; LinkType - OuterJoin).
The problem is:
The TableX has ValidTimeStateFieldType set as Date. The form's datasource (TableX_ds) has ValidTimeStateAutoQuery set to DateRange. I'm getting error while opening form with incomatible data type in ValidTimeStateFieldType between those two tables (TableX and HcmPositionWorkerAssigment). The form woks only if ValidTimeStateAutoQuery on TableX_ds is set to AsOfDate, what is undesirable.
Is there a way to achieve it without changing ValidTimeStateAutoQuery to AsOfDate or ValidTimeStateFieldType on TableX to utcDateTime?
