Query documents

This topic explains how to query instances of documents. The examples below show you how to query all of the available documents or how to query only a specific document by its ID.

NOTE: The code examples below work with the ID of the master version of the document and return the live version of the document. For more information about other scenarios, see For developers: Query master and live versions

Query a single document

When querying the live version of a specific document by the ID of its master version, you must perform the following:

  1. Get the master version.
    First, get an instance of the master version with the corresponding ID.
  2. Get the live version.
    The instance that corresponds to the ID argument is the master version of the document. You must get the live version explicitly. 

    NOTE: The live version is used only when displaying the document in a front-end scenario. If you want to manipulate the document, consider using the master version. To transfer the changes to the live version, publish the master version.

  3. Return the live version.

The following code sample queries a document by its title:

The following code samples query the live version of a document by the ID of its master version. To get the ID of the document, use the following code samples:

Native API

First, you get an instance of the LibrariesManager class. You get the specified document by querying all documents and filtering the collection by the Id property of the document. If the document exists, you get its live version. If no live version exists (i.e. the item has not been published), you return null. Finally, you return the live version.

You can also use the following code to retrieve the document:

NOTE: When the document does not exist, an exception of type ItemNotFoundException is thrown.

Fluent API

First, you get the singular document facade of the master version with the specified ID. Then, to load the live version of the document, you call the GetLive method of the facade. Finally, to get the instance of the live version, you call the Get method.

Query documents by a document library

To query documents by a document library, you must perform the following:

  1. Get the libraries manager.
    Get an instance of the LibrariesManager object.
  2. Get the document library.
    Get an instance of the specified document library. For more information, see For developers: Query document libraries.
  3. Get the documents.
    Get the documents by calling the Documents extension method of the DocumentLibrary instance. This extension method is located in the Telerik.Sitefinity.Modules.Libraries namespace.

NOTE: Another way of getting the documents from a specific library, is to query all the documents and filter the collection by the ID of the document library. You can find an example of this approach in the next section.

Use the following code samples:

Native API

Fluent API

Query all documents

When querying all documents, you must perform the following:

  1. Query all documents.
    First, get a query of all available documents. The query includes all live, master and temp versions.
  2. Filter the query.
    Filter the query to return only the live versions.
  3. Get the documents.
    Get the filtered documents in a list.
  4. Return the list of documents.

NOTE: You can filter the query to get a specific set of documents. For example, you can get the documents from a specific library.

The following code queries all published documents.

In this code example you additionally filter the collection by the ID of the parent document library.

NOTE: You can filter the query to get a specific set of documents. For example, you can get the documents from a specific library:

In this code example you use the plural facade for the documents and filter them by the ID of the specified document library. Then, you get the live versions of the selected documents.

Increase your Sitefinity skills by signing up for our free trainings. Get Sitefinity-certified at Progress Education Community to boost your credentials.

Web Security for Sitefinity Administrators

The free standalone Web Security lesson teaches administrators how to protect your websites and Sitefinity instance from external threats. Learn to configure HTTPS, SSL, allow lists for trusted sites, and cookie security, among others.

Foundations of Sitefinity ASP.NET Core Development

The free on-demand video course teaches developers how to use Sitefinity .NET Core and leverage its decoupled architecture and new way of coding against the platform.

Was this article helpful?

Next article

Modify documents