Developer Documentation Library > Interviewer - Server Admin > UNICOM Intelligence Interviewer - Server Admin reference > Expression Translator component
 
Expression Translator component
The ExpressionTranslator component translates UNICOM Intelligence Data Model expressions to SQL expressions. This component is used in the Phone Reports activity to increase report generation speed by translating select filters, allowing them to be evaluated by the SQL Server.
Supported expression types
Type
- (negative)
Logical (and, or)
=
< >
>
<
>=
<=
Is NULL
Is not NULL
mtLong
 
mtText
 
 
mtDouble
 
mtBool
 
 
 
 
 
 
mtDate
 
 
Simple expressions composed by permitted expression
 
 
 
 
 
 
 
 
 
Comparing variable with other variables is not supported. UNICOM Intelligence Data Model is case‑sensitive with the mtText expression type. The character trait “COLLATE SQL_Latin1_General_CP1_CS_AS” is added to ensure the SQL Server will evaluate text in a case sensitive manner.
See
Expression Translator component
See also
UNICOM Intelligence Interviewer - Server Admin reference
Expression Translator component