My Oracle Support Banner

HC:Oracle Prop. Graph Webapp Visualization Settings Only Id And Label Is Selectable As Vertex Lbl. (Doc ID 2809201.1)

Last updated on JULY 20, 2024

Applies to:

Oracle Graph Server and Client - Version 21.2 and later
Information in this document applies to any platform.

Goal

When using SQLcl PGQL Plug-in for Oracle Graph Server, how to visualize this graph using Propert Graph webapp.

This is the graph:
SQL> pgql auto on;

PGQL Auto enabled for graph=[null], execute=[true], translate=[false]
PGQL> CREATE PROPERTY GRAPH scott_hr
  2 VERTEX TABLES (
  3 emp KEY(empno) LABEL Employee
  4 PROPERTIES (ename as name),
  5 dept KEY(deptno) LABEL Department
  6 PROPERTIES ( dname as name )
  7 )
  8 EDGE TABLES (
  9 emp AS works_for
 10 SOURCE KEY ( empno ) REFERENCES emp
 11 DESTINATION KEY ( deptno ) REFERENCES dept
 12 NO PROPERTIES
 13 );

Graph created

Employee has name as property:
PGQL> SELECT e.name
2 FROM MATCH (e:Employee) ON scott_hr
3 ORDER by e.ename
4 LIMIT 4;

Logging in to the web application (deployed to Tomcat) the whole graph is displayed.
Right click on one vertex and only id and label are shown, no other property.
How is the "name" property shown on the graph.
The Settings/Visualization/Labeling/Vertex Label only has id and label in the dropdown list.  The name property is missing

Solution

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Goal
Solution


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.