DCS Using Script - Revision history

Administrator at 09:17, 26 October 2018

2018-10-26T09:17:47Z

← Older revision		Revision as of 09:17, 26 October 2018
Line 46:		Line 46:
	</source>		</source>

	Note: ''Also support to select Ids and NonUniqueIds on DCS'':		Note: ''Also support to select Ids and NonUniqueIds of DCS'':
	<source lang="javascript">		<source lang="javascript">
	selectMultiColumn(SYS_SCRIPT_NONUNIQUEID_SYS, SYS_SCRIPT_UNIQUEID_SYS) where true;		selectMultiColumn(SYS_SCRIPT_NONUNIQUEID_SYS, SYS_SCRIPT_UNIQUEID_SYS) where true;

Administrator at 09:17, 26 October 2018

2018-10-26T09:17:05Z

← Older revision		Revision as of 09:17, 26 October 2018
Line 13:		Line 13:

	- The workflow must return [[CustomDataCacheSpecificationBuildResult class\|CustomDataCacheSpecificationBuildResult]] with UniqueIds and NonUniqueIds		- The workflow must return [[CustomDataCacheSpecificationBuildResult class\|CustomDataCacheSpecificationBuildResult]] with UniqueIds and NonUniqueIds

	~~''(Also support to select Ids and NonUniqueIds on DCS)''~~
	~~<source lang="javascript">~~
	~~selectMultiColumn(SYS_SCRIPT_NONUNIQUEID_SYS, SYS_SCRIPT_UNIQUEID_SYS) where true;~~
	~~</source>~~

	- The workflow get 5 parameters:		- The workflow get 5 parameters:
Line 49:		Line 44:
	<source lang="javascript">		<source lang="javascript">
	dcs.Rebuild(true, true, 0, true, extraParameter);		dcs.Rebuild(true, true, 0, true, extraParameter);
			</source>

			Note: ''Also support to select Ids and NonUniqueIds on DCS'':
			<source lang="javascript">
			selectMultiColumn(SYS_SCRIPT_NONUNIQUEID_SYS, SYS_SCRIPT_UNIQUEID_SYS) where true;
	</source>		</source>

Administrator at 09:06, 26 October 2018

2018-10-26T09:06:17Z

← Older revision		Revision as of 09:06, 26 October 2018
Line 90:		Line 90:
	===<span style="color:#DF8621"> Example 2 </span>===		===<span style="color:#DF8621"> Example 2 </span>===

	~~Let continue with another example using parameter:~~

	Add another column "Order" in to the above DCS, value for each row is a text: "Order number 1" to "Order number 5"		Add another column "Order" in to the above DCS, value for each row is a text: "Order number 1" to "Order number 5"

Administrator at 09:02, 26 October 2018

2018-10-26T09:02:28Z

← Older revision		Revision as of 09:02, 26 October 2018
Line 122:		Line 122:
	</source>		</source>

	( ''On the above script is used FullCustomColumnSettings for getting row number, see more the class [[FullCustomColumnSettings class\|~~here~~]]'' )		( ''On the above script is used FullCustomColumnSettings for getting row number, see more the class [[FullCustomColumnSettings class\|FullCustomColumnSettings]]'' )

	- In workflow, add 1 more line to set value:		- In workflow, add 1 more line to set value:

Administrator at 08:52, 26 October 2018

2018-10-26T08:52:39Z

← Older revision		Revision as of 08:52, 26 October 2018
Line 46:		Line 46:
	</source>		</source>

	The fifth parameter can be set when rebuild DCS, see more on dcs.Rebuild		The fifth parameter can be set when rebuild DCS, see more on the dcs.Rebuild on [[DataCacheSpecification class\|DCS class]]
	<source lang="javascript">		<source lang="javascript">
	dcs.Rebuild(true, true, 0, true, extraParameter);		dcs.Rebuild(true, true, 0, true, extraParameter);
