Form with multi-datasources with different ValidTimeStateFieldType

(0) Share

Report

Posted on by everand

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?

All responses (2)

Answers (0)

everand 65 on at

Like (0)

Report

RE: Form with multi-datasources with different ValidTimeStateFieldType

display method? users need sort and filter by department... so it's rather not the solution
Gunjan Bhattachayya 35,421 on at

Like (0)

Report

RE: Form with multi-datasources with different ValidTimeStateFieldType

Hi everand,

Will it be possible to add a data method to show the department name?