# Checkbox filter, selected box and non selected boxes

**URL:** <https://forum.inductiveautomation.com/t/checkbox-filter-selected-box-and-non-selected-boxes/91754>\
**Category:** Ignition\
**Tags:** perspective\
**Created:** [June 12, 2024, 3:56pm UTC](https://forum.inductiveautomation.com/t/checkbox-filter-selected-box-and-non-selected-boxes/91754 "2024-06-12T15:56:49Z")\
**Posts on this page:** 1\
**Showing post:** 9

<div class="post-metadata">

**Author:** ![Transistor](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/transistor/32/3380_2.png) [@Transistor](https://forum.inductiveautomation.com/u/Transistor)\
**Post date:** [June 13, 2024, 11:33am UTC](https://forum.inductiveautomation.com/t/checkbox-filter-selected-box-and-non-selected-boxes/91754/9 "2024-06-13T11:33:13Z")

</div>

Options:

1. Give preset groups of likely combinations: `00` or `MAD` or `FINCI`, etc.? Your selection looks well organised so an easy way to do this would be have three dropdowns,

- Dropdown 1: `All, 00, 01, 02, etc.`
- Dropdown 2: `All, MAD, MAE, MAF, etc.`
- Dropdown 3: `All, FINCI, FINCU, FINDO, FINNU, etc.`

1. Use the table component's column filter. (This isn't very powerful and doesn't allow wildcards.)
2. Allow the user to create a pattern that could be used in an SQL "WHERE LIKE" clause. e.g.,  
`00-*-FINCI`  
`*-MAD-*`  
MySQL, for example, allows use of regular expressions with `REGEX_LIKE()` function, etc. [Tutorial](https://dev.mysql.com/doc/mysql-tutorial-excerpt/8.0/en/pattern-matching.html).  
You would need to be very careful to sanatise this so that SQL injection is not possible.

---

_[View the full topic](https://forum.inductiveautomation.com/t/checkbox-filter-selected-box-and-non-selected-boxes/91754)._