Database Query

This tool allows you to query single, aggregated, or multiple SQL and Solr databases. Using the UI controls, set your query parameters and click Run. To filter results, enter a predicate and click Filter.

../../_images/query-tool-basic.png

In the All Types drop-down, specify the content type that you would like to query. In the example above, running the query against the Author content type shows the stored records.

In the controls on the right, choose the database to query and the sort order of results. If there are specific fields that you want to see in the results, enter a comma-separated list in the text box. The example above specifies the twitterHandle and the lastName fields for Author.

In the ID or Predicate text box, you can provide a specific object ID or enter predicate values using standard operators.

Example Syntax:

title matches "This is the"
title ^= "This"
title = "This is the Title"

Also, you can query relationships using the field/subfield path notation. In the following example, the query searches for Article objects referencing an Image with a caption field set to “This is the caption”.

image/caption matches "This is the caption"

In the Results pane, click a result to view object details in JSON format. You can edit an object using the Edit Raw or Edit Fielded tabs.

../../_images/query-tool-fielded.png