Author Topic: Advanced Text Search Functions  (Read 2836 times)

Offline esambo

  • Member
  • **
  • Posts: 52
    • View Profile
Advanced Text Search Functions
« on: May 14, 2019, 08:03:51 PM »
How can I use more advanced text search functions?
The Search Settings example just show exact text match examples!
I would like something more advanced, like:
- predefined like in Apple Photos.app
  - includes
  - does not include
  - is
  - is not
  - is not empty
  - starts with
  - ends with
- scripting like in Spreadsheets (Google Sheets, MS Excel, etc.)
  - LEFT
  - MID
  - REGEXMATCH
  - SEARCH
- wildcard like PostgreSQL
  - iLIKE "%.jpg"
- regular expression
  - /.+\.jpg$/i
« Last Edit: July 14, 2019, 05:25:20 PM by esambo »

Offline esambo

  • Member
  • **
  • Posts: 52
    • View Profile
Re: Advanced Text Search Functions
« Reply #1 on: September 20, 2022, 08:19:43 PM »
I just had the same problem again, where I was trying to find images that don't include a keyword (eg. "doc"), and struggled with the valid syntax, eg:
CaptureTime 2022-8 and not (Keywords doc medical)