Block certain studies from Query

hammad · May 28th 2021

Hi

I wanted some studies to be marked as private and no one can access those studies until their status is changed back to public.

For this purpose, i created a new column in table dicomstudies with the name and datatype as follow:- status varchar (1) and with default value 'A'. The field has 2 values only A = Active or B = Blocked.

I wanted whenever a query is made to PACS Server user gets studies that are with the status A.

Please share sample lua script for an idea and do guide me can i query multiple tables in lua , if yes sample script please.

--HM

marcelvanherk · Jun 1st 2021

Hi,

What actions do you want to block? The least the better. For instance if you cant query maybe you dont need to block retrieval.

Marcel

hammad · Jun 1st 2021

I want to block certain studies from querying. As mentioned in my question, i want to block certain studies from viewing.

marcelvanherk · Jun 2nd 2021

Ok,

You can use dbquery to read the study table, and you can use queryconverter0 to script the lua code that calls reject() for those sepecific studies,

e.g. (untested)

[lua]

queryconverter0 = a=dbquery("DICOMStudies", "status", "StudyInst='"..(Data.StudyInstanceUID or 'xx').."'") if a[1][1]=='B' then reject() end

Marcel

hammad · Jun 4th 2021

Thanks Marcel.

i will check and update you.

hammad · Jul 26th 2021

Sorry for the late response .

This is the error :: "[PACS] *** lua run error [string "a=dbquery("DICOMStudies", "StudyStatu","Stu..."]:1: attempt to index global 'a' (a nil value) in 'a=dbquery("DICOMStudies", "StudyStatu","StudyInst='"..(Data.StudyInstanceUID).."'")if a[1][1]=='B' then reject() end;'".

Please correct me where i am wrong.

marcelvanherk · Jul 26th 2021

try:

StudyInsta=

I had one letter too few,

Marcel

hammad · Jul 26th 2021

My dicom.ini is :

[lua]

QueryConverter0 = a = dbquery("DICOMStudies", "StudyStatu", "StudyInsta='"..Data.StudyInstanceUID.."'") if a[1][1]=='B' then reject() end;

This is the error log

[PACS] UPACS THREAD 1: STARTED AT: Mon Jul 26 13:30:21 2021

[PACS] Calling Application Title : "RADIANT "

[PACS] Called Application Title : "PACS "

[PACS] Application Context : "1.2.840.10008.3.1.1.1", PDU length: 16384

[PACS] Presentation Context 0 "1.2.840.10008.5.1.4.1.2.2.1" 1

