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/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:= Querying with N1QL
      modules/concept-docs/pages/n1ql-query.adoc::nav-title: Querying with N1QL
      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/devguide/examples/c/bincoding/README.md:queries (N1QL, FTS etc).
      modules/devguide/examples/c/query-create-index.cc:query_callback(__unused lcb_INSTANCE *instance, __unused int cbtype, const lcb_RESPN1QL *resp)
      modules/devguide/examples/c/query-create-index.cc:        fprintf(stderr, "N1QL query failed (%s)\n", lcb_strerror(NULL, resp->rc));
      modules/devguide/examples/c/query-create-index.cc:    lcb_N1QLPARAMS *params = lcb_n1p_new();
      modules/devguide/examples/c/query-create-index.cc:    lcb_CMDN1QL cmd;
      modules/devguide/examples/c/query-create-index.cc:        die("Couldn't schedule N1QL query command", rc);
      modules/hello-world/pages/cbc.adoc:You can also use the xref:7.1@server:tools:query-workbench.adoc[Query Workbench] to issue N1QL queries using the web console.
      modules/hello-world/pages/sample-application.adoc:Other files contain the functions for handling users, registration, and N1QL queries.
      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/analytics-using-sdk.adoc:To learn more about using N1QL for Analytics -- the first commercial implementation of SQL\++ -- see our https://sqlplusplus-tutorial.couchbase.com/tutorial/#1[Tutorial Introduction to SQL++ for SQL users].
      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:= N1QL Queries from the SDK
      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::navtitle: N1QL from the SDK
      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:{cb_server_version}@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:After familiarizing yourself with the basics on how the N1QL query language works and how to query it from the UI you can use it from the Go SDK.
      modules/howtos/pages/n1ql-queries-with-sdk.adoc:NOTE: When using a Couchbase version < 6.5 you must create a valid Bucket connection using `cluster.Bucket(name)` before you can use N1QL.
      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:{cb_server_version}@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/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:concept-docs:n1ql-query.adoc[Querying with N1QL].)
      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/sdk-release-notes.adoc:  Expose setting for N1QL grace period.
      modules/project-docs/pages/sdk-release-notes.adoc:  The example below will add extra 100ms to each N1QL query:
      modules/project-docs/pages/sdk-release-notes.adoc:Renamed "N1QL" to "QUERY" in the APIs.
      modules/ref/pages/client-settings.adoc:Mutation tokens allow enhanced durability requirements as well as advanced N1QL querying capabilities.  Set this to
      modules/ref/pages/client-settings.adoc:The Query timeout is used on all N1QL query operations if not overridden by a custom timeout.
      modules/howtos/pages/analytics-using-sdk.adoc:To learn more about using N1QL for Analytics -- the first commercial implementation of SQL\++ -- see our https://sqlplusplus-tutorial.couchbase.com/tutorial/#1[Tutorial Introduction to SQL++ for SQL users].
      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