DCS evaluateWhereExpression - Revision history

Administrator: /* DCS_evaluateWhereExpression */

2018-12-05T08:57:59Z

DCS_evaluateWhereExpression

← Older revision		Revision as of 08:57, 5 December 2018
Line 4:		Line 4:

	Evaluate a WHERE expression. See also [[DCS evaluateWhereExpressions]] for faster evalution of multiple expressions.		Evaluate a WHERE expression. See also [[DCS evaluateWhereExpressions]] for faster evalution of multiple expressions.

			This function is an alias to EvalWhere in [[DataCacheSpecification class]].

	=== Syntax ===		=== Syntax ===

Administrator: /* DCS_evaluateWhereExpression */

2018-12-05T08:56:23Z

DCS_evaluateWhereExpression

← Older revision		Revision as of 08:56, 5 December 2018
Line 3:		Line 3:
	__NOTOC__		__NOTOC__

	Evaluate a WHERE expression		Evaluate a WHERE expression. See also [[DCS evaluateWhereExpressions]] for faster evalution of multiple expressions.

	=== Syntax ===		=== Syntax ===
Line 17:		Line 17:
	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" ~~class~~="~~tableintopic~~"		{\| class="tableintopic" style="border-collapse: collapse; border: 1px solid #010101" width="438" cellpadding="2" border="1"
	\|- valign="top" align="left"		\|- valign="top" align="left"
	\| width="216" bgcolor="#C0C0C0~~" style="border: 1px solid #010101~~" \|		\| style="border: 1px solid #010101" width="216" bgcolor="#C0C0C0" \|
	'''WhereExpression'''		'''WhereExpression'''

	\| width="222" bgcolor="#C0C0C0~~" style="border: 1px solid #010101~~" \|		\| style="border: 1px solid #010101" width="222" bgcolor="#C0C0C0" \|
	'''Return type'''		'''Return type'''

	\|- valign="top" align="left"		\|- valign="top" align="left"
	\| ~~width="216"~~ style="border: 1px solid #010101" \|		\| style="border: 1px solid #010101" width="216" \|
	average		average

	\| ~~width="222"~~ style="border: 1px solid #010101" \|		\| style="border: 1px solid #010101" width="222" \|
	empty		empty

	\|- valign="top" align="left"		\|- valign="top" align="left"
	\| ~~width="216"~~ style="border: 1px solid #010101" \|		\| style="border: 1px solid #010101" width="216" \|
	count		count

	\| ~~width="222"~~ style="border: 1px solid #010101" \|		\| style="border: 1px solid #010101" width="222" \|
	number		number

	\|- valign="top" align="left"		\|- valign="top" align="left"
	\| ~~width="216"~~ style="border: 1px solid #010101" \|		\| style="border: 1px solid #010101" width="216" \|
	max		max

	\| ~~width="222"~~ style="border: 1px solid #010101" \|		\| style="border: 1px solid #010101" width="222" \|
	number		number

	\|- valign="top" align="left"		\|- valign="top" align="left"
	\| ~~width="216"~~ style="border: 1px solid #010101" \|		\| style="border: 1px solid #010101" width="216" \|
	median		median

	\| ~~width="222"~~ style="border: 1px solid #010101" \|		\| style="border: 1px solid #010101" width="222" \|
	number		number

	\|- valign="top" align="left"		\|- valign="top" align="left"
	\| ~~width="216"~~ style="border: 1px solid #010101" \|		\| style="border: 1px solid #010101" width="216" \|
	min		min

	\| ~~width="222"~~ style="border: 1px solid #010101" \|		\| style="border: 1px solid #010101" width="222" \|
	number		number

	\|- valign="top" align="left"		\|- valign="top" align="left"
	\| ~~width="216"~~ style="border: 1px solid #010101" \|		\| style="border: 1px solid #010101" width="216" \|
	percentile		percentile

	\| ~~width="222"~~ style="border: 1px solid #010101" \|		\| style="border: 1px solid #010101" width="222" \|
	number		number

	\|- valign="top" align="left"		\|- valign="top" align="left"
	\| ~~width="216"~~ style="border: 1px solid #010101" \|		\| style="border: 1px solid #010101" width="216" \|
	quantile		quantile

	\| ~~width="222"~~ style="border: 1px solid #010101" \|		\| style="border: 1px solid #010101" width="222" \|
	number		number

	\|- valign="top" align="left"		\|- valign="top" align="left"
	\| ~~width="216"~~ style="border: 1px solid #010101" \|		\| style="border: 1px solid #010101" width="216" \|
	select		select

	\| ~~width="222"~~ style="border: 1px solid #010101" \|		\| style="border: 1px solid #010101" width="222" \|
	empty		empty

	\|- valign="top" align="left"		\|- valign="top" align="left"
	\| ~~width="216"~~ style="border: 1px solid #010101" \|		\| style="border: 1px solid #010101" width="216" \|
	selectColumn		selectColumn

	\| ~~width="222"~~ style="border: 1px solid #010101" \|		\| style="border: 1px solid #010101" width="222" \|
	array		array

	\|- valign="top" align="left"		\|- valign="top" align="left"
	\| ~~width="216"~~ style="border: 1px solid #010101" \|		\| style="border: 1px solid #010101" width="216" \|
	stdev		stdev

	\| ~~width="222"~~ style="border: 1px solid #010101" \|		\| style="border: 1px solid #010101" width="222" \|
	number		number

	\|- valign="top" align="left"		\|- valign="top" align="left"
	\| ~~width="216"~~ style="border: 1px solid #010101" \|		\| style="border: 1px solid #010101" width="216" \|
	sterr		sterr

	\| ~~width="222"~~ style="border: 1px solid #010101" \|		\| style="border: 1px solid #010101" width="222" \|
	number		number

	\|- valign="top" align="left"		\|- valign="top" align="left"
	\| ~~width="216"~~ style="border: 1px solid #010101" \|		\| style="border: 1px solid #010101" width="216" \|
	sum		sum

	\| ~~width="222"~~ style="border: 1px solid #010101" \|		\| style="border: 1px solid #010101" width="222" \|
	number		number

	\|- valign="top" align="left"		\|- valign="top" align="left"
	\| ~~width="216"~~ style="border: 1px solid #010101" \|		\| style="border: 1px solid #010101" width="216" \|
	variance		variance

	\| ~~width="222"~~ style="border: 1px solid #010101" \|		\| style="border: 1px solid #010101" width="222" \|
	number		number
	\|}		\|}

