This shows you the differences between two versions of the page.
Both sides previous revision Previous revision Next revision | Previous revision | ||
dev:sql:functions:context:home [2009/12/07 15:08] tdo |
dev:sql:functions:context:home [2016/06/28 22:38] (current) |
||
---|---|---|---|
Line 1: | Line 1: | ||
{{page>:top_add&nofooter&noeditbtn}} | {{page>:top_add&nofooter&noeditbtn}} | ||
<html><div align="center"><span style="color:red">DRAFT</span></div></html> | <html><div align="center"><span style="color:red">DRAFT</span></div></html> | ||
- | ===== $CONTEXT ===== | + | ===== Omnidex SQL Function: $CONTEXT ===== |
+ | ===== Description ===== | ||
The $CONTEXT function is used to retrieve small excerpts from a document containing the search criteria. The $CONTEXT function returns the words adjacent to the criteria, formatting them if requested so that they keywords are easily visible. The $CONTEXT function can return multiple of these contexts in one string, allowing the user to see the various locations which led to an entry being qualified. | The $CONTEXT function is used to retrieve small excerpts from a document containing the search criteria. The $CONTEXT function returns the words adjacent to the criteria, formatting them if requested so that they keywords are easily visible. The $CONTEXT function can return multiple of these contexts in one string, allowing the user to see the various locations which led to an entry being qualified. | ||
Line 60: | Line 61: | ||
== label == | == label == | ||
An optional label that describes this particular search. This label is not needed unless multiple $CONTAINS functions are used in the SQL statement. This label refers to the label used in the $CONTAINS function. The label is case-insensitive, and may be up to 32 characters long. | An optional label that describes this particular search. This label is not needed unless multiple $CONTAINS functions are used in the SQL statement. This label refers to the label used in the $CONTAINS function. The label is case-insensitive, and may be up to 32 characters long. | ||
+ | ==== Options ==== | ||
+ | END_HIGHLIGHT | ||
+ | ===== Example ===== | ||
+ | <code> | ||
+ | SELECT title, $score, $context FROM books | ||
+ | WHERE $contains(content, 'white rabbit', 'synonyms') | ||
+ | ORDER BY $score | ||
+ | |||
+ | Alice's Adventures in Wonderland | ||
+ | 79.050003 | ||
+ | --- daisies, when suddenly a White Rabbit with pink eyes ran --- It was the | ||
+ | >> White Rabbit returning, splendidly dressed, with --- Bill It was the | ||
+ | >> White Rabbit, trotting slowly back again, --- | ||
+ | |||
+ | The Adventures of Huckleberry Finn | ||
+ | 29.570000 | ||
+ | --- de on'y white genlman dat ever...the spunk of a rabbit. --- Is your man | ||
+ | >> white or black?" I...the spunk of a rabbit. --- the spunk of a rabbit. | ||
+ | >> I see I...up and says: "He's white." --- | ||
+ | |||
+ | Webster's Revised Unabridged Dictionary (1913) | ||
+ | 18.160000 | ||
+ | --- a yellow disk and white or pinkish...ashkoko, dassy, and rock rabbit. | ||
+ | >> --- ashkoko, dassy, and rock rabbit. See Cony, and...brocade. Dambonite | ||
+ | >> (n.) A white, crystalline, sugary substance obtained --- | ||
+ | |||
+ | The Taming of the Shrew | ||
+ | 2.860000 | ||
+ | --- parsley to stuff a rabbit; and so may...gentlewoman? Such war of white | ||
+ | >> and red within her --- | ||
+ | |||
+ | Webster's Revised Unabridged Dictionary (1913) | ||
+ | 18.160000 | ||
+ | --- a yellow disk and white or pinkish...ashkoko, dassy, and rock rabbit. | ||
+ | >> --- ashkoko, dassy, and rock rabbit. See Cony, and...brocade. Dambonite | ||
+ | >> (n.) A white, crystalline, sugary substance obtained --- | ||
+ | |||
+ | The Taming of the Shrew | ||
+ | 2.860000 | ||
+ | --- parsley to stuff a rabbit; and so may...gentlewoman? Such war of white | ||
+ | >> and red within her --- | ||
+ | |||
+ | The Adventures of Tom Sawyer | ||
+ | 2.860000 | ||
+ | --- a hunted and helpless rabbit look as she...her face--it was white with | ||
+ | >> terror] --"did you --- | ||
+ | </code> | ||