文字列検索機能でAND・ORを使えるようにしてほしい

[tamaina]

Summary

半ば必須かもしれない

[tamaina]

age

[Johann150]

I'm not sure how it could be differentiated between when I am searching for text that contains "AND"/"OR". Maybe an advanced search mode would be necessary.

[futchitwo]

ioには色々実装されてる(ただしLIKE検索が封じされてる) https://github.com/MisskeyIO/misskey/blob/io/packages/backend/src/server/api/endpoints/notes/search.ts

公式インスタンスであるioでは使えるのに他では使えないのはどうかと思うので、ioと同等の検索クエリはあったほうがいいと思う

[Johann150]

The search syntax looks similar to GitHub search, interesting idea. 👍

I don't understand what the &@~ operator is supposed to do. I could not find it anywhere else in the code, or in Postgres or TypeORM documentation...

[rinsuki]

it comes from PGroonga? https://pgroonga.github.io/reference/operators/query-v2.html

[Johann150]

I'm not sure PGroonga is something we could add as a dependency. But I wonder if some pieces of the search syntax could be transformed into a Postgresql style regular expression.

[tamaina]

FYI: How to install PGroonga and &@~ patch: https://hide.ac/articles/DjGNSvW4G

[tamaina]

Adding PGroonga as a dependency complicates the installation process.

[tamaina]

PGroongaと言ってたけどGroonga単体で使ってもいいじゃんという発想をした

[tamaina]

（とはいえRust製のMeilisearchのほうが現代的なのは明らか

[tamaina]

ORできるよね…？

[tamaina]

ORできない？

[syuilo]

できないかも