Difference between revisions of "FullCustomColumnSettings class"

From Catglobe Wiki
Jump to: navigation, search
Line 11: Line 11:
 
}}
 
}}
 
=== <span style="color:#DF8621">'''Examples'''</span> ===
 
=== <span style="color:#DF8621">'''Examples'''</span> ===
 +
<span style="color:#DF8621">Example for make a "Date" custom column (full column) base on "CreateDate"</span>
 
<source lang="javascript">
 
<source lang="javascript">
//Example for make a "Date" custom column (full column) base on "CreateDate"
 
 
array param = Workflow_getParameters();
 
array param = Workflow_getParameters();
 
Dictionary localCache = param[0];
 
Dictionary localCache = param[0];
Line 26: Line 26:
 
</source>
 
</source>
 
[[File:2020-07-01_9-54-59.png]]
 
[[File:2020-07-01_9-54-59.png]]
 +
 +
<span style="color:#DF8621">Example for using local cache on custom columns</span>
 +
<source lang="javascript">
 +
//Script on Main column
 +
array param = Workflow_getParameters();//preserved between customcols
 +
Dictionary localCache = param[0];
 +
array aMonth;
 +
array aYear;
 +
array result;
 +
for(i for 0; Id.Count) {
 +
aMonth.Add(12);
 +
aYear.Add(2050);
 +
result.Add(i);
 +
}
 +
localCache["month"]= aMonth;
 +
localCache["year"]= aYear;
 +
return result;
 +
</source>
 +
[[File:MainCol.png]]
 +
 +
<source lang="javascript">
 +
//On slave column "Year" and "Month" just make a return from "mainCol"
 +
return mainCol["month"];
 +
return mainCol["year"];
 +
</source>
 +
[[File:2020-08-04_16-17-32.png]]

Revision as of 11:02, 4 August 2020

FullCustomColumnSettings



Settings that affect the rebuild of a full column custom column.

Parent class

Inherits from object

Methods

  • (From object) string ToString() - The string representation of the object.

Properties

  • string ObjectTypeName { get; } - The name of the type of object.
  • (From object) TypeInformation TypeInformation { get; } - Get information about this class.
  • int UpdatedNumberOfRows { get; } - Amount of rows needed to return.
  • bool WorkOnFullColumnDuringPartialRebuild { get; set; } - If false(default) then during rebuild when accessing another column then only the new rows are returned. Otherwise return the full dataset. Only has effect if set before first reference to column and before returning final result.

Examples

Example for make a "Date" custom column (full column) base on "CreateDate"

array param = Workflow_getParameters();
Dictionary localCache = param[0];
FullCustomColumnSettings fs = param[1];
array result = {};
number cnt = fs.UpdatedNumberOfRows;
for(number i = 0; i < cnt; i++) {
    if (CreatedDate[i] == empty)
        result.Add(empty);
    result.Add(CreatedDate[i][DateTime_Year]*10000 + CreatedDate[i][DateTime_Month]*100 + CreatedDate[i][DateTime_Day]);
}
return result;

2020-07-01 9-54-59.png

Example for using local cache on custom columns

//Script on Main column
array param = Workflow_getParameters();//preserved between customcols
Dictionary localCache = param[0];
array aMonth;
array aYear;
array result;
for(i for 0; Id.Count) {
	aMonth.Add(12);
	aYear.Add(2050);
	result.Add(i);
}
localCache["month"]= aMonth;
localCache["year"]= aYear;
return result;

MainCol.png

//On slave column "Year" and "Month" just make a return from "mainCol"
return mainCol["month"];
return mainCol["year"];

2020-08-04 16-17-32.png