You are not logged in. Please login or register.
iRedMail → Spider Email Archiver → 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.
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.
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.
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/
I'll have a look at blevesearch.
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.
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.
I was thinking of installing SQLiteBrowser and pointing it at the directory as a start.
Thanks for all of the above info.
I think the search input is being modified/sanitized before being passed off to the search engine. Would it be possible to offer a raw query option for the auditor users only? I started another thread about the phrase search not working as expected.
I think the search input is being modified/sanitized before being passed off to the search engine.
Yes.
Would it be possible to offer a raw query option for the auditor users only?
Technically it's possible but we need to do validations to make sure it's safe.
Plan to implement advance search in future release.
iRedMail → Spider Email Archiver → Search
Powered by PunBB, supported by Informer Technologies, Inc.
Currently installed 2 official extensions. Copyright © 2003–2010 PunBB.
Generated in 0.017 seconds (58% PHP - 42% DB) with 10 queries