cancel
Showing results for 
Search instead for 
Did you mean: 

How to fetch data from MDF for Document Generation where there are overlapping dates?

yvonneliew
Newcomer
0 Kudos
90

We have a requirement to store contract details and generate a letter contract. Some people can hold multiple contracts at the same time. 
Example below contracts for the same employee:

Contract 1
Start Date: 1-Jan-2025
End Date: 31-Mar-2025
Role: Teacher - Science
Rate per day: $50

Contract 2
Start Date: 1-Feb-2025
End Date: 30-Jun-2025
Role: Teacher - Math
Rate per day: $65

If we were to use Document Generation, how are we able to selectively only generate the 2nd contract since the dates are overlapping and Document Generation allows selection by As Of Date, which will select both records, instead of Contract 2?

yvonneliew_0-1737109938358.png

 

View Entire Topic
AlsuRzayeva
Explorer

Additionally you can look this note - 2387814 - Document Generation - How to map Pay Component data to a Document Template

This is other example for using table properties