Smart Album with SQL

OsiriX and Horos Course · Database

In this lesson I explain how to create a Smart Album in OsiriX using advanced (SQL) criteria — a very useful feature when the simple filters aren't enough. The practical example in the video is organizing the database by separating patients by age, using the date of birth (Date of Birth) found in the study metadata. How to create a Smart Album (step by step) Go to the database window Under Albums, right-click Select Create Smart Album Simple criteria vs. advanced criteria Smart Albums can be created with simple criteria (the default options in the window). For more useful filters (such as age), we use an advanced criterion based on SQL. The logic is: create a function/condition and, if it is true, the study/patient appears in the Smart Album. Where to find the fields to use in the criterion In the video I show two DataSheets with the available information (study metadata). In them, you can locate the Date of Birth field, which can be used as a criterion. Example from the video: Smart Album by age (via Date of Birth) I create a Smart Album called “age” I set the criterion to filter patients whose date of birth is later than a chosen date (example: 01/01/1980) OsiriX creates the Smart Album and returns the patients that match the filter (in the example, 5 patients) Editing and refining the Smart Album To edit: double-click the Smart Album I change the date to broaden the filter: Example: adjust it to 01/01/1960 (increases the number of patients) I also create/use another example with a date after 1950 If you have any questions, I'm available to help.