Cg van: /* Example */

2011-12-20T10:21:39Z

Example

← Older revision		Revision as of 10:21, 20 December 2011
Line 117:		Line 117:
	\|}		\|}

	=== Example ===		===== Example =====

	number dcsResourceId1 = DCS_getCurrentDcsResourceId();		''number dcsResourceId1 = DCS_getCurrentDcsResourceId(); ''

	number dcsResourceId2 = 123456;		''number dcsResourceId2 = 123456; ''

	string expression1 = "average(Single2) where true;";		''string expression1 = "average(Single2) where true;"; ''

	string expression2 = "min(Single2) where true;";		''string expression2 = "min(Single2) where true;"; ''

	DCS_use(dcsResourceId2);		''DCS_use(dcsResourceId2); ''

	print(DCS_evaluateWhereExpression(expression1));		''print(DCS_evaluateWhereExpression(expression1)); //return average value of question Single2 ''

	print(DCS_evaluateWhereExpression(expression2));		''print(DCS_evaluateWhereExpression(expression2)); //return minimum value of question Single2 ''

Cg van at 08:09, 20 December 2011

2011-12-20T08:09:50Z

← Older revision		Revision as of 08:09, 20 December 2011
Line 115:		Line 115:
	\| width="222" style="border: 1px solid #010101" \|		\| width="222" style="border: 1px solid #010101" \|
	number		number
			\|}

	=== Example ===		=== Example ===
Line 130:		Line 131:
	print(DCS_evaluateWhereExpression(expression1));		print(DCS_evaluateWhereExpression(expression1));

	print(DCS_evaluateWhereExpression(expression2));		print(DCS_evaluateWhereExpression(expression2));

	\|}

Tungocman at 08:21, 15 December 2011

2011-12-15T08:21:42Z

