Advanced data searching

The new 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 now:

     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, click the Search tab at the bottom of the pane, and then click the Open search queries for editing button btnOpenSrch.png.

2.    In the Eclipse Search Query Setup dialog box, click the Add New button (green plus sign) and specify your search.

AdvSearch_sm.png 

3.    When you have finished, click the Exit Search Setup button (top right) btnExitSearchSetup.png.

4.    Make sure you have selected the required location to search and then click the Run currently selected search button.

btnRunSearch.png 

The results of your search are displayed.

AdvSearchReturn_sm.png 

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)