Details

    • Technical task
    • Resolution: Fixed
    • Major
    • None
    • None
    • None
    • DOC-2022-S24, DOC-2022-S25, DOC-2023-S1, DOC-2023-S2, DOC-2023-S3, DOC-2023-S4, DOC-2023-S5, DOC-2023-S6
    • 1

    Description

      N1QL in inline text:

      modules/concept-docs/pages/analytics-for-sdk-users.adoc::description: Parallel data management for complex queries over many records, using a familiar N1QL-like syntax.
      modules/concept-docs/pages/data-model.adoc:These data structures as implemented in other SDKs are stored as JSON documents in Couchbase, and can therefore be accessed using N1QL, Full Text Search, and normal key-value operations.
      modules/concept-docs/pages/documents.adoc:or xref:7.1@server:n1ql:n1ql-language-reference/update.adoc[N1QL UPDATE] to update documents based on specific query criteria:
      modules/concept-docs/pages/n1ql-query.adoc:For N1QL, the default consistency is `not_bounded`.
      modules/concept-docs/pages/n1ql-query.adoc:you obtain Type safety and auto completion of relevant methods and N1QL clauses. 
      modules/concept-docs/pages/n1ql-query.adoc:The difference is that it emits N1QL in place of SQL. 
      modules/concept-docs/pages/n1ql-query.adoc:Once you have included the dependency, you can construct queries just like any other LINQ provider in a SQL-like fashion. Nearly all N1QL statements and functions are supported, for example:
      modules/concept-docs/pages/n1ql-query.adoc:In addition to N1QL language features, Linq2Coucbase supports ORM features like Change-tracking, and mapping of JSON fields to keys and other POCO properties. 
      modules/hello-world/pages/sample-application.adoc:The https://github.com/couchbaselabs/try-cb-nodejs/blob/6.5/index.js[index.js] file also contains the functions for handling users, registration, and N1QL queries.
      modules/hello-world/pages/start-using-sdk.adoc:* How to xref:sql-lookup[lookup documents] with the {sqlpp_url}[{sqlpp} (formerly N1QL)] query language.
      modules/howtos/examples/transactions-example.php:      // removing and replacing documents, performing N1QL queries, etc.
      modules/howtos/examples/transactions-example.php:      // Performing a SELECT N1QL query:
      modules/howtos/examples/transactions-example.php:      // Performing an UPDATE N1QL query:
      modules/howtos/examples/transactions-example.php://         $bulkLoadStatement = "..."; // a bulk-loading N1QL statement not provided here
      modules/howtos/pages/analytics-using-sdk.adoc::description: Parallel data management for complex queries over many records, using a familiar N1QL-like syntax.
      modules/howtos/pages/distributed-acid-transactions-from-the-sdk.adoc:If you already use https://www.couchbase.com/products/n1ql[{sqlpp} (formerly N1QL)], then its use in transactions is very similar.
      modules/howtos/pages/error-handling.adoc:A N1QL query either returns results or `QueryError`, like so:
      modules/howtos/pages/kv-operations.adoc:Our xref:n1ql-queries-with-sdk.adoc[Query Engine] enables retrieval of information using the SQL-like syntax of N1QL.
      modules/howtos/pages/n1ql-queries-with-sdk.adoc::description: You can query for documents in Couchbase using the N1QL query language, a language based on SQL, but designed for structured and flexible JSON documents.
      modules/howtos/pages/n1ql-queries-with-sdk.adoc:Our query service uses N1QL, which will be fairly familiar to anyone who's used any dialect of SQL.
      modules/howtos/pages/n1ql-queries-with-sdk.adoc:xref:#additional_resources[Further resources] for learning about N1QL are listed at the bottom of the page.
      modules/howtos/pages/n1ql-queries-with-sdk.adoc:Before you get started you may wish to checkout the xref:7.1@server:n1ql:n1ql-language-reference/index.adoc[N1QL intro page], or just dive in with a query against our travel sample data set.
      modules/howtos/pages/n1ql-queries-with-sdk.adoc:* A N1QL query using the default *Not Bounded* Scan Consistency will not wait for any indexes to finish updating before running the query and returning results, meaning that results are returned quickly, but the query will not return any documents that are yet to be indexed.
      modules/howtos/pages/n1ql-queries-with-sdk.adoc:NOTE: N1QL is not the only query option in Couchbase.
      modules/howtos/pages/n1ql-queries-with-sdk.adoc:// For a deeper dive into N1QL from the SDK, refer to our xref:[N1QL SDK concept doc].
      modules/howtos/pages/n1ql-queries-with-sdk.adoc:The xref:7.1@server:n1ql:n1ql-language-reference/index.adoc[Server doc N1QL intro] introduces up a complete guide to the N1QL language, including all of the latest additions.
      modules/howtos/pages/n1ql-queries-with-sdk.adoc:The http://query.pub.couchbase.com/tutorial/#1[N1QL interactive tutorial] is a good introduction to the basics of N1QL use.
      modules/howtos/pages/slow-operations-logging.adoc:| *tracing_threshold_query*                | duration |     1.0 | Minimum time for the tracing span of N1QL service to be considered by threshold tracer.
      modules/howtos/pages/subdocument-operations.adoc:IMPORTANT: The sub-document operations described on this page are for _Key-Value_ requests only: they are not related to sub-document N1QL queries.
      modules/howtos/pages/subdocument-operations.adoc:(Sub-document N1QL queries are explained in the section xref:n1ql-queries-with-sdk.adoc[Querying with N1QL].)
      modules/howtos/pages/subdocument-operations.adoc:The _path_ follows N1QL syntax xref:#[below^], and xref:7.1@server:n1ql:n1ql-intro/queriesandresults.adoc[N1QL Queries and Results]).
      modules/howtos/pages/subdocument-operations.adoc:Path syntax largely follows N1QL conventions: A path is divided into components, with each component referencing a specific _level_ in a document hierarchy.
      modules/howtos/pages/subdocument-operations.adoc:a dot or brackets) it may be escaped using N1QL escapes.
      modules/project-docs/pages/compatibility.adoc:| Scope-Level N1QL Queries & all Collections features
      modules/project-docs/pages/migrating-sdk-code-to-3.n.adoc:Compare this to a N1QL query:
      modules/project-docs/pages/migrating-sdk-code-to-3.n.adoc:And, creating a N1QL index now lives in the `QueryIndexManager`, which is accessible through the `Cluster`.
      modules/howtos/pages/n1ql-queries-with-sdk.adoc:// SQL++ / Analytics.

      Use this command to update [source,n1ql] to [source,sqlpp]:
      Note, this is for Mac, you may need to change the command slightly on other systems.

       git grep -l "source,n1ql" | xargs sed -i '' -e 's/source,n1ql/source,sqlpp/g'

      Attachments

        No reviews matched the request. Check your Options in the drop-down menu of this sections header.

        Activity

          People

            tom.rosewell Tom Rosewell (Inactive)
            maria.shodunke Maria Shodunke (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Gerrit Reviews

                There are no open Gerrit changes

                PagerDuty