Difference between revisions of "DCS evaluateWhereExpression"
| Line 1: | Line 1: | ||
| − | + | =DCS_evaluateWhereExpression = | |
| + | [[Category:Data_Cache_Functions]] | ||
Evaluate a WHERE expression | Evaluate a WHERE expression | ||
| − | ===Syntax=== | + | === Syntax === |
DCS_evaluateWhereExpression(whereExpression) | DCS_evaluateWhereExpression(whereExpression) | ||
| − | ===Arguments=== | + | === Arguments === |
*whereExpression: is string. ex: "selectColumn(Id) where true;" | *whereExpression: is string. ex: "selectColumn(Id) where true;" | ||
| − | ===Return value=== | + | === Return value === |
Execute the where expression and return an object depending on where expression: | Execute the where expression and return an object depending on where expression: | ||
| − | {| width="438" cellpadding="2" border="1" style="border-collapse: collapse; border: 1px solid #010101 | + | {| width="438" cellpadding="2" border="1" class="tableintopic" style="border-collapse: collapse; border: 1px solid #010101" |
|- valign="top" align="left" | |- valign="top" align="left" | ||
| width="216" bgcolor="#C0C0C0" style="border: 1px solid #010101" | | | width="216" bgcolor="#C0C0C0" style="border: 1px solid #010101" | | ||
| Line 114: | Line 115: | ||
number | number | ||
| − | ===Example=== | + | === Example === |
number dcsResourceId1 = DCS_getCurrentDcsResourceId(); | number dcsResourceId1 = DCS_getCurrentDcsResourceId(); | ||
| Line 129: | Line 130: | ||
print(DCS_evaluateWhereExpression(expression2)); | print(DCS_evaluateWhereExpression(expression2)); | ||
| − | |||
| − | |||
| − | |||
| − | |||
|} | |} | ||
| − | |||
| − | |||
Revision as of 10:20, 15 December 2011
DCS_evaluateWhereExpression
Evaluate a WHERE expression
Syntax
DCS_evaluateWhereExpression(whereExpression)
Arguments
- whereExpression: is string. ex: "selectColumn(Id) where true;"
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 Examplenumber 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)); |
