Expression Translator component

Developer Documentation Library > Interviewer - Server Admin > UNICOM Intelligence Interviewer - Server Admin reference > 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