DateEffective Table in Query


I’ve created a listpage where I’m using a query as the datasource. In that datasource I have added HCMWorker and HCMWorkerTitle to get an employees OfficeLocation. Once I add the HCMWorkerTitle, I get multiple records per employee. I’m not familiar with the DateEffective thing and how to set it up for this table. Can someone please give me instructions?

Probably the best resource to learn about the thing is Date Effective Patterns (White paper). Notice that there is no property on AOT queries for controlling this behavior, therefore you need another approach (code, view).