Advanced data searching

The advanced search in Data Management enables you to create custom search fields that will return trials (or other data levels) based on your chosen set of search criteria that exist in either the metadata (columns) or within the C3D files (variables). This is particularly useful if you are trying to find an individual trial or sets of trials for comparison purposes. You can:

• Search a single database or across multiple databases
• Search databases that exist on the local PC or across a network drive
• Use the wizard-based search building system
• Build complex search criteria for metadata or C3D information

For example, searches you might set up could be:

• Find all trials where the subject BodyMass is greater than 75Kg, the Pathology is Osteoarthritis, the Affected Side is Left and the Maximum Knee Moment is greater than 715Nm; or
• Find all Subject Names where the Activity is Baseball Pitching, the Maximum Shoulder Angle Velocity is higher than 80 degrees per second and Trial Date is between Jan 1, 2013 and Today.

To use the search query wizard:

1. On the Data Management tab, make sure the required location is selected.

2. Click the Search button (or click the Toggle search interface button .)
   

3. In the Search Query line, either select an existing search from the drop-down list, or to start a new search, click the Configuration menu button and then click New.

   

4. To specify a new search, in the Selected Query area, select the required options, working from left to right. To add further criteria to your search, click the Add Node button or Add Child button to the right of the pane.

   

   Note that the criteria available for selection change depending on the currently selected line.

5. To run the current search, click the Execute Search button at the left of the pane.
   The results of your search are displayed.

6. To save the search, click either the Save button or from the Configuration menu list, click Save As.
7. To close the search controls, in the toolbar at the top of the pane, click the Search button again (see Step 2).
   You can now:
   • Sort based on any of the returned data columns
   • Open any level of data by double-clicking on it
   • Export the data as ASCII to either Notepad or Excel
   • Export the data as a list of paths to either Notepad or Excel (for external processing)