How to add Advanced Filtering to a Grid View
Below are some examples of advanced filters that are available in the classic data grids.
'_' (Underscore) - Wildcard match of a single character
'__-CORP-0099' matches a string that contains any 2 characters followed by '-CORP-0099'
'[0-9]' - Single character match where the character must be in the range '0' to '9'
'LT-CORP-%[0-9][0-9][0-9][0-9]' matches a string that begins 'LT-CORP-' and ends with 4 digits
'[A-D]' - Single character match where the character must be in the range 'A' to 'D'
'[A-D][P-S]-CORP-0099' matches a string that begins 'A', 'B', 'C' or 'D' followed
by 'P', 'R' or 'S' and ending '-CORP-0099'
'[PDT]' - Single character match where the character must be one of 'P', 'D' or 'T'
'%[0-9][0-9][wl][pdt]' matches anything that ends with 2 digits then 'w' or 'l' followed by
'p', 'd' or 't' i.e. Naming convention for Production, Development and Tests systems, where the 'w' or 'l' represents Windows or Linux and 'p', 'd' and 't' represents Production, Development and Test
'!2[10]H[12]' - Exclude where the string contains '2' followed by '0' or '1', followed by 'H' followed by '1' or '2' i.e. On the Operating System version for Windows 10 systems, this will exclude strings that contain '20H2' and '21H1' builds.
]