Line 211:		Line 211:


	- Values will be set when rebuild DCS by dcs.Rebuild		- Values will be set when rebuild DCS by [[DataCacheSpecification class\|dcs.Rebuild]]
	<source lang="javascript">		<source lang="javascript">
	DataCacheSpecification dcs = new DataCacheSpecification(DCSRid);		DataCacheSpecification dcs = new DataCacheSpecification(DCSRid);

Administrator at 08:43, 26 October 2018

2018-10-26T08:43:42Z

← Older revision		Revision as of 08:43, 26 October 2018
Line 12:		Line 12:
	DCS using with script, required a workflow:		DCS using with script, required a workflow:

	- The workflow must return [[CustomDataCacheSpecificationBuildResult class\|CustomDataCacheSpecificationBuildResult]]		- The workflow must return [[CustomDataCacheSpecificationBuildResult class\|CustomDataCacheSpecificationBuildResult]] with UniqueIds and NonUniqueIds

			''(Also support to select Ids and NonUniqueIds on DCS)''
			<source lang="javascript">
			selectMultiColumn(SYS_SCRIPT_NONUNIQUEID_SYS, SYS_SCRIPT_UNIQUEID_SYS) where true;
			</source>

	- The workflow get 5 parameters:		- The workflow get 5 parameters:
Line 41:		Line 46:
	</source>		</source>

	The fifth parameter can be set when rebuild DCS		The fifth parameter can be set when rebuild DCS, see more on dcs.Rebuild
	<source lang="javascript">		<source lang="javascript">
	dcs.Rebuild(true, true, 0, true, extraParameter);		dcs.Rebuild(true, true, 0, true, extraParameter);

Administrator at 08:35, 26 October 2018

2018-10-26T08:35:23Z

← Older revision		Revision as of 08:35, 26 October 2018
Line 12:		Line 12:
	DCS using with script, required a workflow:		DCS using with script, required a workflow:

	- The workflow must return CustomDataCacheSpecificationBuildResult		- The workflow must return [[CustomDataCacheSpecificationBuildResult class\|CustomDataCacheSpecificationBuildResult]]

	- The workflow get 5 parameters:		- The workflow get 5 parameters:
Line 70:		Line 70:
	[[File:2018-10-25_11-40-05.png]]		[[File:2018-10-25_11-40-05.png]]

	Code on workflow must return CustomDataCacheSpecificationBuildResult, how many rows on DCS belonging the length of ~~res~~.		Code on workflow must return [[CustomDataCacheSpecificationBuildResult class\|CustomDataCacheSpecificationBuildResult]], how many rows on DCS belonging the length of array Ids and NonUniqueIds.
	In this example, res is returned with array 5 items, therefor the DCS have 5 rows		In this example, res is returned with array 5 items, therefor the DCS have 5 rows

Line 83:		Line 83:

	[[File:2018-10-25_11-22-00.png]]		[[File:2018-10-25_11-22-00.png]]


	===<span style="color:#DF8621"> Example 2 </span>===		===<span style="color:#DF8621"> Example 2 </span>===

Line 119:		Line 117:
	</source>		</source>

			( ''On the above script is used FullCustomColumnSettings for getting row number, see more the class [[FullCustomColumnSettings class\|here]]'' )

	- In workflow, add 1 more line to set value:		- In workflow, add 1 more line to set value:

Administrator at 08:21, 26 October 2018

2018-10-26T08:21:10Z

← Older revision		Revision as of 08:21, 26 October 2018
Line 1:		Line 1:
	[[Category:Answer_sheet_data_caches]]		[[Category:Answer_sheet_data_caches]]

			=DCS Using Script=

			== <span style="color:#DF8621">'''Overview'''</span> ==

	DCS now can have data without using questionnaire, it's setting by script:		DCS now can have data without using questionnaire, it's setting by script:

