WhereExpFragment class - Revision history

Administrator at 07:47, 20 November 2023

2023-11-20T07:47:18Z

← Older revision		Revision as of 07:47, 20 November 2023
Line 24:		Line 24:
	{{CGscriptProperties_Template\|ReturnType=TypeInformation\|Name=<nowiki>TypeInformation</nowiki>\|HasGetter=1\|Inherited=object\|Description=<nowiki>Get information about this class.</nowiki>}}		{{CGscriptProperties_Template\|ReturnType=TypeInformation\|Name=<nowiki>TypeInformation</nowiki>\|HasGetter=1\|Inherited=object\|Description=<nowiki>Get information about this class.</nowiki>}}
	}}		}}
	~~=== <span style="color:#DF8621">'''Examples'''</span> ===~~

	~~<source lang="javascript">~~

	~~DataCacheSpecification dcs = new DataCacheSpecification (dcsRId);~~
	~~Dictionary exp = {~~
	~~"Total": new WhereExpFragment (WHEREEXPFRAGMENT_ADD, new WhereExpFragment ("count() where Gender==1"), new WhereExpFragment ("count() where Gender==2")),~~
	~~"Male": new WhereExpFragment ("count()", new WhereExpFragment ("Gender==1")),~~
	~~"Female": new WhereExpFragment ("count() where Gender==2")};~~
	~~dcs.EvalWhereExps(exp);~~
	~~</source>~~

Administrator at 09:20, 22 September 2020

2020-09-22T09:20:09Z

← Older revision		Revision as of 09:20, 22 September 2020
Line 24:		Line 24:
	{{CGscriptProperties_Template\|ReturnType=TypeInformation\|Name=<nowiki>TypeInformation</nowiki>\|HasGetter=1\|Inherited=object\|Description=<nowiki>Get information about this class.</nowiki>}}		{{CGscriptProperties_Template\|ReturnType=TypeInformation\|Name=<nowiki>TypeInformation</nowiki>\|HasGetter=1\|Inherited=object\|Description=<nowiki>Get information about this class.</nowiki>}}
	}}		}}
			=== <span style="color:#DF8621">'''Examples'''</span> ===

			<source lang="javascript">

			DataCacheSpecification dcs = new DataCacheSpecification (dcsRId);
			Dictionary exp = {
			"Total": new WhereExpFragment (WHEREEXPFRAGMENT_ADD, new WhereExpFragment ("count() where Gender==1"), new WhereExpFragment ("count() where Gender==2")),
			"Male": new WhereExpFragment ("count()", new WhereExpFragment ("Gender==1")),
			"Female": new WhereExpFragment ("count() where Gender==2")};
			dcs.EvalWhereExps(exp);
			</source>

Administrator: Created page with "{{CGscriptClass_Template |Name=WhereExpFragment |Description=Represents a data cache specification column with user data. |InheritsFrom=objec..."

2020-09-17T08:26:30Z

Created page with "{{CGscriptClass_Template |Name=<nowiki>WhereExpFragment</nowiki> |Description=<nowiki>Represents a data cache specification column with user data.</nowiki> |InheritsFrom=objec..."

New page

{{CGscriptClass_Template
|Name=<nowiki>WhereExpFragment</nowiki>
|Description=<nowiki>Represents a data cache specification column with user data.</nowiki>
|InheritsFrom=object|Constructors=
{{CGscriptConstructors_Template|Parameters=
{{CGscriptParameters_Template|Type=string|Name=<nowiki>expression</nowiki>|Description=<nowiki>Expression for the fragment.</nowiki>}}
|Description=<nowiki>Create a fragment with the given expression. This is an expensive operation when called many times</nowiki>}}
{{CGscriptConstructors_Template|Parameters=
{{CGscriptParameters_Template|Type=string|Name=<nowiki>selector</nowiki>|Description=<nowiki>Selector expression of the where expression, e.g. "count()".</nowiki>|Comma=,}}{{CGscriptParameters_Template|Type=WhereExpFragment|Name=<nowiki>whereExp</nowiki>|Description=<nowiki>Left hand side of the operation.</nowiki>}}
|Description=<nowiki>Create a fragment as a complete where expression.</nowiki>}}
{{CGscriptConstructors_Template|Parameters=
{{CGscriptParameters_Template|Type=WhereExpFragment|Name=<nowiki>fragment</nowiki>|Description=<nowiki>Fragment to replace values in.</nowiki>|Comma=,}}{{CGscriptParameters_Template|Type=Dictionary|Name=<nowiki>replacement</nowiki>|Description=<nowiki>Look for keys and replace with the constants.</nowiki>}}
|Description=<nowiki>Create a new fragment where the given values has been replaced, e.g. col > DATES + {"DATES":#2020...#} => col > #2020...#.</nowiki>}}
{{CGscriptConstructors_Template|Parameters=
{{CGscriptParameters_Template|Type=int|Name=<nowiki>operation</nowiki>|Description=<nowiki>See WHEREEXPFRAGMENT_xxx, e.g. WHEREEXPFRAGMENT_AND.</nowiki>|Comma=,}}{{CGscriptParameters_Template|Type=WhereExpFragment|Name=<nowiki>lhs</nowiki>|Description=<nowiki>Left hand side of the operation.</nowiki>|Comma=,}}{{CGscriptParameters_Template|Type=WhereExpFragment|Name=<nowiki>rhs</nowiki>|Description=<nowiki>Right hand side of the operation.</nowiki>}}
|Description=<nowiki>Create a new fragment as an operation between two other fragments.</nowiki>}}
|Methods=
{{CGscriptMethods_Template|ReturnType=Empty|Name=<nowiki>AddDependency</nowiki>|Parameters=
{{CGscriptParameters_Template|Type=string|Name=<nowiki>key</nowiki>|Description=<nowiki>Key in Dictionary that this expression depends on</nowiki>}}
|Description=<nowiki>If you access another cell, you need to inform the engine about this, so it can determine which cells to execute in parallel</nowiki>}}
{{CGscriptMethods_Template|ReturnType=string|Name=<nowiki>ToString</nowiki>|Inherited=object|Description=<nowiki>The string representation of the object.</nowiki>}}
|Properties=
{{CGscriptProperties_Template|ReturnType=string|Name=<nowiki>ObjectTypeName</nowiki>|HasGetter=1|Description=<nowiki>The name of the type of object.</nowiki>}}
{{CGscriptProperties_Template|ReturnType=TypeInformation|Name=<nowiki>TypeInformation</nowiki>|HasGetter=1|Inherited=object|Description=<nowiki>Get information about this class.</nowiki>}}
}}