802196_en-US

liliconcom

[JSL] Save a script of a New Window () to data table

Hello,

I am generating a New Window() to output a report of a concatenation between tables.

It shows the last record before concatenation, today's date and the number of rows of the data table.

My goal is to save the script of this window into the data table, to be executed from the data table.

I don't know how to get the the << get script, << new script to work (if this is the right method).

if I show() the generated script, it is in fact a combination of V list box and I don't understand why... (see log below)

 

Thanks for your help

 

- Voiz

 

The script:

dt = New Table( "datatable_test5",
	Add Rows( 7 ),
	New Column( "SerialNumber",
		Character( 20 ),
		"Nominal",
		Set Values(
			{"DN802111YSKQ45752507", "DN802111YSKQ45752507",
			"DN802111YSKQ45752507", "DN802111YSQQ4575X379",
			"DN802111YSQQ4575X379", "DN802111YSQQ4575X379",
			"DN802111YUAQ45755340"}
		),
		Set Display Width( 233 )
	),
	New Column( "stored_at",
		Numeric,
		"Continuous",
		Format( "y/m/d h:m:s", 22, 0 ),
		Input Format( "y/m/d h:m:s", 0 ),
		Set Values(
			[3806904000, 3806990820, 3806904780, 3806905200, 3806992020,
			3806906400, 3806906820]
		),
		Set Display Width( 169 )
	),
	New Column( "Version",
		Character( 9 ),
		"Nominal",
		Set Values(
			{"Version 3", "Version 1", "Version 2", "Version 5",
			"Version 4", "Version 2", "Version 3"}
		),
		Set Display Width( 100 )
	),
	New Column( "Metric1",
		Numeric,
		"Continuous",
		Format( "Best", 10 ),
		Set Property(
			"Spec Limits",
			{LSL( 0 ), USL( 40 ), Show Limits( 1 )}
		),
		Set Values(
			[16.197252, 6.39561587, 6.5805566, 6.1837729, 16.3159215,
			12.7256798, 9.83716952]
		),
		Set Display Width( 110 )
	)
);

oldlastrecord= format(Col Maximum(dt:stored_at), "y/m/d h:m:s");
Newlastrecord= format(today(), "y/m/d h:m:s");
Ndata = Nrows(dt);

ReportMsg = New Window( "Station ---",
	//<<MODAL></MODAL>

Which generate this log

ReportScript = 
V List Box(
	V List Box(
		OutlineBox(
			TableBox(
				StringColBox("2024/08/20 9:47:00 AM"), 
				StringColBox("2024/09/26 10:46:22 PM"), 
				NumberColBox(Set Format("Best", 7), Array(7))
			)
		)
	)
);

 

 

Automation and Scripting