All versions of this manual
X
Welcome to Linkurious user manual v4.1.11. Use the menu to access other documentations.
  1. Introduction
  2. Spaces
  3. First visualization
    1. At first glance
    2. Create a new visualization
    3. Inspect data
  4. Manage visualizations
    1. Open rename delete
    2. Moving visualizations
    3. Share
    4. Duplicate
  5. Queries
    1. Creating queries: query builder
    2. Creating queries: query editor
    3. Tagging queries
    4. Running and managing queries
  6. Custom actions
  7. Search
    1. Searching for nodes
    2. Searching for edges
    3. Advanced search
    4. Advanced syntax
  8. Manipulating the graph
    1. Auto-save
    2. Select nodes and edges
    3. Expand nodes
    4. Node Grouping
    5. Edge Grouping
    6. Lasso
    7. Hide
    8. Layouts
    9. Pinning nodes
    10. Undo/redo
    11. Shortcuts
    12. Publish
    13. Export
  9. Design
    1. Captions
    2. Nodes color
    3. Edges color
    4. Nodes size
    5. Edges size
    6. Icons
  10. Filters
    1. Filter panel
    2. Timeline
  11. Comments
    1. Comments panel
  12. Edit data
    1. Edit properties and categories
    2. Create nodes and edges
    3. Delete nodes and edges
  13. Geography
    1. Geographic data
    2. Display a geographic map
  14. Alerts
    1. Setting up alerts
    2. Alert creation example
    3. Alerts Navigation
    4. Investigating cases
    5. Lexicon
  15. Guest Mode
 

Queries: Creating queries: query builder

Creating queries using the No Code Query Builder

By eliminating the need for manual coding, the No Code Query Builder is a powerful tool that empowers all users to access the insights they need faster and more efficiently.

The No Code Query Builder

It allows you to create custom queries without writing a single line of code. Whether you're a seasoned data analyst or new to data exploration, the No Code Query Builder makes it easy to access and manipulate data with just a few clicks. Benefits of the No Code Query Builder

  • Code-Free Querying
    Build complex queries through an intuitive interface and without needing any technical expertise.
  • Real-Time Results
    Preview your query results instantly while refining your query.
  • Custom Filters and Conditions
    Apply advanced filtering to tailor your queries to your exact needs.

Accessing the No Code Query Builder

The No Code Query Builder is accessible from the visualization workspace. Accessing the No Code Query Builder Follow these steps to access it:

  1. Navigate to the Visualization Workspace
    From the main dashboard, open a new or existing visualization.
  2. Open the No Code Query Builder
    From the workspace of a new visualization, click on the No Code Query Builder button from the quick actions menu. Alternatively, from the workspace of an existing visualization the No Code Query Builder can be opened from the query right panel or from the quick actions menu found on the bottom right of the screen.
  3. Start Building your Query

Building your Query

Interface Overview

When you open the No-Code Query Builder, you will see the following interface, which includes the first node block of your query.

No Code Query Builder - user interface

Adding and Filtering Nodes

The first block represents a node, where you can filter by one, multiple, or all node categories.

Once node categories are selected, refine your query further by clicking "Add a condition" to filter by property values.

Available operators and values depend on the property type.

Adding Connections

To build more complex queries that return sub-graphs rather than isolated nodes:

  1. Click "+ Add a connection" to create relationships between nodes.

  2. This action generates:

    • An edge block, where you can filter by edge categories and their properties.
    • A new node block, functioning similarly to the first node block but filtered based on the selected edge categories.

  3. You can continue adding as many connections as needed while monitoring the estimated result count.

Example Queries

Example 1: (1 Block)

Find All Mortgage Loans in Miami with a Duration of 5+ Years

Filters:

  • Node category = MortgageLoan (city = Miami, duration >= 5 years)

Building query 1

Example 2: (3 Blocks)

Find People with Annual Revenues > 100k Controlling Companies with Annual Turnover > 1M

Filter:

  • Node category = PERSON (annual_revenues > 100,000)
  • Edge category = HAS_CONTROL
  • Node category = COMPANY (annual_turnover > 1,000,000)

Building query 2

Useful Tips

  • Query Results:
    On the bottom right of the No Code Query Builder screen, you can see an estimated number of results that your query will be returning.
  • Resetting one query block:
    You can reset the content of each block by clicking on Reset this block. Given that query blocks are inter-connected, make sure that your query is still correct when resetting blocks.
  • Resetting all query blocks:
    You can reset all the blocks of your query by clicking on Delete all criteria
  • Deleting query blocks:
    You can remove the last No Code Query Builder blocks by clicking on Remove connection.
  • Editing queries:
    Queries built with the No Code Query Builder, can be edited back on the No Code Query Builder.

Previewing Results

After creating your query, you can click on PREVIEW YOUR QUERY, where you can view the cypher code produced and by clicking on Preview Results you can view the graph elements which your query will be returning.

Saving Your Query

Once you have built, tested and perfected your query, you can save it for later use in the next step by selecting NEXT. When saving a query, the user is prompted for a Query title, a Description and Tags.

Query tags make queries easier to find after creation. When saving a query, you can add one or more existing tags to it and create new ones.

  • Created tags will be visible by any user who can create or edit queries.
  • All users who can edit a query can also add or remove tags for that query.
  • Query tags are saved on a datasource level. This means that each datasource will have different tags.
  • Query tags will be given a color automatically by Linkurious Enterprise.

Adding and creating tags when saving a query

Queries built with the No Code Query Builder are private and accessible only by their creator.

Accessing Saved Queries

Saved queries can be accessed from the right panel of the workspace. From there, you can run, edit and delete your queries. Learn more about it in here.