Expression Script Examples - Revision history

MarHink: /* Create a new object-centric model based on already existing object-centric model containing only filtered objects and events */

2026-01-12T08:22:24Z

Create a new object-centric model based on already existing object-centric model containing only filtered objects and events

← Older revision		Revision as of 08:22, 12 January 2026
Line 776:		Line 776:

	=== Create a new object-centric model based on already existing object-centric model containing only filtered objects and events ===		=== Create a new object-centric model based on already existing object-centric model containing only filtered objects and events ===
	Script for creating a new ~~OCPM~~-model based on another already existing model ~~in PA~~ that applies given filter to the original model and creates all the needed tables to store only the relevant rows for all the ~~OCPM~~ data tables.<syntaxhighlight lang="typescript">		Script for creating a new object-centric model based on another already existing object-centric model that applies given filter to the original model and creates all the needed tables to store only the relevant rows for all the object-centric data tables.

			NOTE: Replace <nowiki><source model id>, <target model name>, <target project id> as well as the value of ocelItems with the applicable values before use.</nowiki><syntaxhighlight lang="typescript">
	let newModelName = "<target model name>";		let newModelName = "<target model name>";
	let sourceModelId = <source model id>;		let sourceModelId = <source model id>;

2026-01-12T08:18:53Z

← Older revision		Revision as of 08:18, 12 January 2026
Line 776:		Line 776:

	=== Create a new object-centric model based on already existing object-centric model containing only filtered objects and events ===		=== Create a new object-centric model based on already existing object-centric model containing only filtered objects and events ===
	Script for creating a new OCPM-model based on another already existing model in PA that applies given filter to the original model and creates all the needed tables to store only the relevant rows for all the OCPM data tables.		Script for creating a new OCPM-model based on another already existing model in PA that applies given filter to the original model and creates all the needed tables to store only the relevant rows for all the OCPM data tables.<syntaxhighlight lang="typescript">

	~~NOTE: Replace <nowiki><source model id>, <target model name>, <target project id> as well as the value of ocelItems with the applicable values before use.</nowiki>~~<syntaxhighlight lang="typescript">
	let newModelName = "<target model name>";		let newModelName = "<target model name>";
	let sourceModelId = <source model id>;		let sourceModelId = <source model id>;

2026-01-12T08:17:08Z

@@ Line 773: / Line 773: @@
    .Collect()
    .ToCSV();
 </syntaxhighlight>

2025-12-15T08:12:40Z

Convert datatable column data (Snowflake)

← Older revision		Revision as of 08:12, 15 December 2025
Line 84:		Line 84:

	=== Convert datatable column data (Snowflake) ===		=== Convert datatable column data (Snowflake) ===
	Following script converts textual data in column "TimestampString" to ~~date format~~ to column "Timestamp" by trying different time formats.		Following script converts textual data from the column "TimestampString" to dates to column "Timestamp" by trying different time formats and using the first suitable.

	<syntaxhighlight lang="typescript" line>		<syntaxhighlight lang="typescript" line>

2025-12-15T08:11:40Z

Convert datatable column data

@@ Line 83: / Line 83: @@
 </syntaxhighlight>
-=== Convert datatable column data ===
+=== Convert datatable column data (Snowflake) ===
 This script can be used to convert a single column into numerical data type. To use the script, you need to setup the following in the beginning of the script:
 * Project name where the datatable is located.

2025-06-11T21:52:41Z

Show duplicate rows in datatable

← Older revision		Revision as of 21:52, 11 June 2025
Line 740:		Line 740:

	=== Show duplicate rows in datatable ===		=== Show duplicate rows in datatable ===
	This script returns all rows in a datatable appearing more than once. ~~Also~~ the number of occurrences is returned as the last column. Replace the datatable id with the correct one.		This script returns all rows in a datatable appearing more than once (sorted by the most frequent occurrences first). Additionally, the number of occurrences is returned as the last column. Replace the datatable id with the correct one.

	<syntaxhighlight lang="typescript">		<syntaxhighlight lang="typescript">

2025-06-11T21:51:43Z

Show duplicate rows in datatable

← Older revision		Revision as of 21:51, 11 June 2025
Line 756:		Line 756:
	.OrderByColumns([rowCountColumn], [false])		.OrderByColumns([rowCountColumn], [false])
	.Collect()		.Collect()
	.~~toCSV~~();		.ToCSV();
	</syntaxhighlight>		</syntaxhighlight>

2025-06-11T21:51:31Z

Show duplicate rows in datatable

← Older revision		Revision as of 21:51, 11 June 2025
Line 744:		Line 744:
	<syntaxhighlight lang="typescript">		<syntaxhighlight lang="typescript">
	let datatableId = 1;		let datatableId = 1;
	let rowCountColumn = "~~_rowCount~~";		let rowCountColumn = "Row count";
	let columns = DatatableById(datatableId).Columns.Name;		let columns = DatatableById(datatableId).Columns.Name;
	DatatableById(datatableId)		DatatableById(datatableId)

2025-06-11T21:50:59Z

Show duplicate rows in datatable

← Older revision		Revision as of 21:50, 11 June 2025
Line 747:		Line 747:
	let columns = DatatableById(datatableId).Columns.Name;		let columns = DatatableById(datatableId).Columns.Name;
	DatatableById(datatableId)		DatatableById(datatableId)
	.SqlDataFrame		.SqlDataFrame
	.GroupBy(columns)		.GroupBy(columns)
	.Aggregate(		.Aggregate(
	[rowCountColumn: columns[0]],		[rowCountColumn: columns[0]],
	["Count"]		["Count"]
	)		)
	.Where(Column(rowCountColumn) > 1)		.Where(Column(rowCountColumn) > 1)
	.OrderByColumns([rowCountColumn], [false])		.OrderByColumns([rowCountColumn], [false])
	.Collect()		.Collect()
	.toCSV();		.toCSV();
	</syntaxhighlight>		</syntaxhighlight>

2025-06-11T21:50:32Z

← Older revision		Revision as of 21:50, 11 June 2025
Line 738:		Line 738:
	ConvertCCModelToOCModel(ccModel, `ocel - ${ccModel.Name}`);		ConvertCCModelToOCModel(ccModel, `ocel - ${ccModel.Name}`);
	</syntaxhighlight>		</syntaxhighlight>


	=== Show duplicate rows in datatable ===		=== Show duplicate rows in datatable ===