{"id":931,"date":"2020-07-22T14:19:58","date_gmt":"2020-07-22T06:19:58","guid":{"rendered":"https:\/\/www.yohz.com\/blogs\/?p=931"},"modified":"2020-08-16T14:44:09","modified_gmt":"2020-08-16T06:44:09","slug":"dicom-search-querying-the-database-preview-2","status":"publish","type":"post","link":"https:\/\/www.yohz.com\/blogs\/2020\/07\/22\/dicom-search-querying-the-database-preview-2\/","title":{"rendered":"DICOM Search – querying the database (preview 2)"},"content":{"rendered":"

Once DICOM Search has indexed the DICOM tags in your images<\/a>, you can run queries against the tags<\/strong> table.\u00a0 Selecting everything from the tags<\/strong> table, while possible, isn’t very useful and is very slow.<\/p>\n

\"\"<\/p>\n

The reason is because there are over 2800 fields, and DICOM Search will struggle to maintain and display that many columns.\u00a0 Thus, it is recommended that you select only the fields you are interested in.<\/p>\n

You can quickly see which fields are available in your database by pressing F2<\/strong> when in the SQL editor to bring up the Tags and Fields<\/strong> window.<\/p>\n

\"\"<\/p>\n

Clicking on any of the tag values will add that value to the SQL editor area, so you do not need to manually enter the tag name.\u00a0 In addition to the DICOM tags, there are also additional fields that DICOM Search populates in the tags table, as listed in the Field names<\/strong> tab.<\/p>\n

\"\"<\/p>\n

In addition to your key fields, the other fields are used by DICOM Search to maintain a record of the processed images.\u00a0 For the users, the useful fields are ds_thumbnail<\/strong> and ds_filename<\/strong>.\u00a0 ds_thumbnail<\/strong> stores a thumbnail of the image and ds_filename<\/strong> stores the location of the image file when exported from your database, or when processed from your folder.<\/p>\n

\"\"<\/p>\n

If the listed file name is present on your computer, you can open the image file in your DICOM viewer by double-clicking on the file name in DICOM Search.<\/p>\n

Please see this post<\/a> on how to index and extract images from your database to your computer using DICOM Search, and also how to add thumbnails to the tags database.<\/p>\n

 <\/p>\n

SQL syntax<\/h2>\n

The tag values are stored in a SQLite database, so you will use the SQLite SQL syntax to query the database.\u00a0 In our example, our key fields are patientID<\/strong> and studyID<\/strong>, so we will always select those columns in case we want to query the source database.\u00a0 We also select the ds_thumbnail<\/strong> and ds_filename<\/strong> columns to view the image thumbnail, and also have a link to the actual image.<\/p>\n

Here are some examples of the types of queries you can run:<\/p>\n