Revision as of 09:21, 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]]
+__NOTOC__
 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" class="tableintopic" style="border-collapse: collapse; border: 1px solid #010101"
+{| width="438" cellpadding="2" border="1" style="border-collapse: collapse; border: 1px solid #010101" class="tableintopic"
 |- valign="top" align="left"
 | width="216" bgcolor="#C0C0C0" style="border: 1px solid #010101" |
@@ Line 115: / Line 116: @@
 number
-=== Example ===
+=== Example  ===
 number dcsResourceId1 = DCS_getCurrentDcsResourceId();