fritz08/05/2020, 3:04 PM
Ryan08/05/2020, 4:56 PM
Seán O'Halloran08/07/2020, 3:33 PM
because the wildcard resolves at the moment the query runs, every time the query runs. The problem mentioned in the blog is that for FIM, the wildcard resolves only when the FIM config is first loaded. So new paths created afterwards aren’t included.
SELECT * FROM file WHERE path LIKE '/Users/%/Downloads/%%'
Ryan08/07/2020, 3:36 PM