Line 41:		Line 46:
	</source>		</source>

	Example:		== <span style="color:#DF8621">'''Example'''</span> ==

			===<span style="color:#DF8621"> Example 1 </span>===


	1. A simple DCS with one column name "test" and 5 rows, value for each row is a random number. Like this:		A simple DCS with one column name "test" and 5 rows, value for each row is a random number. Like this:

	[[File:2018-10-25_11-22-00.png]]		[[File:2018-10-25_11-22-00.png]]
Line 77:		Line 85:


	2. Let continue with another example using parameter:		===<span style="color:#DF8621"> Example 2 </span>===

			Let continue with another example using parameter:

	Add another column "Order" in to the above DCS, value for each row is a text: "Order number 1" to "Order number 5"		Add another column "Order" in to the above DCS, value for each row is a text: "Order number 1" to "Order number 5"
Line 124:		Line 134:


	3. Let add one more column order same with the column Order above, name "Order1"
			===<span style="color:#DF8621"> Example 3 </span>===

			Let add one more column order same with the column Order above, name "Order1"

	[[File:2018-10-26_11-48-55.png]]		[[File:2018-10-26_11-48-55.png]]
Line 162:		Line 175:


	4. DCS can also get value while buiding DCS, by using the fifth parameter
			===<span style="color:#DF8621"> Example 4 </span>===

			DCS can also get value while buiding DCS, by using the fifth parameter

	Let make an example, add another column name "Date" to the DCS, value for each row is current dateTime when build DCS		Let make an example, add another column name "Date" to the DCS, value for each row is current dateTime when build DCS

Administrator at 08:02, 26 October 2018

2018-10-26T08:02:03Z

← Older revision		Revision as of 08:02, 26 October 2018
Line 135:		Line 135:

	[[File:2018-10-26_12-00-04.png]]		[[File:2018-10-26_12-00-04.png]]


	- Create a full custom column name "Order1"		- Create a full custom column name "Order1"
Line 154:		Line 155:

	[[File:2018-10-26_12-04-45.png]]		[[File:2018-10-26_12-04-45.png]]


	After rebuilding DCS, value for row will be replace "y" by value "Order number " which was wet from DCS parameter		After rebuilding DCS, value for row will be replace "y" by value "Order number " which was wet from DCS parameter
Line 165:		Line 167:

	[[File:2018-10-26_13-43-15.png]]		[[File:2018-10-26_13-43-15.png]]


	How to do:		How to do:
Line 171:		Line 174:

	[[File:2018-10-26_13-48-18.png]]		[[File:2018-10-26_13-48-18.png]]


	- On workflow add a line to get the fifth parameter		- On workflow add a line to get the fifth parameter
Line 185:		Line 189:

	[[File:2018-10-26_13-55-24.png]]		[[File:2018-10-26_13-55-24.png]]


	- Values will be set when rebuild DCS by dcs.Rebuild		- Values will be set when rebuild DCS by dcs.Rebuild
Line 192:		Line 197:
	dcs.Rebuild(true, true, 0, true, extraParameter);		dcs.Rebuild(true, true, 0, true, extraParameter);
	</source>		</source>


	DCS will look like below after rebuiding:		DCS will look like below after rebuiding:

	[[File:2018-10-26_13-43-15.png]]		[[File:2018-10-26_13-43-15.png]]

Administrator at 07:56, 26 October 2018

2018-10-26T07:56:38Z

← Older revision		Revision as of 07:56, 26 October 2018
Line 88:		Line 88:

	[[File:2018-10-26_10-35-15.png]]		[[File:2018-10-26_10-35-15.png]]


	Because on script of Order custom column, have an undefined variables x, therefore we can not create that Order column on UI, just make by cgscrip:		Because on script of Order custom column, have an undefined variables x, therefore we can not create that Order column on UI, just make by cgscrip:
Line 116:		Line 117:

	[[File:2018-10-26_10-36-36.png]]		[[File:2018-10-26_10-36-36.png]]


	After rebuild the DCS, "x" will be replace by "Order number "		After rebuild the DCS, "x" will be replace by "Order number "