Inspect Collections

This tab gives an overview of all the database collections.

Inspect Collections is read only. To edit the collections, select to activate the Edit Mode.

Parameters

  • Inspect Collections: here you can enter a database query. The query needs:
    • To be an array of strings.
    • The same structure as an API call.
    • To be between double quotes.

    Example

    ["cloudflow.file","contains",".pdf"]

    For the syntax, see topic General Topic list - query in the API reference (on http://<server>:<port>/?api).

  • CLEAN UP ALL STALE APPROVAL(S)1: if you select this option, you can clean up all stale approvals. These are approvals that have become useless.

    Example

    An approval flow was started but the files are not yet approved or rejected. A user removes the workables of the flow. This leaves assets to be approved, but forcing the approval is not possible because the workables don't exist anymore.

  • LIMIT: here you can enter the maximum number of records that you want to display on the screen.
  • COLLECTIONS: here you can select the collection you want to open from a drop-down list.

Extra functionalities

  • Sort the records by clicking on the headings (= the keys) on top of the records.
  • Filter the records by entering a value in the filter fields.
  • Delete each record individually by selecting on the right.
  • Delete them all at once by selecting Delete all at the bottom.
  • Select to expand or collapse the record tree. If you select ⌘ and simultaneously, all record trees will be expanded.
  • Double click on a record to view and/or edit the JSON code. If you edit the JSON file, select Save to save it.
1 This option is only available when inspecting the approval collection