Other Data Tools

    +

    Document Viewer

    Another simple and fast way to find and look at documents is by selecting Tools  Documents.

    19

    Here are a few things you can do with the document viewer:

    Change your buckets, scopes, and collections to see documents segmented in those ways
    1. Set bucket to travel-sample, scope to inventory, and collection to hotel.

      The documents list will automatically refresh to show only those documents within the selected collection.

    View document information and content
    1. Click on a document name in the ID column

      This opens the Document flyout where you can view and edit the contents of documents directly. At the top, it shows you the document hierarchy.

    2. Click the "X" to close the flyout.

    Change default list limit
    1. Use the Limit drop-down menu to change the default document list limit from 5 to 20.

      The documents list will automatically refresh to show more documents.

    Change the offset to skip the first X documents
    1. Inside the Offset field enter 20.

    2. Press Enter or click Retrieve Docs.

      The documents list will update to reflect the new offset.

    Search documents by Document ID
    1. In the Document ID field, paste hotel_21725

    2. Press Enter or click Retrieve Docs.

      This will pull up a hotel in Paris near the Louvre Metro.

    3. Clear the previous settings by clicking the Clear (X) button.

    Use N1QL Where
    1. In the N1QL Where field, paste the following: city='Half Moon Bay'

      This will bring up the hotel located in this California town.

    A more detailed introduction to working with data can be found on our Interacting with Data intro page.

    Sample Indexes

    Now let’s look at the cluster indexes. Click Tools  Indexes.

    In Couchbase, primary and global secondary indexes -- also known as just indexes  — are predefined subsets of bucket data created by the Index Service.

    The sample buckets automatically created indexes upon import.

    20

    If you select an index, it will open a flyout with more details about that index. Here you can see the number of items covered by that index and how it is performing.

    21

    For more information about viewing and interacting with indexes, refer to Index Service.

    Couchbase Capella Full Text Search (FTS) lets you create, manage, and query specially purposed indexes, defined on JSON documents within a Couchbase bucket.

    The Full Text Search editor is available under each cluster’s Tools  Full Text Search tab. To do a search, we must first create an index.

    1. Click Add Index.

      The Add Index flyout appears.

    2. Type the name hotel-description, choose the "travel-sample" bucket and click Continue to configuration.

    3. In the Index Settings section, click Add Mapping.

    4. For the Name, type hotel, and click Create Mapping.

    5. For your newly created type mapping, click the ellipsis (⋮) for a submenu, and click Insert Child Field.

    6. For the Field, type description, and tick all the boxes at the bottom.

    7. Now click Create Child Field.

    8. For the last step of the add index process, scroll to the bottom and click Create Index.

      Your new Index should now appear.

    9. Click on the name of your new index and press the Search button.

      A Search flyout appears.

    10. Now on the search bar enter description:free wifi then click the Search button.

      All hotel documents with matching terms are listed with the execution time also displayed. Try experimenting with other search terms.

    11. Click the "X" in the upper right to close the Search flyout screen.

    Learn more about Couchbase Capella Full Text Search here.

    Now that you have finished your whirlwind tour of Couchbase Capella, use this documentation set to dig into the features more deeply.