Visual Query Builder Process

Queries are built using entity types joined by relationship types, and can be qualified with properties, operators, and values.
Note: If the Data Hub Visualization tool returns an error message while you are building or running a query and you are not sure which part of the query caused the error, hover over the error message and notice which element in the query becomes selected.
Follow these steps to create a simple query using the Visual Query Builder.
  1. Drag an entity type onto the canvas.
  2. Drag another entity type onto the canvas.
  3. Be sure neither entity type is selected, and drag from one to the other. The Relationships options will appear.
    Note: If the two entity types you dragged onto the canvas do not have a relationship in the model, the Relationship options will not appear.
  4. Select whether you want to see Incoming relationships, Outgoing relationships, or Both, and then select which relationship you want the results to reflect. Press OK. The relationship you selected will appear as a label for the relationship.
  5. Run the query. Numeric results will appear in the top-right corner of the Visual Query Builder screen:

  6. Click the Canvas tab. Visual results of the query will appear.
Let's make the query a little more complex.
  1. Return to the Visual Query Builder.
  2. Click one of the entity types in the query and Select a property for that type, followed by an operand, and then enter a value.
    Note: Notice that a green check now appears above the entity type; this denotes that a property has been tied to the entity type in the query.
  3. Select Include in results if you want the results that are returned from the query to include entities of this type. You can use this option for multiple types of entities. If you want the results to include this entity type but no other entity types, check Return this type only.
    Note: Notice that a green plus sign appears next to all entity types that are included in the results.
  4. Run the query.

Now let's add a Relationship count, which sets search criteria for how many of a particular entity to look for with a certain relationship. For example, if you are looking at data for several events within a year, you might use this feature to search for a relationship of "Attended" with a relationship count set to "Minimum of" 100 for an entity of "Person." This would return only events that were attended by 100 people or more.

  1. Return to the Visual Query Builder.
  2. Click the relationship between the two entity types and in the Relationship count field select Minimum of, followed by a value, and then select the entity type to which you want to apply the count.
  3. Run the query.