Checkbox filter, selected box and non selected boxes

Ignition
9

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.
    You would need to be very careful to sanatise this so that SQL injection is not possible.
1 Like