Search & Manage Data

The "Search & Manage Data" screen can be opened via Application Menu.

The main purpose of the "Search & Manage Data" screen is to allow the user to find graph elements and start a visualization with these elements or add them into the currently opened visualization. All indexed data can be searched on this page with fulltext search or with Cypher queries. The user can search and view only data to which he has been granted access. Only a user with permission "Read all data" can search and view all data or run Cypher queries.

All searches (queries) are organized in tabs. There are two types of tabs that can be created:

  • Node's table tab: this type of tab lets the user to choose properties that will be displayed as table columns and simple conditions can be constructed to filter nodes and combine it with fulltext search to find specific nodes.

  • Cypher tab: this type of tab lets the user to enter any Cypher query (based on user's permissions only ready Cypher queries can be executed or any Cypher query if the user has the "Read all data" permission).

Search screen elements

images/download/attachments/18580639/GLDOC_search_01_comments.png

1.Search Panel

The Search Panel contains:

  • New visualization - start new visualization for selected elements. See Visualization.

  • Add to visualization - add selected elements into current visualization. See Visualization.

  • Search field - full-text search input:

    • If search is configured to work automatically, search starts automatically every time the text in the Search field is changed (can be configured, see Search mode)

    • If search is configured to work manually, press "Enter" to start a full-text search with the current input in the Search field

    • Which properties can be searched is configured in Node fulltext index

    • Both settings, Search mode and Node full-text index can also be configured directly on search page with the Search Settings widget (cogs icon images/download/thumbnails/18580639/cogs_icon.png next to the Search field)

  • Repository - g lobal Repository is used to store common search queries for quick access by all users of the system. Queries in Global Repository is managed by the admin.

  • CSV export - exports result in CSV format (can be opened in Microsoft Excel or other CSV editing tools). Only the first 10000 records are exported. Exported columns and column names can be configured (see Export).

  • Import file - data (nodes or relationships) can be imported from CSV or XLS files. See Import file for more details.

  • Create node - creates new nodes in the database. It's available only for users with the "Data management" permission.

2.Search query tabs

Tabs are used to organize and save search queries. For example, if your domain is Configuration Management then you can create separate tabs for Services, Applications, Servers and Racks as in the picture above. If you enter a string into the Search field then the full-text search runs only within the data defined by the currently selected (active) tab.

3.Add new query

New query (tab) can be created with this button. The new query is created as a copy of the active tab.

4.Query panel toggle

The Query Panel can be turned on or off with this button. The Query Panel is used to change the query in the active tab.

5.Query panel for Node's table tab

When the type of active tab is set to "Node's table" the user can specify columns of the results table (every column is one property of the found nodes), construct a simple condition for filtering nodes and combine it with full-text search of indexed properties. The condition that can be constructed with the query consists of sub-conditions on labels and/or properties. Multiple properties can be added and for every property multiple values can be specified. In order to pass the condition the node has to have at least one of the specified labels (OR between labels) and for every specified property (AND between properties) at least one of the values (OR between property values). For the setting in the picture above the condition can be read as follows: Return the properties (specified as columns) of all nodes with the label "parent:book" AND with the property "date_precision" set to value "year" OR "decade".

The resulting table has columns in the order as specified in the columns picker. If you want to reorder columns in the table you can do it by reordering the columns picker values.

6.Search result table for Node's table tab

Search result contains all data that meet the combined search criteria defined by the full-text search field and the Query Panel.

Nodes in table can be selected:

  • select 1 element: click on record

  • select more elements: hold CTRL and click on several records

  • select more consecutive elements: click on the first record, then hold SHIFT and click on the last record - every record between the first and the last record will be selected

Selected nodes can be used to start new visualization, can be added to the current visualization or export. Export options can be configured (see CSV export).

Table contains only some properties of nodes (selected in query panel). To view all properties press detail icon on the right side of record. Tabs of the detail panel can be configured (see Data schema).

If there are too many columns in the result table, some of them are automatically hidden (page is responsive). Press "+" icon on the left side of a record to show the hidden properties.

Sorting of any column can be changed by pressing arrows next to the column title.

Tab with Cypher query

images/download/attachments/18580639/GLDOC_search_02_comments.png

7.Query panel for Cypher tab

When the type of active tab is set to "Cypher," the user can execute Cypher queries and start a vizualization with nodes and relationships in the query result as starting points for visualization.

Note that:

  • read Cypher queries are available for users with the "Read all data" permission

  • write Cypher queries are available for users with the "Read all data" and "Data management" permissions

  • full-text search and CSV export are not available in combination with Cypher queries

    • you can export nodes or relationships as a CSV file in the visualization - just click "New visualization" and then export the data

8.Query result for Cypher tab

The result of the Cypher query is summarized in the Cypher result window. The counts of the different record types are displayed, and a simple result viewer (JSON viewer) is available for further inspection of results if needed. If there is at least one node, relationship or path in the result then the "New visualization" and "Add to visualization" buttons are enabled.