DCS evaluateWhereExpression: Difference between revisions
From Catglobe Wiki
More actions
No edit summary  | 
				No edit summary  | 
				||
| Line 1: | Line 1: | ||
[[Category:Data_Cache_Functions]]  | [[Category:Data_Cache_Functions]]  | ||
  | {{HelpFiles}}  | ||
====DCS_evaluateWhereExpression====  | ====DCS_evaluateWhereExpression====  | ||
Revision as of 07:36, 12 December 2011
DCS_evaluateWhereExpression
Evaluate a WHERE expression
Syntax
DCS_evaluateWhereExpression(whereExpression)
Arguments
- whereExpression: is string
 
Return value
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)); Availability Version 5.8 
  |