<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<style type="text/css" style="display:none;"> P {margin-top:0;margin-bottom:0;} </style>
</head>
<body dir="ltr">
<div style="font-family: Calibri, Arial, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
Dear Cécile,</div>
<div style="font-family: Calibri, Arial, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
<br>
</div>
<div style="font-family: Calibri, Arial, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
Thank you for explanation! Very helpful. </div>
<div style="font-family: Calibri, Arial, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
<br>
</div>
<div style="font-family: Calibri, Arial, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
I was able to put the right values and get the query that we needed.</div>
<div style="font-family: Calibri, Arial, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
<br>
</div>
<div style="font-family: Calibri, Arial, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
Regards,</div>
<div style="font-family: Calibri, Arial, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
Alfredo.</div>
<div id="Signature">
<div class="BodyFragment"></div>
</div>
<div id="appendonsend"></div>
<hr style="display:inline-block;width:98%" tabindex="-1">
<div id="divRplyFwdMsg" dir="ltr"><font face="Calibri, sans-serif" style="font-size:11pt" color="#000000"><b>From:</b> Cecile Madjar <cecile.madjar@mcin.ca><br>
<b>Sent:</b> Tuesday, April 16, 2019 10:08 AM<br>
<b>To:</b> Morales Pinzon, Alfredo<br>
<b>Cc:</b> loris-dev@bic.mni.mcgill.ca; Sridar Narayanan, Dr.; Marciniak, Andrzej; Rozie Arnaoutelis; Zografos Caramanos; Douglas Arnold, Dr.; Guttmann, Charles,M.D.; Samson Antel<br>
<b>Subject:</b> Re: [Loris-dev] [IPMSA] MINC extent</font>
<div> </div>
</div>
<div>
<p><span style="padding:3px 10px; border-radius:5px; color:#ffffff; font-weight:bold; display:inline-block; background-color:#ff0000"> External Email - Use Caution </span></p>
<p></p>
<div dir="ltr">Dear Alfredo,
<div><br>
</div>
<div>This can easily be done using an SQL query since every header present in the MINC files are inserted into the parameter_file table.</div>
<div><br>
</div>
<div>Quick review of the MRI tables' structure (tables that you will need to query):</div>
<div>
<ul>
<li>files => stores the path to the file and some basic information. Primary key = FileID</li><li>parameter_type => stores the data dictionary of LORIS. Primary key = ParameterTypeID (all MINC header names can be found in this table when you add (WHERE SourceFrom="parameter_file")</li><li>parameter_file => stores all files MINC header values. Foreign keys to the files and parameter_type tables being the FileID and ParameterTypeID columns of parameter_file. The Value column would store the MINC header value</li></ul>
<div>So basically, to query the files matching a specific value for a MINC header, you would use a query like this one:</div>
</div>
<div><br>
</div>
<div><font face="monospace, monospace">SELECT File, Value </font></div>
<div><font face="monospace, monospace">FROM files f</font></div>
<div><font face="monospace, monospace"> JOIN parameter_file pf USING (FileID) </font></div>
<div><font face="monospace, monospace"> JOIN parameter_type pt USING (ParameterTypeID)</font></div>
<div><font face="monospace, monospace">WHERE </font></div>
<div><font face="monospace, monospace"> pt.Name="<font color="#0000ff">YOUR MINC HEADER NAME HERE</font>"</font></div>
<div><font face="monospace, monospace"> AND pf.Value="<font color="#0000ff">THE VALUE YOU WANT TO RESTRICT THE QUERY ON</font>"</font></div>
<div><br>
</div>
<div>In blue are the part that you will need to populate based on what you are looking for. For example, if you want to select all files with a repetition time of 2000ms, you would use the following values:</div>
<div>
<ul>
<li><font face="monospace, monospace">pt.Name="</font><font color="#0000ff" style="font-family:monospace,monospace">acquisition:repetition_time</font><span style="font-family:monospace,monospace">"</span><br>
</li><li><font face="monospace, monospace">pf.Value="<font color="#0000ff" style="">20</font></font><font color="#0000ff" style="font-family:monospace,monospace">00</font><span style="font-family:monospace,monospace">"</span><br>
</li></ul>
</div>
<div><br>
</div>
<div>Hope this helps. Let me know if something is not clear or if you have additional questions.</div>
<div><br>
</div>
<div>Best,</div>
<div><br>
</div>
<div>Cécile</div>
<div><br>
</div>
</div>
<br>
<div class="x_gmail_quote">
<div dir="ltr" class="x_gmail_attr">On Mon, Apr 15, 2019 at 6:17 PM Morales Pinzon, Alfredo <<a href="mailto:AMORALESPINZON@bwh.harvard.edu">AMORALESPINZON@bwh.harvard.edu</a>> wrote:<br>
</div>
<blockquote class="x_gmail_quote" style="margin:0px 0px 0px 0.8ex; border-left:1px solid rgb(204,204,204); padding-left:1ex">
<div dir="ltr">
<div style="font-family:Calibri,Arial,Helvetica,sans-serif; font-size:12pt; color:rgb(0,0,0)">
Dear LORIS-dev team,</div>
<div style="font-family:Calibri,Arial,Helvetica,sans-serif; font-size:12pt; color:rgb(0,0,0)">
<br>
</div>
<div style="font-family:Calibri,Arial,Helvetica,sans-serif; font-size:12pt; color:rgb(0,0,0)">
We have found an issue with some images where the created MINC file in LORIS only contains 1 slice. We have identified the potential error, which comes from the DICOM files, but we would like to track the images imported into LORIS having this problem. Is the
information about the extend of the images saved in the database? What would be the best strategy to find these images.</div>
<div style="font-family:Calibri,Arial,Helvetica,sans-serif; font-size:12pt; color:rgb(0,0,0)">
<br>
</div>
<div style="font-family:Calibri,Arial,Helvetica,sans-serif; font-size:12pt; color:rgb(0,0,0)">
Best regards,</div>
<div style="font-family:Calibri,Arial,Helvetica,sans-serif; font-size:12pt; color:rgb(0,0,0)">
Alfredo.</div>
<div id="x_gmail-m_7072003438774591475Signature">
<div class="x_gmail-m_7072003438774591475BodyFragment"></div>
</div>
<p></p>
<p>The information in this e-mail is intended only for the person to whom it is<br>
addressed. If you believe this e-mail was sent to you in error and the e-mail<br>
contains patient information, please contact the Partners Compliance HelpLine at<br>
<a href="http://www.partners.org/complianceline" target="_blank">http://www.partners.org/complianceline</a> . If the e-mail was sent to you in error<br>
but does not contain patient information, please contact the sender and properly<br>
dispose of the e-mail.</p>
</div>
_______________________________________________<br>
Loris-dev mailing list<br>
<a href="mailto:Loris-dev@bic.mni.mcgill.ca" target="_blank">Loris-dev@bic.mni.mcgill.ca</a><br>
<a href="https://mailman.bic.mni.mcgill.ca/mailman/listinfo/loris-dev" rel="noreferrer" target="_blank">https://mailman.bic.mni.mcgill.ca/mailman/listinfo/loris-dev</a><br>
</blockquote>
</div>
</div>
</body>
</html>