XO Consulting: NPR 'Select' operators

HOME

Specializing in the MEDITECH environment

Tips & Tricks: NPR 'Select' operators

SELECT Operator	Function	Internal Variable Name and Value
CL	Contains List	c.field.name[value] = 1
CO	Contains	c.field.name = value
EQ	Equal To	c.field.name = value
FS	First Value Greater Than or Equal To	c.field.name = value
GE	Greater Than or Equal To	b.field.name = value
GT	Greater Than	b.field.name = value
IG	Ignore	c.field.name = value
LE	Less Than or Equal To	e.field.name = value
LI	List	c.field.name[value] = 1
LS	Last Value Less Than or Equal To	c.field.name = value
LT	Less Than	e.field.name = value
NC	Not Contains	c.field.name = value
NE	Not Equal To	c.field.name = value
NL	Not In List	c.field.name[value] = 1
RL	Range List	c.field.name[from.value] = thru.value