topic Yes, try [Column Name With… in Product Forum

Can I sort a collection using 2 levels?

Gulam_AbbasAlwa — Wed, 04 Apr 2018 02:26:00 GMT

Like we do in excel, is it possible to give 2 levels? So, sort collection by column A and then Column B.

Yes, try [Column Name With…

John__Carter — Wed, 04 Apr 2018 12:43:00 GMT

Yes, try [Column Name With Spaces] ASC, ColumnNameWithoutSpaces DESC

Hi John, I tried what you…

Gulam_AbbasAlwa — Wed, 04 Apr 2018 15:21:00 GMT

Hi John, I tried what you suggested but that didn't work. I'm attaching a screenshot of my collection. The objective is to get the latest row for each reference number using. So I'm trying to sort by reference and date time. What would you suggest?

I would have thought …

John__Carter — Thu, 05 Apr 2018 14:07:00 GMT

I would have thought ""Reference,ReceivedDateTime"" would work as a sort, but you'd still then need to loop through to pick out each latest reference.

If the above do not work…

TomaszAdamski — Thu, 05 Apr 2018 15:40:00 GMT

If the above do not work then you can just try sorting twice. First by Column B and then by Column A. Works fine 🙂 (at least I tested this at version 5.0.30)

Thanks John. It worked

Gulam_AbbasAlwa — Mon, 09 Apr 2018 12:43:00 GMT

Thanks John. It worked