Is there any trigger for when users apply a filter?

steinarsig

I have a list page (Dynamics NAV 2013 R2) which includes a Repeater Group. To the side I have a FactBox which calculates a handful of statistics based on the records in the list (Total Amount, Number of Records etc.). I have a function (Action in the Ribbon) which updates the summary based on the filters that a user has applied.

I would however want to be able to perform this update automatically whenever the user applies a filter.

Is there any way to catch this event?

Marije_Brummel

There is no trigger.

What you can do is keep the current value of GETFILTERS in a global variable and as soon as that changes in the OnAfterGetCurrRecord trigger you need to update.

rmv_RU

steinarsig wrote:

I have a list page (Dynamics NAV 2013 R2) which includes a Repeater Group. To the side I have a FactBox which calculates a handful of statistics based on the records in the list (Total Amount, Number of Records etc.). I have a function (Action in the Ribbon) which updates the summary based on the filters that a user has applied.

I would however want to be able to perform this update automatically whenever the user applies a filter.

Is there any way to catch this event?

Try to use Form - OnActivateForm() trigger.

jreynolds

OnFindRecord on a page fires whenever the filters change.

rmv_RU

jreynolds wrote:

OnFindRecord on a page fires whenever the filters change.

Yes. But it's probably too expensive.

steinarsig

Mark Brummel wrote:

There is no trigger.

What you can do is keep the current value of GETFILTERS in a global variable and as soon as that changes in the OnAfterGetCurrRecord trigger you need to update.

Thank you.
That works perfectly. Here's my code:

OnInit()
LastRecFilter := Rec.GETFILTERS;
--------------------------------------------

OnAfterGetCurrRecord()
IF FilterChanged THEN
  DoSomething;

--------------------------------------------
FilterChanged() : Boolean
IF LastRecFilter <> Rec.GETFILTERS THEN BEGIN
  LastRecFilter := Rec.GETFILTERS;
  EXIT(TRUE);
END ELSE
  EXIT(FALSE);

rsaritzky

I have the same scenario in NAV2009. Is there a way to get a factbox to update after setting a filter? My factbox is simple - it's just a count of the records in the list being displayed.