Set Filter without allowing changes

[Shawn Smalley]

Is there a way to set up a filter for a grid, but not let people change that filter?
I have a grid displaying all orders for the current month using the filter 'Between' with initial value of current date first of month to current date last of month and I need to make sure people can't view orders outside of the current month

[Johnny Major]

We do not have a way to make the filters read-only. However, instead of having the filter directly on the widget, you could simply apply that filter to your data source

Example:

SELECT
  myColOne,
  myColTwo,
  myDateCol
FROM
  myTable
WHERE
  month(myDateCol) = month(current_date) and year(myDateCol) = year(current_date)

Another option would be to have a filter program, 'EXNABFLT,' check the dates before applying the filter

[Shawn Smalley]

Perfect, that will work.
Thank you!