← Older revision		Revision as of 08:21, 15 December 2011
Line 1:		Line 1:
	=DCS_evaluateWhereExpression =		= DCS_evaluateWhereExpression =
	[[Category:Data_Cache_Functions]]		[[Category:Data_Cache_Functions]]
			__NOTOC__

	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~~" class="tableintopic~~" style="border-collapse: collapse; border: 1px solid #010101"		{\| width="438" cellpadding="2" border="1" style="border-collapse: collapse; border: 1px solid #010101" class="tableintopic"
	\|- 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 115:		Line 116:
	number		number

	=== Example ===		=== Example ===

	number dcsResourceId1 = DCS_getCurrentDcsResourceId();		number dcsResourceId1 = DCS_getCurrentDcsResourceId();

Tungocman at 08:20, 15 December 2011

2011-12-15T08:20:58Z

← Older revision		Revision as of 08:20, 15 December 2011
Line 1:		Line 1:
	~~===~~= DCS_evaluateWhereExpression =~~===~~		=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~~" class="tableintopic~~"		{\| 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));

	~~'''Availability'''~~

	~~Version 5.8 __NOTOC__ <!-- imported from file: 7584.htm-->~~

	\|}		\|}

	~~[[Category:Data_Cache_Functions]]~~

Tungocman at 08:19, 15 December 2011

2011-12-15T08:19:41Z

Show changes

Cg_pham at 07:36, 12 December 2011

2011-12-12T07:36:20Z

← Older revision		Revision as of 07:36, 12 December 2011
Line 1:		Line 1:
	[[Category:Data_Cache_Functions]]		[[Category:Data_Cache_Functions]]
			{{HelpFiles}}

	====DCS_evaluateWhereExpression====		====DCS_evaluateWhereExpression====

Cg_pham at 03:58, 22 March 2011

2011-03-22T03:58:47Z

← Older revision		Revision as of 03:58, 22 March 2011
Line 1:		Line 1:
	[[Category:~~HelpBooks~~]]		[[Category:Data_Cache_Functions]]

Catglobe: jrfconvert import

2011-03-07T08:46:50Z

jrfconvert import

New page

[[Category:HelpBooks]]

====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:

{| class="tableintopic" style="border-collapse: collapse; border: 1px solid #010101" width="438" border="1" cellpadding="2"
|- align="left" valign="top"
| style="border: 1px solid #010101" width="216" bgcolor="#C0C0C0" |
'''WhereExpression'''
| style="border: 1px solid #010101" width="222" bgcolor="#C0C0C0" |
'''Return type'''
|- align="left" valign="top"
| style="border: 1px solid #010101" width="216" |
average
| style="border: 1px solid #010101" width="222" |
empty
|- align="left" valign="top"
| style="border: 1px solid #010101" width="216" |
count
| style="border: 1px solid #010101" width="222" |
number
|- align="left" valign="top"
| style="border: 1px solid #010101" width="216" |
max
| style="border: 1px solid #010101" width="222" |
number
|- align="left" valign="top"
| style="border: 1px solid #010101" width="216" |
median
| style="border: 1px solid #010101" width="222" |
number
|- align="left" valign="top"
| style="border: 1px solid #010101" width="216" |
min
| style="border: 1px solid #010101" width="222" |
number
|- align="left" valign="top"
| style="border: 1px solid #010101" width="216" |
percentile
| style="border: 1px solid #010101" width="222" |
number
|- align="left" valign="top"
| style="border: 1px solid #010101" width="216" |
quantile
| style="border: 1px solid #010101" width="222" |
number
|- align="left" valign="top"
| style="border: 1px solid #010101" width="216" |
select
| style="border: 1px solid #010101" width="222" |
empty
|- align="left" valign="top"
| style="border: 1px solid #010101" width="216" |
selectColumn
| style="border: 1px solid #010101" width="222" |
array
|- align="left" valign="top"
| style="border: 1px solid #010101" width="216" |
stdev
| style="border: 1px solid #010101" width="222" |
number
|- align="left" valign="top"
| style="border: 1px solid #010101" width="216" |
sterr
| style="border: 1px solid #010101" width="222" |
number
|- align="left" valign="top"
| style="border: 1px solid #010101" width="216" |
sum
| style="border: 1px solid #010101" width="222" |
number
|- align="left" valign="top"
| style="border: 1px solid #010101" width="216" |
variance
| style="border: 1px solid #010101" width="222" |
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
__NOTOC__