how to give a query range the value DateTimeUtil::minValue()

(0) Share

Report

Posted on by maram fraij

I need to view salary related data in a form for all employee( both terminated & employed ). I create a query which has four data sources (HcmWorker, DirPerson, HcmEmployemnt and SalaryDetails /customizaed table ). I added ranges to HcmEmployemnt data source using the field Valid To . I need to give Valid To value such as DateTimeUtil::minValue() and use the relation greater than to get all employees (terminated & employed), how can I do this ?

*This post is locked for comments

I have the same question (0)

All responses (4)

Answers (0)

Suggested answer

Bashir Ahmad 5,248 on at

Like (0)

Report

Look in to this thread:

community.dynamics.com/.../92473.aspx

also can verify the syntax of the query:

https://community.dynamics.com/ax/f/33/t/119489.aspx

Was this reply helpful? Yes No
Suggested answer

Martin Dráb 237,878 Most Valuable Professional on at

Like (0)

Report

HcmEmployment table contains date-effective data. Instead of using usual ranges, set values to Query.validTimeStateDateRange() or Query.validTimeStateDateTimeRange().

Was this reply helpful? Yes No
maram fraij on at

Like (0)

Report

The query is AOT query similar to that used with HcmWorkerListPage_PastWorkers

How can I use validTimeStateDateTimeRange ?

Was this reply helpful? Yes No
Martin Dráb 237,878 Most Valuable Professional on at

Like (1)

Report

You'll call the method and pass some parameters into it, e.g. query.validTimeStateDateTimeRange(DateTimeUtil::minValue(), DateTimeUtil::maxValue()).

I thought you would know how to use these methods, because you mentioned DateTimeUtil::minValue() in your question.

Was this reply helpful? Yes No