v5.1.0 - Filter Predicates

5.1.0 (2024-06-07)

New Release Info

This new release brings a ton of new features and most of the new feature ideas came from this great Stack Overflow question Angular Slickgrid - Custom Filter which the user asked if it was possible to create a custom filter as SQL LIKE. So, from this idea in mind and considering that we already had a sortComparer for custom Sorting but no ways to customize Filtering, now let's work around this idea shall we?

• filterPredicate for local JSON dataset (see Example 14 for SQL LIKE demo)
• new filterQueryOverride which is the filter override for Backend Services (OData / GraphQL)
• new OperatorType.custom that can be used with above custom filter predicate/override
• new Operator a*z (StartsWith & EndsWith combo) available for local JSON dataset and Backend Services
• new Top-Header panel which now allows the user to use both Draggable Grouping and Header Grouping together, this just wasn't possible before (see Example 3)

This new release also brings a lot of improvements to the Excel Export with a new Example 23 which demos how to dynamically use Excel Formulas (e.g. Sums), you can even use Excel Formulas with Grouping to do Sums, isn't it awesome!? Let's just say that pretty much everything you can do in excel-builder-vanilla, you can probably do in Slickgrid-Universal.

A huge thanks to @zewa666 and @jr01 for their contributions & feedback to add some of these new features and fixes. 🚀

---

Features

• core: add new preventDragFromKeys grid option, fixes #1537 (#1538) (803fbee) - by @ghiscoding
• core: add optional Top-Header for Drag Grouping & Header Grouping (#1556) (7d4a769) - by @ghiscoding
• export: add missing valueParserCallback dataContext & new demo (#1543) (884b6e0) - by @ghiscoding
• filters: add OperatorType.custom for custom backend service (#1526) (4284d58) - by @ghiscoding
• filters: add a filterPredicate option for user customization (#1528) (cbf64d8) - by @ghiscoding
• filters: add StartsWith/EndsWith (a*z) filter combo (#1530) (51560aa) - by @ghiscoding
• filters: add StartsWith/EndsWith (a*z) to OData/GraphQL (#1532) (237d6a8) - by @ghiscoding
• GraphQL: add filterQueryOverride to GraphQL Service (#1549) (2c0a493) - by @ghiscoding
• OData: add filterQueryOverride to OData Service (#1536) (e8ffffe) - by @zewa666

Bug Fixes

• filter: Date Filter should trigger Grid State change with Backspace (#1545) (0c10410) - by @ghiscoding
• filters: Compound Operator alt texts should work with custom list (#1541) (02d5d2b) - by @ghiscoding
• filters: new filterPredicate shouldn't break other column filters (#1531) (27777ef) - by @ghiscoding
• Grouping: Draggable Grouping cols reorder missing impactedColumns (#1557) (69125c2) - by @ghiscoding
• pagination: out of boundaries page Grid Preset should be unset (#1534) (b800da3) - by @ghiscoding
• TreeData: addItem should keep current sorted column (#1558) (dc2a002) - by @ghiscoding