Difference between revisions of "DCS evaluateWhereExpression"

From Catglobe Wiki
Jump to: navigation, search
(jrfconvert import)
 
Line 1: Line 1:
[[Category:HelpBooks]]
+
[[Category:Data_Cache_Functions]]
 

 

  

Revision as of 04:58, 22 March 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