Using SortByColumn in a TableBox

Question

Hello All,

I have a TableBox generated from a process screening script. I would like to use two column to sort by sequentially.

Firstly, the col "Column" and then "xDrawingNumber". If I do this manually on the TableBox the output looks correctly, however scripting it I am unable to figure it out. I use the SortByColumn in the SendToReport option but not combination of groupings or commands have given me the right answer.

Any suggestion would be greatly appreciated.

SendToReport( Dispatch( {}, "", TableBox, {SortByColumn( "Column",1)}))

AdditiveRange10 · Answer

I think I found a solution. I removed any sorts from the Process Screening platform directly and then just use the Dispatch command with SortByColumn twice sequentially on the Process Screening variable. The sorting now looks as expected.

AdditiveRange10 · Answer

Thanks. That seems to be working for a standalone tablebox which is part of what I am trying to do.

Sadly, I also want to perform a similar two column sequential sort on the Process Screening platform directly which seems stubborn as well. In this case, I cannot work with the tablebox directly and that is why I was using the SendToReport command.

jthi · Answer

Check Table Box from scripting index and look for Sort

You might be able to do some simple "multi-column" sorts by sorting multiple times in correct order

View more... (Highlight to read)Names Default To Here(1);
New Window("Mountains",
	tb = Table Box(
		Number Col Box("R", {1,1,2,2}),
		String Col Box("Mountain",
			{"K2", "Delphi", "Kilimanjaro", "Grand Teton"}
		),
		Number Col Box("Elevation (meters)",
			{8611, 681, 5895, 4199}
		),
		Plot Col Box("", {8611, 681, 5895, 4199})
	)
);
tb << Sort By Column(3, 1);
tb << Sort By Column(1, 1);

Names Default To Here(1);
New Window("Mountains",
	tb = Table Box(
		Number Col Box("R", {1,1,2,2}),
		String Col Box("Mountain",
			{"K2", "Delphi", "Kilimanjaro", "Grand Teton"}
		),
		Number Col Box("Elevation (meters)",
			{8611, 681, 5895, 4199}
		),
		Plot Col Box("", {8611, 681, 5895, 4199})
	)
);
tb << Sort By Column(3, 1);
tb << Sort By Column(1, 1);

Quick Links