APEX

Hi guys,

I have an IG that shows the time entries of the week.

So, I created a dynamic action that filter START_DATE from Monday to Friday of the current week.

apex.region("time_entries").widget().interactiveGrid("addFilter", {
  type: 'column',
  columnType: 'column',
  columnName: 'START_DATE',
  operator: 'BETWEEN',
  value: $v('P400_P_DATE_01')+'~'+$v('P400_P_DATE_02'),
  isCaseSensitive: false
});

but every time that I visit my page the filtered is added again.

I tried to reset the IG before adding the filter

apex.region("time_entries").widget().interactiveGrid("getActions").invoke("reset-report");

but after the first page visit I am getting "Error: Ajax call returned server error ORA-01403: no data found for ."

I was thinking if I can just remove the filter and add again.

Do you known how to remove the filter ??

Thank you, Eric