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
|