Why do you only receive the current records?

You are creating a query for a historical compensation story report in Query Designer. You have added the Job Information table to the query, configured a scope filter, and previewed the result to verify you are returning the appropriate employees.

You add the related table Compensation to the query.

When you preview the query, you only get the current compensation information for the employees.

Why do you only receive the current records? Note: There are 2 correct answers to this question.
A . The Job information table time filter is set to: As of Date > Dynamic Date: Today.
B . The compensation table time filter is set to: Same Filter as First Table.
C . The Query Advanced Filter is set to: Job Information effective start date equal to Dynamic Date: Today.
D . The compensation table time filter is set to: As of Date > Dynamic Date: Today.

Answer: A,B

Subscribe
Notify of
guest
0 Comments
Inline Feedbacks
View all comments