Filtering Cross References in a Query

Filtering cross references in a query is easy within Cradle.

Showing Cross References in a Query within Cradle

In this example we will create a query that shows links between all system requirements linked to all verifications.

  1. Create a query that shows all system requirements
  2. Then create a nested view which shows links to verification items
View Details dialog filtering cross references
View Details Dialog

This will display as shown below:

Query showing linked items
Query showing linked items

In this example 97 items are returned.

Show only Items that have a Linked Item

To only show items that are linked to one or more verification item, edit the Query Details dialog:

Query Details filtering cross references
Query Details dialog showing Links

which displays as follows:

Query showing linked items
Query showing only items that are linked

As you can see the list of items has now reduced to 43.

Show Items where Linked Item has a Category set

To only show items where the verification has a PASS value set in a category, a query is created.

  1. Create a query that only shows verifications that have a Pass value set:
Query Details showing category set
Query Details dialog showing Category set to Pass
Query showing passed items
Query showing passed items

Refer to this query in the Links tab of the Query Details dialog. Note that instead of using To Items set to Of Type, we have chosen Matching Query:

Query Details filtering cross references
Query Details showing Matching Query

You can now see the list has reduced to 28 items. These being the system requirements that have a Pass for one or more of the linked verifications.

Query showing passed linked items
Query showing passed linked items

Moving Cradle Projects

Are you upgrading/updating your servers? Here we explain moving Cradle projects from an old server to a new server. There are two ways to do this:

  • Moving projects to a new server with the same Cradle version
  • Moving projects to a new server and upgrading to a new Cradle version

Both of these scenarios are detailed below.

Please note if users have Personal definitions, e.g. if they are are using Sessions, these will either need to be copied or exported and imported to the new server. Personal definitions are located in $CRADLEHOME\admin\definitions\personal and the folders have the users names. If copying the definitions they need to be placed in the same location within the personal folder.

New Server with Same Cradle Version

If you are not upgrading Cradle at this time, this is really simple to do.

  1. Create the Cradle projects on the new server with the same project code as previously created on the old server. Ensure the pathname is the location where the databases will be stored.

    Create Project dialog
    Create Project dialog
  2. Copy the contents of the Cradle projects on the old server to the new server. The directory contains all of the data including user profiles, project setup, definitions etc.
    Explorer showing project contents
    Project Contents

    New Server with New Cradle Version

If you are upgrading the Cradle version as well as migrating to a new server, this is slightly more complex.

The safest method (although can be time consuming) is to create export files of the existing Cradle databases and then import them into the new server installation.

  1. When exporting the information from the “old” server, ensure Owner is set to Everything as shown below:Export Information dialog showing Owner option
  2. Once the new version of Cradle has been installed on the new server, you need to create the Cradle projects on the new server.
  3. In the new project you can then import the data exported from the old server . When importing, ensure Owner is set to As in file, Overwrite is set to On and the top four validation checkboxes are selected:Import Information dialog showing import options
  4. Repeat this for all projects

Another way to achieve this is to copy the project directories from the old server on to the new server and then manually convert the projects.

  1. Create the Cradle projects on the new server with the same project code as previously created on the old server with the pathname being the location where the databases will be stored.

    Create Project dialog
    Create Project dialog
  2. Copy the contents of the Cradle projects on the old server and overwrite the contents of the newly created projects on the new server. The directory contains all of the data including user profiles, project setup, definitions etc.
  3. Manually run the necessary converters to ensure the new projects are in the same format as the new Cradle version installed. Please note this may be several converters if converting from a much older version.

Note: Please ensure the projects have been converted BEFORE logging in.