Hi Navin,
these characters are not searchable by the full-text-index.
@$# and other special-characters are treated as word-breakers[1] and can’t be
searched for.
If you ran for example the following query:
> ft:tokenize("f...@bar.de#test$baz“)
You will see which tokens will be added to the full-text-index.
The full-text-index is usually used to search in natural language texts, so
punctuation und special characters are generally ignored.
Maybe a naïve approach already helps:
> db:open(‚database')//text()[contains(., "@")]/..
Best from Konstanz,
Michael
[1] https://www.w3.org/TR/xpath-full-text-10/
<https://www.w3.org/TR/xpath-full-text-10/>
--
Michael Seiferle, BaseX GmbH, http://www.basexgmbh.de
|-- Firmensitz: Obere Laube 73, 78462 Konstanz
|-- Registergericht Freiburg, HRB: 708285, Geschäftsführer:
| Dr. Christian Grün, Dr. Alexander Holupirek, Michael Seiferle
`-- Tel: +49 7531 916 82 77
> Am 24.01.2018 um 10:42 schrieb Navin Rawat <nrawat2...@gmail.com>:
>
> Hi Team,
>
> Could I search @, $, # by full text API of bases?
>
> I am using following query but unable to get any success:
>
> let $query := '@'
> let $options := map {
> "mode": "any",
> "fuzzy": "off",
> "wildcards": true(),
> "ordered": "false"
> }
> return ft:search("database", $query, $options)
>
> Please suggest.
>
> Regards,
> Navin
