Home

Getting Started

Utilities

Indexing

Omnidex

Development

Tutorials

Quick Links

 

Appendix

Qualification Syntax

Comparison

 

Omnidex Sentinel Character

 

Appendix

 

 

Omnidex supports two approaches for qualification criteria, each with a different syntax. They are, ODXFIND and PARSER, with PARSER being the default approach. You can specify which approach to use by issuing a SET QUALIFY_MODE approach command:

SET QUALIFY_MODE ODXFIND | PARSER

  • The ODXFIND approach has been used for many years and supports a wide variety of punctuation operators for performing Boolean operations. It also provides some expanded capabilities for pattern patching.
  • The PARSER approach uses a formal parser to interpret the criteria and includes many of the new functions and operators found in Omnidex Text. The PARSER approach does not support all of the old punctuation operators supported in the ODXFIND approach and supports limited pattern matching.

 

Comparison

The following chart compares the ODXFIND and PARSER approach syntax:

Feature

ODXFIND

PARSER

AND

and
, (comma)
<space>

column='value1 and value2'

column='value1, value2'

column='value1 value2'

and
<space>

column='value1 and value2'

column='value1 value2'

OR

or
+ (plus sign)

column='value1 or value2'

column='value1 + value2'

or

column='value1 or value2'

NOT

not

column='not value'

not

column='not value'

 

NOT EQUAL

not

not column = 'value'

not

<>

!=

not column = 'value'

column <> 'value'

column != 'value'

LESS THAN

<

column < 'value'

<

column < 'value'

LESS THAN or EQUAL TO

<=
to a
thru a

column <= 'value'

column = 'to value'

column = 'thru value'

<=

column <= 'value'

GREATER THAN

>

column > 'value'

>

column > 'value'

GREATER THAN or EQUAL TO

>=
a to
a thru

column >= 'value'

column = 'value to'

column = 'value thru'

>=

column >= 'value'

RANGE

>a<b
>a<=b
>=a<b
>=a<=b

column = '> value1 < value2'

column = '> value1 <= value2'

column = '>= value1 < value2'

column = '>= value1 <= value2'

>a<b
>a<=b
>=a<b
>=a<=b

column = '> value1 < value2'

column = '> value1 <= value2'

column = '>= value1 < value2'

column = '>= value1 <= value2'

BETWEEN

a:b
a to b
a thru b

column = 'value1:value2'

column = 'value1 to value2'

column = 'value1 thru value2'

between a and b

column between value1 and value2

IN

not supported

in (a,b,...)

column in (a,b,c,...)

ALL KEYWORDS

: (colon)

column = ':'

all_keywds

column = 'all_keywds'

ALL ROWS

* (asterisk)

column = '*'

* (asterisk)
all_rows

column = '*'

column = 'all_rows'

COMPOSITE

"a|b|c"

 

[a|b|c]

MEMORY MULTIFIND

& (ampersand)

 

& (ampersand)
odxsi()

 

FILE MULTIFIND

&filename
&&filename
&{1}filename
&&{1}filename

 

&filename
&&filename
&{1}filename
&&{1}filename
file(filename, fieldnum)
file(filename,,"options")
file(filename, fieldnum,"options")

 

ID FILE

$filename

 

$filename
odxid(filename)

 

QUEUE

not supported

queue(queuename)
queue(queuename,fieldnum)
queue(queuename,,"options")
queue(queuename, fieldnum, "options")

 

PROXIMITY PHRASE

a,/1/b

column='value1,/1/value2'

"a b"

column="value1 value2"

PROXIMITY BEFORE

a,/n/b

column='value1,/10/value2'

a before b
a before(n) b

column='value1 before value2'

column='value1 before(5) value2'

PROXIMITY NEAR

a,|n|b

column='value1,|15|value2'

a b
a near b
a near(n) b

column='value1 value2'

column='value1 near value2'

column='value1 near(15) value2'

FORMS

not supported

forms(a)

column='forms(value)'

MISSPELLINGS

not supported

misspellings(a)
misspell(a)

column='misspellings(value)'

column='misspell(value)'

PHONETIC

a!

column='value!'

phonetic(a)
phon(a)

column='phonetic(value)'

column='phon(value)'

SPELLCHECK

not supported

spellcheck(a)
spell(a)

column='spellcheck(value)'

column='spell(value)'

STOPWORDS

not supported

stopwords(a)
stop(a)

column='stopwords(value)'

column='stop(value)'

SYNONYMS

a=

column='a='

synonyms(a)
syn(a)

column='synonyms(value)'

columns='syn(value)'

COMMENTS

not supported

/* comment */

 

 

 

Top