Difference between revisions of "DCS evaluateWhereExpression"
Line 1: | Line 1: | ||
[[Category:Data_Cache_Functions]] | [[Category:Data_Cache_Functions]] | ||
− | | + | {{HelpFiles}} |
====DCS_evaluateWhereExpression==== | ====DCS_evaluateWhereExpression==== |
Revision as of 08: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
|