1 Topic by SteveInAkron

  • SteveInAkron
  • Member
  • Offline
  • Registered: 2016-01-07
  • Posts: 51

Topic: Search

Is it possible to search with "and", "or", "like" commands permitted in SQL when doing a match?

Is the database format documented anywhere?  I would like to try some more refined searching if the above is not an option.

----

Spider Email Archiver: On-Premises, lightweight email archiving software developed by iRedMail team. Supports Amazon S3 compatible storage and custom branding.

2 Reply by ZhangHuangbin

  • ZhangHuangbin
  • ZhangHuangbin
  • iRedMail Developers
  • Offline
  • Registered: 2009-05-06
  • Posts: 31,060

Re: Search

SteveInAkron wrote:

Is it possible to search with "and", "or", "like" commands permitted in SQL when doing a match?

Yes it's possible.
Spider uses blevesearch as the embedded FTS engine, it offers such queries: http://blevesearch.com/docs/Query/

The problem is how to show and configure such queries on web UI. Do you happen to see any software offers such web UI? i'd like to have a reference.

SteveInAkron wrote:

Is the database format documented anywhere?  I would like to try some more refined searching if the above is not an option.

Yes it's documented here: http://blevesearch.com/docs/Query/
But Spider doesn't offer a command line tool to query manually.

3 Reply by SteveInAkron (edited by SteveInAkron 2024-10-31 22:47:14)

  • SteveInAkron
  • Member
  • Offline
  • Registered: 2016-01-07
  • Posts: 51

Re: Search

SteveInAkron wrote:

Is it possible to search with "and", "or", "like" commands permitted in SQL when doing a match?

ZhangHuangbin wrote:

Yes it's possible.
Spider uses blevesearch as the embedded FTS engine, it offers such queries: http://blevesearch.com/docs/Query/

I'll have a look at blevesearch.

ZhangHuangbin wrote:

The problem is how to show and configure such queries on web UI. Do you happen to see any software offers such web UI? i'd like to have a reference.

I have only seen query builders as a part of some database packages I've worked with.  I'll let you know if I find any good references supporting web UI.

SteveInAkron wrote:

Is the database format documented anywhere?  I would like to try some more refined searching if the above is not an option.

ZhangHuangbin wrote:

Yes it's documented here: http://blevesearch.com/docs/Query/
But Spider doesn't offer a command line tool to query manually.

I was thinking of installing SQLiteBrowser and pointing it at the directory as a start.

Thanks for all of the above info.