Advanced Smart Album (SQL)

OsiriX and Horos Course · Database

In this lesson I show how to create a Smart Album in OsiriX using advanced criteria (SQL). Beyond the simple filters, the SQL criterion lets you create a condition: if the function is true, the patient/study automatically appears in the Smart Album. 1) How to create the Smart Album In the Database window Under Albums, right-click Select Create Smart Album 2) Why use an advanced (SQL) criterion A very practical use is separating patients by age. To do that, we need to access fields from the study metadata (data about the data). In the video, I show two DataSheets with all the available fields and locate Date of Birth, which will be our criterion. 3) Example from the video: “Age” Smart Album I name the Smart Album “age” I define a criterion using Date of Birth Applied example: Date of Birth > 01/01/1980 OsiriX creates the Smart Album and returns the filtered patients (in the example, it found 5 patients) 4) Editing the Smart Album To edit, just double-click the Smart Album I adjust the date to widen the filter: 01/01/1960 (increases the number of patients) I also show another example with a date after 1950