baraja-core/doctrine-fulltext-search

Implement WHERE clause

sitole opened this issue · 1 comments

sitole commented

For example, I want to load articles, but many of them are private, and I have to load them all and select them at the application level, which is both memory and performance intensive.

It would be good to implement a database where clause.
cc @janbarasek

janbarasek commented

@sitole Thanks for suggestion.

I implemented simple logic for user wheres which will be used as AND filters.

You can use array of wheres (strings) or use SelectorBuilder class.

Commit: 7892fba

By the way lot of filters can be used by user natively in query which I added by this commit: 6abb035

Now user can use this filters:

  • Exact match in quotes: "to be or not to be"
  • Negative match: linux -ubuntu
  • Number interval 2017..2020.

Thanks.