This shows you the differences between two versions of the page.
| Both sides previous revision Previous revision Next revision | Previous revision | ||
|
admin:indexing:powersearch:custom [2012/01/30 22:46] doc |
admin:indexing:powersearch:custom [2016/06/28 22:38] (current) |
||
|---|---|---|---|
| Line 58: | Line 58: | ||
| * %CRITERIA% - This token is replaced with the criteria passed in the WHERE clause for this column. | * %CRITERIA% - This token is replaced with the criteria passed in the WHERE clause for this column. | ||
| - | Typically, the replacement string uses a $CONTAINS clause that applies synonyms, misspellings or other Omnidex features. The use of a $CONTAINS clause is not required, though. While not all SQL can be applied, administrators can try applied varied SQL clauses in this section, including complex, parenthesized, Boolean predicates, nested queries, etc. | + | Typically, the replacement string uses a [[dev:sql:functions:contains|$CONTAINS]] clause that applies synonyms, misspellings or other Omnidex features. The use of a $CONTAINS clause is not required, though. While every SQL construct cannot be supported, administrators can use a wide variety of SQL clauses in this section, including complex, parenthesized, Boolean predicates, nested queries, etc. |
| == $COMMENTS == | == $COMMENTS == | ||
| - | Comments that are useful to the administrator to document this usage.. | + | Comments that are useful to the administrator to document this usage. |