Include the total count in Optimizely Graph queries using the C# SDK

Retrieve the total count of matching items in Content Graph queries to support pagination and filtered results.

Call .IncludeTotal() to get the total number of items matching your query. Without it, result.Total is null.

Get the total count for a query

var result = await client
    .QueryContent<BlogPostPage>()
    .IncludeTotal()
    .GetAsContentAsync();

int total = result.Total!.Value;

Use the total count for pagination

Use the total count to calculate the number of pages:

int pageSize = 10;
int currentPage = 1;

var result = await client
    .QueryContent<BlogPostPage>()
    .Skip((currentPage - 1) * pageSize)
    .Limit(pageSize)
    .IncludeTotal()
    .GetAsContentAsync();

int totalPages = (int)Math.Ceiling((double)result.Total!.Value / pageSize);

Total reflects active filters

The count reflects the filtered result set, not the full collection:

var result = await client
    .QueryContent<BlogPostPage>()
    .Where(x => x.IsFeatured == true)
    .IncludeTotal()
    .GetAsContentAsync();

// Total is the count of featured posts only, not all blog posts
var featuredTotal = result.Total;

Total is consistent across pages

Fetch the total on page 1 and reuse it for all subsequent page navigation. It does not change between paginated calls for the same query:

// Page 1: capture total here
var page1 = await client
    .QueryContent<BlogPostPage>()
    .Skip(0)
    .Limit(10)
    .IncludeTotal()
    .GetAsContentAsync();

int total = page1.Total!.Value; // Use this for all page navigation

// Page 2: total is the same
var page2 = await client
    .QueryContent<BlogPostPage>()
    .Skip(10)
    .Limit(10)
    .IncludeTotal()
    .GetAsContentAsync();

For pagination patterns that use this total, see Paginate Optimizely Graph results using C# SDK.

Updated 6 days ago