Skip to Navigation
Main navigation
NoSQL Database
  • Download
  • Cloud
    LoginCreate Account
  • Try
    Coding demoSample step-by-step coding walkthroughPlayground StudioTry our GUILive DemoRequest a customized demo presentation
  • Why RavenDB
    What’s newAcid Database TransactionsHigh performanceAdvanced query engineManagement StudioMulti-Model ArchitectureMulti-PlatformHigh availabilityEase of useDesigned with careFree LicenseIntegration with relational databases
  • Features
    ClientsQueryingIndexesExtensionsClustersReplicationSecurityMonitoringAdministrationMigration
  • Learn
    RavenDB DocumentationRavenDB Cloud DocumentationDocumentation GuideRavenDB DemoInside RavenDB BookWebinarsWorkshopsVideosRavenDB BootcampPluralsight
  • Pricing
    On-Premise PricingCloud Pricing
  • News
    ArticlesEventsMediaUse CasesIndustry ReportsWhitepapersPodcastsPress Releases
  • About
    About UsRoadmapTerms Of UsePrivacy Policy
  • Contact
  • Start
    • Getting started
    • What's new
    • Playground Server
    • About examples
      • Basics
      • Filtering
      • Paging
      • Sorting
      • Handling document relationships
      • Projections
      • Searching
      • Intersection
      • Suggestions
      • Highlights
      • Spatial
      • Faceted search
      • Dynamic aggregation
      • Query vs DocumentQuery
      • New Lucene Query Parser
      • Full query syntax
    • What are indexes?
    • Creating and deploying indexes
    • Indexing basics
    • Map indexes
    • Multi-Map indexes
    • Map-Reduce indexes
    • Stale indexes
    • Fanout indexes
    • Customizing results order
    • Indexing related documents
    • Indexing hierarchical data
    • Indexing polymorphic data
    • Indexing spatial data
    • Indexing LINQ extensions
    • Converting to JSON and accessing Metadata
    • Boosting
    • Analyzers
    • Storing data in index
    • Term Vectors
    • Dynamic Fields
    • Testing indexes
    • Side-by-Side indexes
      • Debugging index errors
    • What are transformers?
    • Creating and deploying transformers
    • Basic transformations
    • Loading documents
    • Including documents
    • Passing parameters
    • Nesting transformers
    • Transforming hierarchical data
    • Converting to JSON and accessing Metadata
    • Dealing with subcollections
    • What is a document store?
    • Creating document store
    • Setting up default database
    • Setting up connection string
    • What is a public API?
    • .NET Client versions
      • What are commands?
        • Put
        • Get
        • Delete
        • Stream
          • ...get document metadata only
          • ...delete/update documents using index
        • Put
        • Get
        • Delete
          • ...reset index
          • ...get index terms
          • ...get index merge suggestions
          • ...check if index has changed
          • ...change index lock mode
          • ...change index priority
        • Put
        • Get
        • Delete
          • ...get attachment metadata only
          • ...update attachment metadata only
        • How to query a database?
        • How to stream query results?
        • How to work with Facet query?
        • How to work with Suggestion query?
        • How to work with MoreLikeThis query?
        • Put
        • Get
        • Delete
          • ...transform query results
          • ...change transformer lock mode
        • How to send multiple commands using a batch?
        • How to work with patch requests
        • How to use JavaScript to patch your documents
        • ...switch commands to a different database
        • ...switch commands credentials
        • ...disable caching
        • ...start or stop indexing and get indexing status
        • ...start or stop reducing
        • ...create or delete database
        • ...compact database
        • ...get database and server statistics
        • ...get database configuration
        • ...start backup or restore operations
        • ...get full url for a document
        • ...get server build number
        • ...get names of all databases on a server
        • ...get the primary database Url
        • ...How to retrieve user info
        • ...How to retrieve user permission for a specified database
      • What is a session and how does it work?
      • Opening a session
      • Storing entities
      • Deleting entities
      • Loading entities
      • Saving changes
          • How to use Lucene in queries?
          • How to use NOT operator?
        • How to query?
        • How to stream query results?
        • How to customize query?
        • How to use transformers in queries?
        • How to perform a faceted search?
        • How to perform a multifaceted search?
        • How to query a spatial index?
        • How to perform dynamic aggregation?
        • How to get query statistics?
        • How to perform projection?
        • How to use intersect?
        • How to perform queries lazily?
        • How to work with suggestions?
        • How to use search?
        • How to use highlighting?
        • Standard transactions
        • DTC transactions
        • How to change maximum number of requests per session?
        • How to customize key generation for entities?
        • How to customize collection assignment for entities?
        • How to customize identity property lookup for entities?
        • How to enable optimistic concurrency?
        • ...defer operations
        • ...perform operations lazily
        • ...clear a session
        • ...evict entity from a session
        • ...refresh entity
        • ...get entity id
        • ...get entity metadata
        • ...get entity etag
        • ...get entity url
        • ...check if entity has changed
        • ...check if there are any changes on a session
        • ...mark entity as readonly
        • ...use MoreLikeThis?
        • ...delete-documents-using-index-with-linq
      • Working with document ids
      • HiLo algorithm
      • Beware of ...
      • Handling case sensitive document IDs
      • How to work with bulk insert operation?
      • What is Changes API?
      • How to subscribe to document changes?
      • How to subscribe to index changes?
      • How to subscribe to bulk insert operation changes?
      • How to subscribe to transformer changes?
      • How to subscribe to replication conflicts?
      • How to subscribe to data subscription changes?
      • What are listeners?
      • Store listeners
      • Delete listeners
      • Conversion listeners
      • Conflict listeners
      • Query listeners
      • What are data subscriptions?
      • How to create a data subscription?
      • How to open a data subscription?
      • How to delete a data subscription?
      • How to release a data subscription?
      • How to get all subscriptions?
      • Events
      • How client integrates with replication bundle?
      • How to work with authorization bundle?
      • How to work with unique constraints bundle?
      • Revisions and concurrency with ETags
      • Using optimistic concurrency in real world scenarios
        • What are conventions?
          • Global
          • Type-specific
        • Querying
        • Caching
        • Replication
        • Request handling
        • Misc
      • ...work with authentication
      • ...setup aggressive caching
      • ...send custom request
      • ...integrate with Excel
      • ...enable profiling
      • ...store dates
      • ...create a custom message handler
      • What is a collection?
      • Transaction support
      • Backward compatibility
      • System requirements
      • Windows Service
      • IIS application
      • Deployment considerations
      • Embedded
      • Using installer
      • Upgrading to a new version
        • Windows Server 2008
        • Windows Server 2012
      • Enabling SSL
      • Enabling FIPS compliant encryption
      • Authentication & Authorization
      • License registration
      • Hot Spare License
      • Configuration options
      • Storage Engines
      • Administration 101
      • Multiple databases
      • Statistics
      • Backup & Restore
      • Exporting & Importing data
      • Differences between backup and export
      • Migrating attachments into RavenFS
      • Index administration
        • Pandora FMS
        • Request Tracking
        • Disk IO Performance Monitor
          • What is SNMP?
          • Zabbix
        • How replication works?
        • Replication conflicts
        • Replication and Embedded instance
        • Write assurance
        • Overview
        • Rachis
        • How to setup sharding?
        • Sharding Ops
      • Replication with Sharding
      • ETL (Extract Transform Load)
      • SLA (Service Level Agreement)
      • Authorization
      • Cascade Delete
      • Compression
      • Encryption
      • Expiration
      • More Like This
      • Periodic Export
      • Quotas
      • Replication
      • Scripted Index Results
        • Basics
        • PostgreSQL
      • Unique Constraints
      • Versioning
      • What are plugins?
      • Triggers
      • Codecs
      • Tasks
      • Compilation Extensions
      • Analyzer Generators
      • Database Configuration
      • Debug endpoints
      • Enabling logging
      • Running in debug mode
      • Sending support ticket
      • Document key generation
      • Bundles : Authorization bundle design notes
      • Replication : Advanced replication details
      • Server : Long shutdown times
      • Raven Thread Pool (RTP)
    • Accessing Studio
        • Documents View
        • Document Edit View
        • Patch View
        • Conflicts View
        • Indexes View
        • Index Edit View
        • Transformers View
        • Transformer Edit View
        • Query View
        • Reporting View
        • Data Exploration View
        • Import & Export Database
        • Toggle Indexing
        • Subscriptions
        • Create Sample Data
        • CSV Import
        • Database Settings
        • Quotas
        • Replication
        • ETL
        • SQL Replication
        • Versioning
        • Periodic Export
        • Custom Functions
        • Stats
          • Indexing performance
          • Index stats
          • Index batch size and Prefetches
        • Request Tracking
        • Logs
        • Running Tasks
        • Alerts
        • Index Errors
        • Replication Stats
        • Sql Replication Stats
        • User Info
        • Map-Reduce Visualizer
          • Overview
          • Explain replication
          • Data subscription
          • Queries
        • Storage
        • Gather Debug Info
      • API Keys
      • Windows Authentication
      • Server Permissions
      • Cluster
      • Global Configuration
      • Server Smuggling
      • Backup & Restore
      • Compact
      • Admin Logs
      • Server Topology
      • Traffic Watch
      • License information
      • Hot Spare
      • Gather Debug Info
      • IO Test
      • Disk IO Viewer
      • Administrator JS Console
      • Studio Config
      • How to setup replication?
      • How to setup encryption?
      • How to setup compression?
    • MVC Starter Kit
    • AdminStatistics
    • AttachmentInformation
    • Attachment
    • BatchResult
    • BulkOperationOptions
    • BulkInsertChangeNotification
    • BulkInsertOperation
    • BulkInsertOptions
    • ChunkedBulkOperationOptions
    • ConfigurationChangeNotification
    • ConfigurationSearchResults
    • ConflictItem
    • ConflictNotification
    • DataSubscriptionChangeNotification
    • DatabaseDocument
    • DatabaseRestoreRequest
    • DatabaseStatistics
    • DeleteCommandData
    • DocumentChangeNotification
    • DynamicAggregationQuery
    • Facet
    • FacetQuery
    • FacetResults
    • FacetSetup
    • FieldHighlightings
    • FileChangeNotification
    • FileHeader
    • FileSystemBackupRequest
    • FileSystemDocument
    • FileSystemRestoreRequest
    • FilesQueryStatistics
    • IndexChangeNotification
    • IndexDefinition
    • IndexMergeResults
    • IndexQuery
    • IndexToAdd
    • JsonDocumentMetadata
    • JsonDocument
    • MoreLikeThisQuery
    • MultiLoadResult
    • OpenSessionOptions
    • Operation
    • PatchCommandData
    • PutCommandData
    • QueryHeaderInformation
    • QueryResult
    • RavenQueryStatistics
    • ReplicationConflictNotification
    • ReplicationDestination
    • ScriptedPatchCommandData
    • SearchResults
    • SpatialCriteriaFactory
    • SpatialRelation
    • StreamResult
    • SuggestionQuery
    • SuggestionQueryResult
    • SynchronizationDestination
    • SynchronizationDetails
    • SynchronizationReport
    • SynchronizationUpdateNotification
    • TransformerChangeNotification
    • TransformerDefinition
    • UserInfo
    • UserInfo
    • What is RavenFS?
    • Files
    • Configurations
    • Indexing
      • What is a files store?
      • Creating a files store
        • What are commands?
          • Upload
          • Download
          • Rename
          • Delete
            • GetMetadata
            • UpdateMetadata
            • Browse
            • Get
            • StartsWith
            • StreamFileHeaders
            • GetDirectories
            • StreamQuery
            • Search
            • SearchOnDirectory
            • GetSearchFields
          • Copy
          • SetKey
          • GetKey
          • DeleteKey
          • GetKeyNames
          • Search
          • Start
            • GetDestinations
            • SetDestinations
            • GetSynchronizationStatusFor
            • GetFinished
            • GetActive
            • GetPending
            • GetConflicts
            • ResolveConflict
          • CleanUp
          • RetryRenaming
          • RetryCopying
          • Manage file systems
          • Backup and restore
          • Compaction
          • Index reset
          • Statistics
        • What is a file session?
        • Opening a session
        • Loading files
        • Uploading files
        • Downloading files
        • Renaming files
        • Deleting files
        • Changing metadata
        • Saving changes
          • Basics
          • Filtering
          • Sorting
          • Paging
          • Statistics
          • Streaming
          • How to change maximum number of requests per session?
          • How to enable optimistic concurrency?
        • StreamFileHeaders
        • How to subscribe to file changes?
        • How to subscribe to synchronization notifications?
        • How to subscribe to synchronization conflicts?
        • How to subscribe to configuration changes?
        • What are listeners?
        • Delete listeners
        • Metadata change listeners
        • Conflict listeners
      • Sharding
      • How synchronization works?
      • Synchronization types
      • Conflicts
      • Configurations
      • Enabling Remote Differential Compression
      • Background tasks
      • Exporting and importing files
        • Encryption
        • Versioning
        • Files view
        • File edit view
      • Search view
        • Conflicts view
        • Destinations view
        • Configuration view
        • Export and import
      • Configurations view
        • How to setup encryption?
        • How to setup versioning?
      • Status View
        • Versioning
    • Azure Router Timeout
    • TCP Offloading
    • Recovering from Esent errors
    • Understanding eventual consistency
  • Current
  • RavenDB 5.3
  • RavenDB 5.2
  • RavenDB 4.2
  • Legacy
  • RavenDB 5.1
  • RavenDB 5.0
  • RavenDB 4.1
  • RavenDB 4.0
  • RavenDB 3.5
  • RavenDB 3.0
  • RavenDB 2.5
  • RavenDB 2.0
  • RavenDB 1.0
  • C#
  • Java
  • HTTP
  • Python
    You are currently browsing legacy 3.5 version of documentation. Click here to switch to the newest 5.3 version.
    We can help you with migration to the latest RavenDB
    Contact Us Now

    Querying


    • Lucene
    • How to query?
    • How to stream query results?
    • How to customize query?
    • How to use transformers in queries?
    • How to perform a faceted search?
    • How to perform a multifaceted search?
    • How to query a spatial index?
    • How to perform dynamic aggregation?
    • How to get query statistics?
    • How to perform projection?
    • How to use intersect?
    • How to perform queries lazily?
    • How to work with suggestions?
    • How to use search?
    • How to use highlighting?
    Home / Docs / Client Api / Session / Querying
    RavenDB NoSQL Database Solutions All Rights Reserved, 2022
    • Icon Youtube
    • Icon Instagram
    Contact Us
    info@ravendb.net 9 Ahad Ha'Am St. Hadera 3820349 Israel
    Quick Links
    • Hibernating Rhinos
    • NoSQL Database
    Keep Me Posted

    • NoSQL Database
    • Download
    • RavenDB Cloud
    • Demo
    • Playground Studio
    • Promotional Materials
    • About
    • Our Core Values
    • Meet the Team
    • Roadmap
    • Partners and Resellers
    • Terms of Use
    • Privacy Policy
    • Why RavenDB
    • What’s new
    • ACID Database Transactions
    • High Performance
    • Advanced Query Engine
    • Management Studio
    • Multi-Model Architecture
    • Multi-Platform
    • High Availability
    • Ease of Use
    • Designed with Care
    • Free License
    • Integration with Relational Databases
    • Features
    • Clients
    • Querying
    • Indexes
    • Extensions
    • Clusters
    • Replication
    • Security
    • Monitoring
    • Administration
    • Migration
    • Learn
    • Documentation
    • RavenDB Bootcamp
    • Videos
    • Webinars
    • Documentation Guide
    • Inside RavenDB Book
    • Community Forum
    • News
    • Articles
    • Events
    • Media
    • Use Cases
    • Industry Reports
    • Whitepapers
    • Podcasts
    • Press Releases
    • Pricing
    • Product
    • Support
    • Contact
    • Contact Us
    • Service Status
    • Request Support
    • Request Live Demo
    • Need help with a Proof of Concept?
    Proudly Developed by Hibernating Rhinos
    RavenDB NoSQL Database
    • Download
    • Cloud
      • Login
      • Create Account
    • Try
      • Coding demoSample step-by-step coding walkthrough
      • Playground StudioTry our GUI
      • Live DemoRequest a customized demo presentation
    • Why RavenDB
      • What’s new
      • Acid Database Transactions
      • High performance
      • Advanced query engine
      • Management Studio
      • Multi-Model Architecture
      • Multi-Platform
      • High availability
      • Ease of use
      • Designed with care
      • Free License
      • Integration with relational databases
    • Features
      • Clients
      • Querying
      • Indexes
      • Extensions
      • Clusters
      • Replication
      • Security
      • Monitoring
      • Administration
      • Migration
    • Learn
      • RavenDB Documentation
      • RavenDB Cloud Documentation
      • Documentation Guide
      • RavenDB Demo
      • Inside RavenDB Book
      • Webinars
      • Workshops
      • Videos
      • RavenDB Bootcamp
      • Pluralsight
    • Pricing
      • On-Premise Pricing
      • Cloud Pricing
    • News
      • Articles
      • Events
      • Media
      • Use Cases
      • Industry Reports
      • Whitepapers
      • Podcasts
      • Press Releases
    • About
      • About Us
      • Roadmap
      • Terms Of Use
      • Privacy Policy
    • Contact
    Icon chevron up

    Privacy Settings

    Dear User,

    By browsing on this website you are agreeing to our ‘Terms & Conditions’ and the ‘Privacy Policy’ in regards to your rights and personal data handling.

    Advanced Settings