The Space Browser

You can use the space browser to query the data stored on a specific space.

A space browser is contextual and is available as a menu option on every space defined for the associated metaspace visible in the UI. When you select the Space Query option, the query builder is displayed on the right most pane of the page.

Space Query Menu Option

Query Builder

The Query builder is to the top-right corner of the page. The space browser gives you two ways of constructing a space query. You can use Custom Filter or Filter Builder to create your queries. The Custom Filter option is used to type in the query filter expression directly. The Filter Builder option is an UI that helps you build your query filter expression. The icon is used to edit the query and the icon is used to execute the query.

The Query Builder is Displayed on the Right Pane

Query Result

When you execute the query, the results are published under the Query Result pane. By default, the Query Result pane shows 10 entries and can span multiple pages. You can see up to a maximum of 100 entries per page. You can use the Previous and Next buttons to traverse through the query results. The icon can be used to select the number of columns appearing on the Query Result pane. To see extra columns, click the icon.

Query Result

Note: The maximum number of entries is limited to the Query Limit set by the Administrator per metaspace connection. The default is 2000. You can enter a filter expression to narrow down the result set as needed.

• Creating a Query using the Filter Builder
  The Filter Builder is used to create a query using Space Query Filter Expression Builder. The query is automatically generated with the help of the expression builder.
• Creating a Query using the Custom Filter
  The Custom Filter option is used to type in your query without the help of an expression builder.
• Sorting Queries in Browsers
  ActiveSpaces provides the ability to sort queries that are made using browsers. The sorting feature is implemented in the filter that is used for specifying a browser query. The filter can now use order by statements.