Sorting & Limiting

Control the order and number of results returned.

Sorting

Single Criterion

// Descending order
const latest = await cms.from('posts').orderBy('publishedAt', 'desc').get();

// Ascending order
const oldest = await cms.from('posts').orderBy('publishedAt', 'asc').get();

Multiple Criteria (Tiebreakers)

const prioritized = await cms
  .from('posts')
  .orderBy('priority', 'desc') // Primary sort
  .orderBy('publishedAt', 'desc') // Tiebreaker
  .get();

Nested Field Sorting

const topRated = await cms
  .from('products')
  .orderBy('ratings.average', 'desc')
  .get();

Limiting

Limit Results

const featured = await cms.from('posts').where('featured', true).limit(5).get();

Combine with Filters

const topPosts = await cms
  .from('posts')
  .where('metadata.status', '==', 'published')
  .orderBy('stats.views', 'desc')
  .limit(10)
  .get();

Complete Example

// Top 5 published posts by views
const trending = await cms
  .from('posts')
  .where('metadata.status', '==', 'published')
  .where('metadata.featured', true)
  .orderBy('stats.views', 'desc')
  .orderBy('metadata.publishedAt', 'desc')
  .limit(5)
  .get();

Next Steps

Continue Learning

• Nested Fields - Deep access
• Media - Images and videos
• Framework Integration - Use in apps