🔎 Build Dynamic SQL Filters for Joget Reports with BeanShell

A Joget BeanShell example shows how to rebuild a report summary table from optional requester and status filters.

The script uses parameterized SQL with PreparedStatement to reduce injection risk while counting records by status.

It first clears old summary rows, then inserts aggregated results into a reporting table for dashboards or datalists.

The pattern is useful for turning form-selected filters into simple report-ready data for charts and workflow views.