Query Editor User Interface

Learn about the Query Editor user interface in Graph Explorer.

The following figure shows the Query Editor user interface in Graph Explorer:

Figure: Query Editor User Interface in Graph Explorer

Description of the illustration graph_explorer_ui.png

1. Tree view: Displays all the available property graphs (to which you have access), grouped by type:

   • SQL Property Graphs (supported only in Oracle AI Database 26ai)

   • PGQL Property Graphs

   • Graph Server

   Within each type, the graphs are grouped by database schema. Expand a graph to view its labels and expand a label to view its properties.

   Right-click on a specific graph to open a context menu.

   The following options are supported for SQL property graphs:

   • Open visual query builder: Opens Visual Graph Query Builder where you can visually construct the MATCH path pattern for your SQL property graph query.

     See Visual Graph Query Builder for more information.

   • Generate basic query: Generates a basic query for the selected SQL property graph.

   • Copy graph name: Copies the name of the selected SQL property graph.

   • Schema visualization: Opens the schema visualization for the selected SQL property graph.

     See Visualizing the Schema of a SQL Property Graph in Graph Explorer for more information.

   • Load graph into memory: Loads the selected SQL property graph into graph server (PGX) memory.

     See Loading or Unloading a Database Property Graph Into or From the Graph Server (PGX) Memory for more information.

   • Edit graph: Opens the graph for visual editing in Modeler.

     See Creating a Property Graph Using the Visual Editor for more information.

   • Rename graph: Opens the Rename graph slider where you can rename your graph.

   • Delete graph: Opens the Confirm graph deletion slider where you can confirm to delete your graph.

   The following options are supported for PGQL property graphs:

   • Generate basic query: Generates a basic query for the selected PGQL property graph.

   • Copy graph name: Copies the name of the selected PGQL property graph.

   • Schema visualization: Opens the schema visualization for the selected PGQL property graph.

     See Visualizing the Schema of a PGQL Property Graph in Graph Explorer for more information.

   • Migrate to SQL graph: Migrates the selected PGQL property graph to a SQL property graph.

     See Migrating PGQL Property Graphs to SQL Property Graphs for more information.

   • Load graph into memory: Loads the selected PGQL property graph into graph server (PGX) memory.

     See Loading or Unloading a Database Property Graph Into or From the Graph Server (PGX) Memory for more information.

   • Edit graph: Opens the graph for visual editing in Modeler.

   • Rename graph: Opens the Rename graph slider where you can rename your graph.

   • Delete graph: Opens the Confirm graph deletion slider where you can confirm to delete your graph.

   The following actions are supported for graphs loaded into the graph server (PGX) memory:

   • Generate basic query: Generates a basic query for the selected property graph.

   • Copy graph name: Copies the name of the selected property graph.

   • Schema visualization: Opens the schema visualization for the selected property graph.

   • Unload graph from memory: Unloads the selected property graph from graph server (PGX) memory.

     See Loading or Unloading a Database Property Graph Into or From the Graph Server (PGX) Memory for more information.

2. Graph list actions:

   • Search by graph: Use the search box to filter the list of available graphs in the tree view.
   • Refresh data: Refresh the displayed graphs in the tree view.
   • Sort graphs: Sorts the graph list by name in ascending or descending order.

3. Query Editing panel: Enter SQL graph queries, SQL statements, or PGQL graph queries.

   If you used Generate Basic Query, you can edit the generated query or replace it with your own.

4. Query actions: An action panel at the top of the query editor to:

   • Driver selector: Select the driver for the query you are running.

     • SQL: Select to run SQL graph queries on SQL property graphs or to execute any SQL statements.

     • PGQL: Select to run PGQL queries on PGQL property graphs.

     • Graph Server: Select to run PGQL queries on graphs loaded into the graph server (PGX).

   • Visualize Graph: Click to run the latest query in the query editor and visualize the results.

   • Run Statement: Click to run the latest query and view the output in tabular format.

   • Cancel: Click to cancel an in-progress visualization query or a table-only query.

   • ...: Click Reset to defaults in the actions menu to reset Graph Explorer data stored in the current browser to default values.

5. Query result tabs: Displays the output in one of the following tabs:

   • Schema Visualization: Visualization of the underlying database schema for a property graph. See Visualizing the Schema of a SQL Property Graph in Graph Explorer and Visualizing the Schema of a PGQL Property Graph in Graph Explorer for more information.

   • Query Visualization: Graph visualization for:

     • SQL property graphs: See Example: Visualizing a SQL Property Graph Query.

     • PGQL property graphs: See Example: Querying a PGQL Property Graph.

     • Graph Server: See Example: Querying a PGQL Property Graph in the Graph Server (PGX).

   • Table Result: Tabular output for SQL statements, SQL graph queries, or PGQL graph queries. See Viewing Query Results in a Table for more information.

   • Output: Text output for statements such as CREATE PROPERY GRAPH, INSERT, UPDATE, DELETE, or DROP PROPERTY GRAPH statements. See Querying and Visualizing PGQL Property Graphs for examples.

6. Query visualization panel: The main canvas where graph query results are visualized.

   You can right-click a vertex or an edge to open a property tooltip and view the properties associated with the selected graph element. Property tooltips can be pinned, repositioned, and resized to support comparison of multiple graph elements. See Viewing Vertex and Edge Properties for more information.

7. Graph visualization toolbar: Controls graph visualization modes and the different graph interaction options in the Query Visualization tab. See About the Graph Visualization Toolbar and Visualization Modes for more information.

8. Search: Search within the visualization results; includes support for keyword or conditional search. See Using Search in a Graph Visualization for more information.

9. Additional result controls:

   • Information: Shows the executed query (available in Query Visualization and Table Result tabs).

   • Settings: View and edit graph visualization settings in Query Visualization tab. See Query Visualization Settings for more information.

   • Fullscreen: Displays the output in full screen.

   • Visualization Settings Actions:

     • Export Visualization Settings: See Exporting Visualization Settings for more information.

     • Import Visualization Settings: See Importing Visualization Settings for more information.

10. Legend panel: Displays legend items for the graph visualization. See About the Graph Visualization Legend Panel for more information.

11. Display size: Controls the display size of the graph. See Managing the Display Size of the Graph for more information.