FullCustomColumnSettings class

From Catglobe Wiki
Jump to: navigation, search

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 = {};
for(i for 0; fs.UpdatedNumberOfRows) {
    if (CreatedDate[i] == empty){
		result.Add(empty);
	}
	else{
		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

And data result on column main and 2 slave columns Month and Year:

2020-08-04 17-05-14.jpg