Hi,
I'm working on a LUA script that i would like to use for cleaning the conquest database once a day.
For that I will loop through all the images from an IMAGE level query result and delete those images.
But the query doesn't work as expected on my test server while the same query does work on a conquest server on my local workstation.
I found out that the difference in database configuration (local workstation: 'dbase' and test server: 'ms sql server') causes the different results.
Using this query:
Code
server = servercommand('get_param:MyACRNema')y = DicomObject:new()y.QueryRetrieveLevel = 'SERIES'y.Modality = 'CT' y.PatientName = ''y.PatientID = ''y.SeriesInstanceUID = ''z = dicomquery(server, 'SERIES', y);print("Nr of series:", #z)for i = 0, #z-1 do w = DicomObject:new() w.QueryRetrieveLevel = 'IMAGE' w.SeriesInstanceUID = z[i].SeriesInstanceUID w.Modality = '' w.PatientID = '' x = dicomquery(server, 'IMAGE', w) print("Patient: " .. x.PatientID, "Modality: " .. x.Modality, "Nr of images: " .. #x)end
On my local workstation results in (with dbase):
and on the test server (with sql server):
Is this familiar behavior and is there a work around?
Kind regards.
Dave