FEATURECollection-Scoped SequencesRead moreFEATUREORDER BY & Conversion Rate Metrics in LayersQLRead moreFEATUREEditable Block Strategy and Live Block CollaborationRead moreFEATUREDynamic Linking OffsetRead moreFEATUREClicked Section and Clicked Block ConditionsRead more
Schedule a demo
← Back to Changelog

Sort Order Handles in LayersQL

A LayersQL query on the collections dataset showing FROM collections, SHOW requests, a highlighted new WHERE sort_order = 'best-sellers' line marked NEW, and SINCE -7d

sort_order_id on the Collections dataset returned an internal UUID that nothing else in Layers could name, so there was no way to filter by sort order or read which one a group of rows belonged to.

The new sort_order dimension speaks the same handle your sort order list already shows. Group by it to break down requests or revenue per sort order, or filter with WHERE sort_order = 'best-sellers'.

sort_order_id still works but is deprecated. Point your saved reports at sort_order instead.

Learn more

ImprovementAnalyticsLayersQLMerchandising Metrics