DCS evaluateWhereExpression
From Catglobe Wiki
More actions
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 
  |