Report Builder (Drill-Down, Formula, Field Values, Users)

📄️Drill Down Into Aggregated Row

Execute a drill-down query for a row in an aggregated report. Pass the same `definition` used to produce the parent row along with a `drill_values` map of {dimension_alias: value} pairs to isolate the underlying detail records.

📄️Validate Formula Expression

Validate a user-entered formula expression before saving. The formula is parsed via Symfony ExpressionLanguage against a whitelist of functions (IF, COALESCE, ROUND, NULLIF, etc.) and field references (`{field_name}`).

📄️Get Distinct Field Values (Autocomplete)

Return distinct values for a given entity/field. Used to populate autocomplete dropdowns in the filter builder UI (e.g., distinct `order_status` values).

📄️Search Users (for Sharing)

Search for users that can be added as share recipients on a custom report. Limited to users in the same tenant. Returns up to 20 matches. Used to power the share dialog's user picker.