Examples: query, "exact match", wildcard*, wild?ard, wild*rd
Fuzzy search: cake~ (finds cakes, bake)
Term boost: "red velvet"^4, chocolate^2
Field grouping: tags:(+work -"fun-stuff")
Escape special characters +-&|!(){}[]^"~*?:\ - e.g. \+ \* \!
Range search: properties.timestamp:[1587729413488 TO *] (inclusive), properties.title:{A TO Z}(excluding A and Z)
Combinations: chocolate AND vanilla, chocolate OR vanilla, (chocolate OR vanilla) NOT "vanilla pudding"
Field search: properties.title:"The Title" AND text
 
Profile picture
Coby Hausrath
Moderator
0 Questions, 1 Answer
Active since 04 May 2021
  Last activity 2 years ago

Reputation

5 + 5 this October
0 Testing Entrypoint extension in PTE

One option to avoid the issue of on-demand generation inadvertently overloading the DB could be to continue using the periodic extension - but install it to run in PTE on a much more frequent basis there (perhaps once/hour) - and it could first check a "only_run_within_1_hour_of" timestamp set in DbConfig before proceeding with the report generation. If set - and at each periodic run it is within 1 hour of the current time - proceed and generate the report. If not set at all (or it's not wi...

one year ago