topic Re: Using SortByColumn in a TableBox in Discussions

Using SortByColumn in a TableBox

AdditiveRange10 — Thu, 12 Dec 2024 20:08:53 GMT

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)}))

Re: Using SortByColumn in a TableBox

jthi — Thu, 12 Dec 2024 22:18:42 GMT

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

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);

Re: Using SortByColumn in a TableBox

AdditiveRange10 — Thu, 12 Dec 2024 23:47:42 GMT

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.

Re: Using SortByColumn in a TableBox

AdditiveRange10 — Thu, 12 Dec 2024 23:59:02 GMT

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.