to filter query range on View method

(0) Share

Report

Posted on by Srimdax

338

Hi Team,

I created a query which has validto field and I created a View based on query. Now I need to filter validto field as getting records which has maxdate value in view.

Can anyone suggest which method and example to be used in view? Tried to write in init() method of view which is not even hitting. Anyone can please share me any example how to filter query range on view method.

I don't want to do queryranges on AOT as datetimeutill::datemax(),datetimeutill::maxvalue() or any other functions will not work.

Please do the needfull.

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

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

Like (1)

Report
init() method indeed won't help you. Instead, you just need to use the right value in the query range. It can be done in AOT, you just need to know how.

You can use this as the value (don't remove the outer parentheses):

(validToMaxValueRange())

If you're interested in how it's implemented, look into SysQueryRangeUtil_Extension class.

Was this reply helpful? Yes No
Srimdax 338 on at

Like (0)

Report

Thanks Martin for your kind help it worked out.

Was this reply helpful? Yes No