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.

All responses (2)

Answers (1)

Srimdax 338 on at

Like (0)

Report

to filter query range on View method

Thanks Martin for your kind help it worked out.
Verified answer

Martin Dráb 231,923 Most Valuable Professional on at

Like (1)

Report
to filter query range on View method

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.