Revision as of 08:20, 15 December 2011

DCS_evaluateWhereExpression

Evaluate a WHERE expression

DCS_evaluateWhereExpression(whereExpression)

Execute the where expression and return an object depending on where expression:

WhereExpression	Return type
average	empty
count	number
max	number
median	number
min	number
percentile	number
quantile	number
select	empty
selectColumn	array
stdev	number
sterr	number
sum	number
variance	number Example number dcsResourceId1 = DCS_getCurrentDcsResourceId(); number dcsResourceId2 = 123456; string expression1 = "average(Single2) where true;"; string expression2 = "min(Single2) where true;"; DCS_use(dcsResourceId2); print(DCS_evaluateWhereExpression(expression1)); print(DCS_evaluateWhereExpression(expression2));

@@ Line 1: / Line 1: @@
-==== DCS_evaluateWhereExpression ====
+=DCS_evaluateWhereExpression =
+[[Category:Data_Cache_Functions]]
 Evaluate a WHERE expression
-===Syntax===
+=== Syntax ===
 DCS_evaluateWhereExpression(whereExpression)
-===Arguments===
+=== Arguments ===
 *whereExpression: is string. ex: "selectColumn(Id) where true;"
-===Return value===
+=== Return value ===
 Execute the where expression and return an object depending on where expression:
-{| width="438" cellpadding="2" border="1" style="border-collapse: collapse; border: 1px solid #010101" class="tableintopic"
+{| width="438" cellpadding="2" border="1" class="tableintopic" style="border-collapse: collapse; border: 1px solid #010101"
 |- valign="top" align="left"
 | width="216" bgcolor="#C0C0C0" style="border: 1px solid #010101" |
@@ Line 114: / Line 115: @@
 number
-===Example===
+=== Example ===
 number dcsResourceId1 = DCS_getCurrentDcsResourceId();
@@ Line 129: / Line 130: @@
 print(DCS_evaluateWhereExpression(expression2));
-'''Availability'''
-Version 5.8 __NOTOC__ <!-- imported from file: 7584.htm-->
 |}
-[[Category:Data_Cache_Functions]]