Just for completeness... during my first tests in solving that problem i modified the db-schema. Thats why it worked yesterday in my testenvironment. To get the desired behaviour with the default db-schema as conquest created it, i had to set:
ImageQuerySortOrder = CAST(DICOMImages.ImageNumbe AS UNSIGNED)
Awesome, works perfectly as desired 
Thanks a lot! Time for some diff now
Wow, nice.... but now I guess I'll never find out, whats going on in ODBCI.CPP 
I'm going to test it right now, will report...
Just found out something interesting...
Not ordered:
30.09.2009 14:03:37 [CONQUESTSRV] Columns : DICOMImages.SOPClassUI, DICOMImages.SOPInstanc, DICOMSeries.SeriesDate, DICOMSeries.SeriesTime, DICOMSeries.Modality, DICOMSeries.SeriesDesc, DICOMSeries.BodyPartEx, DICOMSeries.ProtocolNa, DICOMSeries.PatientPos, DICOMSeries.SeriesInst, DICOMSeries.SeriesNumb, DICOMStudies.StudyInsta,DICOMImages.ObjectFile,DICOMImages.DeviceName
This results in:
30.09.2009 14:03:38 [CONQUESTSRV] Locating file:MAG0 293352\1.2.840.113619.2.22.288.54104.3479.1.20090930.192851_0001_000001_12543013660000.dcm
Ordered:
30.09.2009 14:05:54 [CONQUESTSRV] Columns : DICOMImages.SOPClassUI, DICOMImages.SOPInstanc, DICOMSeries.SeriesDate, DICOMSeries.SeriesTime, DICOMSeries.Modality, DICOMSeries.SeriesDesc, DICOMSeries.BodyPartEx, DICOMSeries.ProtocolNa, DICOMSeries.PatientPos, DICOMSeries.SeriesInst, DICOMSeries.SeriesNumb, DICOMStudies.StudyInsta, DICOMIMAGES.ImageNumbe,DICOMImages.ObjectFile,DICOMImages.DeviceName
This results in:
30.09.2009 14:05:55 [CONQUESTSRV] Locating file:293352\1.2.840.113619.2.22.288.54104.3479.1.20090930.192851_0001_000001_12543013660000.dcm 1
Same for both cases: Locating file:<14. queried column> <13. queried column>
ATM I'm trying to find out, what's going on in ODBCI.CPP, perhaps i might find out something more...
Just to be sure i checked if my MySQL-installation is case sensitive:
SELECT ImageNumbe FROM DICOMImages d;
SELECT imagenumbe FROM dicomimages d;
SELECT ImAgEnUmBe FROM DiCoMiMaGeS d;
They all give me the same (good) results.
The MySQL-Tables are in lowercase, that's how conquest created them. Seems like MySQL is just case sensitve for the columns, not the tablenames. Anyway, I tried changing it to DICOMIMAGES.ImageNumbe, got exactly the same results....
The logfile with ImageQuerySortOrder not set:
....
I highlighted the differences...
Hi,
Today I've set up a test environment with Conquest 1.4.15 using native MySQL. Everythings seems to work fine so far except the order in which images are sent to my PACS-client. This order is important to me, as my PACS-client shows the images in this order. So I tried setting:
ImageQuerySortOrder = dicomimages.ImageNumbe
After that change, dgate crashes in the moment my PACS-client tries to retrieve a study. PacsTrouble.log tells me '***Could not find file:1'.
serverstatus.log with debuglevel 4 tells me:
30.09.2009 11:44:42 [CONQUESTSRV] Query On Image
30.09.2009 11:44:42 [CONQUESTSRV] Issue Query on Columns: DICOMImages.SOPClassUI, DICOMImages.SOPInstanc, DICOMSeries.SeriesDate, DICOMSeries.SeriesTime, DICOMSeries.Modality, DICOMSeries.SeriesDesc, DICOMSeries.BodyPartEx, DICOMSeries.ProtocolNa, DICOMSeries.PatientPos, DICOMSeries.SeriesInst, DICOMSeries.SeriesNumb, DICOMStudies.StudyInsta, dicomimages.ImageNumbe,DICOMImages.ObjectFile,DICOMImages.DeviceName
30.09.2009 11:44:42 [CONQUESTSRV] Values: DICOMSeries.SeriesInst = '1.2.840.113619.2.22.288.54104.3479.1.20090930.192851' and DICOMStudies.StudyInsta = '1.2.840.113619.2.22.288.54104.3479.20090930.192851' and DICOMSeries.StudyInsta = DICOMStudies.StudyInsta and DICOMImages.SeriesInst = DICOMSeries.SeriesInst
30.09.2009 11:44:42 [CONQUESTSRV] Tables: DICOMImages, DICOMSeries, DICOMStudies
30.09.2009 11:44:42 [CONQUESTSRV] Query Distinct Tables: DICOMImages, DICOMSeries, DICOMStudies
30.09.2009 11:44:42 [CONQUESTSRV] Columns : DICOMImages.SOPClassUI, DICOMImages.SOPInstanc, DICOMSeries.SeriesDate, DICOMSeries.SeriesTime, DICOMSeries.Modality, DICOMSeries.SeriesDesc, DICOMSeries.BodyPartEx, DICOMSeries.ProtocolNa, DICOMSeries.PatientPos, DICOMSeries.SeriesInst, DICOMSeries.SeriesNumb, DICOMStudies.StudyInsta, dicomimages.ImageNumbe,DICOMImages.ObjectFile,DICOMImages.DeviceName
30.09.2009 11:44:42 [CONQUESTSRV] Where : DICOMSeries.SeriesInst = '1.2.840.113619.2.22.288.54104.3479.1.20090930.192851' and DICOMStudies.StudyInsta = '1.2.840.113619.2.22.288.54104.3479.20090930.192851' and DICOMSeries.StudyInsta = DICOMStudies.StudyInsta and DICOMImages.SeriesInst = DICOMSeries.SeriesInst
30.09.2009 11:44:42 [CONQUESTSRV] Order : dicomimages.ImageNumbe
30.09.2009 11:44:42 [CONQUESTSRV] Records = 1
30.09.2009 11:44:42 [CONQUESTSRV] Number of Images to send: 1
30.09.2009 11:44:42 [CONQUESTSRV] MyStudyRootRetrieveGeneric :: RetrieveOn
30.09.2009 11:44:42 [CONQUESTSRV] Locating file:293352\1.2.840.113619.2.22.288.54104.3479.1.20090930.192851_0001_000001_12543013660000.dcm 1
30.09.2009 11:44:42 [CONQUESTSRV] Locating file:293352\1.2.840.113619.2.22.288.54104.3479.1.20090930.192851_0001_000001_12543013660000.dcm 1
30.09.2009 11:44:42 [CONQUESTSRV] ***Could not find file:1
When ImageQuerySortOrder is not set, the relevant lines are:
30.09.2009 11:39:34 [CONQUESTSRV] Locating file:MAG0 293352\1.2.840.113619.2.22.288.54104.3479.1.20090930.192851_0001_000001_12543013660000.dcm
30.09.2009 11:39:34 [CONQUESTSRV] Sending file : C:\dicomserver1415\data\293352\1.2.840.113619.2.22.288.54104.3479.1.20090930.192851_0001_000001_12543013660000.dcm
Any ideas, how to get the images delivered in the desired order? Thanks
Hi,
I'm developing a tool, which allows me to easily change some tags of all images in a given study. A function of this tool spawns an external process: "dgate.exe --deletestudy:<StudyInstanceUID>". This command works as expected, but always returns 1, no matter wether the study existed or not. Is this intended behavior?
