Oracle Cloud Infrastructure Documentation

Using the JSON Editor in Explorer

OPSI Data Object Explorers can have searches customized using the integrated JSON Editor, this allows you to open all saved searches inside the Data Object Explorer, edit the searches metadata, view changes, and save them.

The OPSI Explorer user interface provides an SQL query editor and visualization selector. The query editor has two modes, Basic mode and Advanced mode. Within these modes you may need further customization, in these cases the JSON Editor can be used. The following scenarios outline some of the situations you may need to access the JSON Editor:
  • Access additional charts supported by the framework, for example: treemap, cigar chart, gauge, and labels, that are currently not available in the Explorer UI.
  • Provide additions properties not available in the visualizations, for example: update CSS style, column header name, add an icon, create a drill down link, or a drawer link.
  • Query and transform data from multiple data sources by updating via the JSON Editor the data configuration of the current metadata.
  • Open an existing saved search that has multiple data sources under data configuration, the query editor panel will be hidden, use the JSON Editor to update the query.
  • Open an existing saved search which has a customized UI configuration not supported by the visualization panel, the visualization panel will be hidden; use the JSON Editor to update the visualization.

Enable and Use the JSON Editor

The following is a list of general steps to enable the JSON Editor in Data Object Explorer
  1. Open the Ops Insights Data Object Explorer you wish to view, see: Accessing Data Object Explorers.
  2. Click JSON Editor in the Saved search section at the top of the page.
  3. In the JSON Editor, you can update the data configuration for the query and the UI configuration for the visualization.
    Note

    Hover over a property name to view its description.
  4. Fix any errors or warnings that appear.
    Note

    Hover over the error to view its description.
  5. After updating the metadata, click Apply to apply the changes. The JSON Editor closes, the updated visualization loads in Data Object Explorer, and the updated query is shown in the query editor.
    Note

    Apply does NOT save the changes.
    To cancel your changes, click Cancel. The JSON Editor closes without applying the changes.
  6. To save the changes, click Save or Save as in the Saved search section.
    Note

    Use Save as if the saved search is an Oracle-provided out-of-the-box search.