[PACS] *** lua run error [string "a = dbquery("DICOMStudies", "StudyStatu", "..."]:1: attempt to index field '?' (a nil value) in 'a = dbquery("DICOMStudies", "StudyStatu", "StudyInsta='"..Data.StudyInstanceUID.."'") if a[1][1]=='B' then reject() end;'

[PACS] (StudyRootQuery) search level: STUDY

[PACS] C-Find (StudyRoot) located 2 records

[PACS] UPACS THREAD 1: ENDED AT: Mon Jul 26 13:30:21 2021

[PACS] UPACS THREAD 1: TOTAL RUNNING TIME: 0 SECONDS

Beside above, i tried to use this but no success:

QueryConverter0 = if (Data["9999,9003"]=='B' ) script('destroy') end;

Please guide

marcelvanherk · Jul 26th 2021

In lua it is "if .... then .... end"

The first script now finds no record.

Marcel

hammad · Jul 26th 2021

The first script is giving me error and shows all the records.

dicom.ini file

[lua]

QueryConverter0 = a = dbquery("DICOMStudies", "StudyStatu", "StudyInsta='"..Data.StudyInstanceUID.."'") if a[1][1]=='B' then reject() end;

server log

[PACS] UPACS THREAD 22: STARTED AT: Mon Jul 26 18:05:03 2021

[PACS] Calling Application Title : "RADIANT "

[PACS] Called Application Title : "PACS "

[PACS] Application Context : "1.2.840.10008.3.1.1.1", PDU length: 16384

[PACS] Presentation Context 0 "1.2.840.10008.5.1.4.1.2.2.1" 1

[PACS] *** lua run error [string "a = dbquery("DICOMStudies", "StudyStatu", "..."]:1: attempt to index field '?' (a nil value) in 'a = dbquery("DICOMStudies", "StudyStatu", "StudyInsta='"..Data.StudyInstanceUID.."'") if a[1][1]=='B' then reject() end;'

[PACS] (StudyRootQuery) search level: STUDY

[PACS] C-Find (StudyRoot) located 2 records

[PACS] UPACS THREAD 22: ENDED AT: Mon Jul 26 18:05:03 2021

[PACS] UPACS THREAD 22: TOTAL RUNNING TIME: 0 SECONDS

marcelvanherk · Jul 27th 2021

Try:

[lua]

QueryConverter0 = a = dbquery("DICOMStudies", "StudyStatu", "StudyInsta='"..Data.StudyInstanceUID.."'") if a[1] then if a[1][1]=='B' then reject() end end;

hammad · Jul 27th 2021

Same error :[PACS] *** lua run error [string "a = dbquery("DICOMStudies", "StudyStatu", "..."]:1: attempt to index field '?' (a nil value) in 'a = dbquery("DICOMStudies", "StudyStatu", "StudyInsta='"..Data.StudyInstanceUID.."'") if a[1][1]=='B' then reject() end;'

I then use the following lua code

if Data.QueryRetrieveLevel=='STUDY' then

local a = dbquery("DICOMStudies","StudyInsta", "Status","StudyInsta='"..Data.StudyInstanceUID.."'")

if #a==0 then reject() end

if a[1][2]=='B' then reject() end

end

[lua]

Association=print("Hello")

QueryConverter0 = dofile('test.lua')

The script worked once. But after restart of the server, its not working as desired.

hammad · Jul 28th 2021

Hi Marcel

I did some debugging with my lua script and found that StudyInstanceUID is not printing. This is my server log

[PACS]

[PACS] UPACS THREAD 35: STARTED AT: Wed Jul 28 14:26:37 2021

[PACS] Calling Application Title : "RADIANT "

[PACS] Called Application Title : "PACS "

[PACS] Application Context : "1.2.840.10008.3.1.1.1", PDU length: 16384

[PACS] Presentation Context 0 "1.2.840.10008.5.1.4.1.2.2.1" 1

[PACS] Hello

[PACS] (Study instance UID should be printed here but its not)

[PACS] Value of A is::1

[PACS] Status value is:: B

[PACS] (Study instance UID should be printed here but its not)

[PACS] (StudyRootQuery) search level: STUDY

[PACS] C-Find (StudyRoot) located 1 records

[PACS] UPACS THREAD 35: ENDED AT: Wed Jul 28 14:26:37 2021

[PACS] UPACS THREAD 35: TOTAL RUNNING TIME: 0 SECONDS

my lua script is

print("Hello")

print (Data.StudyInstanceUID)

if Data.QueryRetrieveLevel=='STUDY' then

local a = dbquery("DICOMStudies","Studystatu","StudyInsta","StudyInsta='"..Data.StudyInstanceUID.."'")

if (#a==0) then reject() end

print("Value of A is::"..#a)

print ("Status value is:: "..a[1][1])

if (a[1][1]=="B") then print(Data.StudyInstanceUID) end

end

marcelvanherk · Jul 28th 2021

Hi,

if the query does not contain the study instance UID you cannot use that variable. What software generates the queries, and do you have any control over that?

Marcel

hammad · Jul 28th 2021

Hi

Modalities send studies to PACS Server. If i look at the database StudyInstanceUID is populated.

As, said in my previous posts, the script worked for a while until server services was restarted. After that it doesn't work.

Marcel possible can you please test the script at your end..

marcelvanherk · Jul 29th 2021

Hi,

In queryconverter0, Data represents the query data, not the database.

Marcel

hammad · Jul 29th 2021

That's the reason StudyInstance UID is not populated as i am making a wild query on the server. BUt my question remains the same WHY DID THE CODE EXECUTED FOR 4 HOURS???

If there any temp or cache that PACS Server maintains?? Reason is i had deleted a lua file that is associated with filename syntax but the server still save some of the images with defined syntax. I am confused on that.

Can you guide me on any work around???

marcelvanherk · Jul 30th 2021

No cache,

if you want to filter wild queries you would have to enforce studyUID is included and process QueryResultConverter

and (unrelated) if you store images already in the database, these will keep the same name.

Marcel

hammad · Jul 30th 2021

It means i cannot use StudyInstace UID in QueryConvertor????

marcelvanherk · Jul 30th 2021

Not directly, if you query

StudyInstanceUID = ''

then this means you need to filter all results, because some returned studies will be allowed and others not.

While if you query e.g.

StudyInstanceUID = '1.2.3'

Then it returns 0 or 1 studies and you can filter the query. I.e., it is a bit more complesx than you hoped.

Marcel

Block certain studies from Query

Participate now!

Share