At TMS Software, our goal is to equip developers with powerful, intuitive components that enhance productivity and streamline application development. We are excited to introduce TTMSFNCDataSetFilterDialog, a new addition to the FNC UI component suite, designed to make dataset filtering more accessible through an interactive and user-friendly dialog.

Why the TTMSFNCDataSetFilterDialog?

Filtering datasets in Delphi applications often requires manually constructing complex filter expressions. The TTMSFNCDataSetFilterDialog eliminates this challenge by providing a visual, SQL-based filter builder that allows users to create and apply filters effortlessly. Compatible with VCL and FireMonkey, this control ensures a consistent experience across platforms, making it a valuable addition to any Delphi application.

How it works

Getting started with TTMSFNCDataSetFilterDialog is simple:

1. Drop the component onto your form and assign a TDataSet to the DataSet property.
2. Retrieve the filter text dynamically—any modification to the FilterText property will update the dataset filter accordingly.
3. Launch the dialog with a single call to the Execute method, allowing users to configure their filters visually.

Within the dialog, users can:
✔ Select a data field from the available dataset fields.
✔ Choose an operator based on the field type (Text, Boolean, Numeric, DateTime).
✔ Assign a value to define the filter condition.
✔ Combine multiple filter conditions using AND/OR group logic, with the option to invert expressions using NOT.

Customization & Flexibility

The TTMSFNCDataSetFilterDialog is fully customizable to fit the look and feel of your application:

• UILanguage: Localize the dialog by modifying displayed text.
• Appearance: Adjust styling properties to match your application's design.
  
  

Conclusion

Ready to give it a try? The TTMSFNCDataSetFilterDialog is now available in the latest release of the TMS FNC UI Pack!