When a query is run in WorkBench, the tool will return a list of the items matching the criteria specified.
As a Cradle database can contain any number of items of information a query could find 0 to 1 million items.
The time taken to find so many items could be excessive. Therefore, queries find and return items from the database in blocks. The default size of a block is 1000 items but can be extended to 8000 items in UI Control user preferences:
This means that when you run a query it will return at most N items.
Navigating between Blocks of Data
When the block is shown in the WorkBench UI, it is preceded by Previous… and followed by Next….
If you select these, then the query is re-run to find the next block or the previous block of items.
In this example, clicking the Next… option will retrieve the next set of items in the query:
Selecting Previous… again will return you to the previous block of items.
Reporting Items
If you are creating a report or publishing a document using a query, it is likely that you would NOT wish to be restricted by blocks of items.
Reports allow you to specify:
- Selected items – items highlighted in the query
- All items in this set – the block of N items
- All matching items in database – the totality of items matching the query criteria
Publish Table options