Search with mask in CONQUEST

Hi, I´d like to search a name starting with "MARIA" for sample

I think the correct sql will be something as: DICOMStudies.PatientNam LIKE 'MARIA%'

with Clearcanvas

If I use:

Name:MARIA*

I get

[CONQUESTLOCAL] Issue Query on Columns: DICOMStudies.StudyDate, DICOMStudies.StudyTime, DICOMStudies.AccessionN, DICOMStudies.StudyModal, DICOMStudies.ReferPhysi, DICOMStudies.StudyDescr, DICOMStudies.PatientNam, DICOMStudies.PatientID, DICOMStudies.PatientBir, DICOMStudies.PatientSex, DICOMStudies.PatientsAg, DICOMStudies.StudyInsta, DICOMStudies.StudyID

[CONQUESTLOCAL] Values: DICOMStudies.PatientNam LIKE '%MARIA%%'

[CONQUESTLOCAL] Tables: DICOMStudies

[CONQUESTLOCAL] Sorting (DICOMStudies.PatientNam) DoSort := 1

[CONQUESTLOCAL] Query Distinct Tables: DICOMStudies

[CONQUESTLOCAL] Columns : DICOMStudies.StudyDate, DICOMStudies.StudyTime, DICOMStudies.AccessionN, DICOMStudies.StudyModal, DICOMStudies.ReferPhysi, DICOMStudies.StudyDescr, DICOMStudies.PatientNam, DICOMStudies.PatientID, DICOMStudies.PatientBir, DICOMStudies.PatientSex, DICOMStudies.PatientsAg, DICOMStudies.StudyInsta, DICOMStudies.StudyID

[CONQUESTLOCAL] Where : DICOMStudies.PatientNam LIKE '%MARIA%%'

[CONQUESTLOCAL] Order : DICOMStudies.PatientNam

If I use:

Name:MARIA

I get

CONQUESTLOCAL] Issue Query on Columns: DICOMStudies.StudyDate, DICOMStudies.StudyTime, DICOMStudies.AccessionN, DICOMStudies.StudyModal, DICOMStudies.ReferPhysi, DICOMStudies.StudyDescr, DICOMStudies.PatientNam, DICOMStudies.PatientID, DICOMStudies.PatientBir, DICOMStudies.PatientSex, DICOMStudies.PatientsAg, DICOMStudies.StudyInsta, DICOMStudies.StudyID

[CONQUESTLOCAL] Values: DICOMStudies.PatientNam LIKE '%MARIA%'

[CONQUESTLOCAL] Tables: DICOMStudies

[CONQUESTLOCAL] Sorting (DICOMStudies.PatientNam) DoSort := 1

[CONQUESTLOCAL] Query Distinct Tables: DICOMStudies

[CONQUESTLOCAL] Columns : DICOMStudies.StudyDate, DICOMStudies.StudyTime, DICOMStudies.AccessionN, DICOMStudies.StudyModal, DICOMStudies.ReferPhysi, DICOMStudies.StudyDescr, DICOMStudies.PatientNam, DICOMStudies.PatientID, DICOMStudies.PatientBir, DICOMStudies.PatientSex, DICOMStudies.PatientsAg, DICOMStudies.StudyInsta, DICOMStudies.StudyID

[CONQUESTLOCAL] Where : DICOMStudies.PatientNam LIKE '%MARIA%'

[CONQUESTLOCAL] Order : DICOMStudies.PatientNam

[CONQUESTLOCAL] Records = 17716

So, It can't use the table index to search a name starting with "MARIA", because it puts "%" before the name in the sql

Is it a ClearCanvas problem not related to conquest?

Quote from marcelvanherk

I guess so. Can you see in the log what clearcanvas passes in the DICOM data?

Marcel

Hi, Marcel

I´m afraid of ClearCanvas has no option to log it.

I have looking at the logs and there is nothing related to it.

Luiz

Quote from marcelvanherk

Hi Luiz,

I meant in the conquest log. At high level it logs the dicom request.

Marcel

Hi, Marcel

My debuglevel is 4.

The GUI log is the one posted above:

with Clearcanvas

If I use:

Name:MARIA*

I get

[CONQUESTLOCAL] Issue Query on Columns: DICOMStudies.StudyDate, DICOMStudies.StudyTime, DICOMStudies.AccessionN, DICOMStudies.StudyModal, DICOMStudies.ReferPhysi, DICOMStudies.StudyDescr, DICOMStudies.PatientNam, DICOMStudies.PatientID, DICOMStudies.PatientBir, DICOMStudies.PatientSex, DICOMStudies.PatientsAg, DICOMStudies.StudyInsta, DICOMStudies.StudyID

[CONQUESTLOCAL] Values: DICOMStudies.PatientNam LIKE '%MARIA%%'

[CONQUESTLOCAL] Tables: DICOMStudies

[CONQUESTLOCAL] Sorting (DICOMStudies.PatientNam) DoSort := 1

[CONQUESTLOCAL] Query Distinct Tables: DICOMStudies

[CONQUESTLOCAL] Columns : DICOMStudies.StudyDate, DICOMStudies.StudyTime, DICOMStudies.AccessionN, DICOMStudies.StudyModal, DICOMStudies.ReferPhysi, DICOMStudies.StudyDescr, DICOMStudies.PatientNam, DICOMStudies.PatientID, DICOMStudies.PatientBir, DICOMStudies.PatientSex, DICOMStudies.PatientsAg, DICOMStudies.StudyInsta, DICOMStudies.StudyID

[CONQUESTLOCAL] Where : DICOMStudies.PatientNam LIKE '%MARIA%%'

[CONQUESTLOCAL] Order : DICOMStudies.PatientNam

If I use:

Name:MARIA

I get

CONQUESTLOCAL] Issue Query on Columns: DICOMStudies.StudyDate, DICOMStudies.StudyTime, DICOMStudies.AccessionN, DICOMStudies.StudyModal, DICOMStudies.ReferPhysi, DICOMStudies.StudyDescr, DICOMStudies.PatientNam, DICOMStudies.PatientID, DICOMStudies.PatientBir, DICOMStudies.PatientSex, DICOMStudies.PatientsAg, DICOMStudies.StudyInsta, DICOMStudies.StudyID

[CONQUESTLOCAL] Values: DICOMStudies.PatientNam LIKE '%MARIA%'

[CONQUESTLOCAL] Tables: DICOMStudies

[CONQUESTLOCAL] Sorting (DICOMStudies.PatientNam) DoSort := 1

[CONQUESTLOCAL] Query Distinct Tables: DICOMStudies

[CONQUESTLOCAL] Columns : DICOMStudies.StudyDate, DICOMStudies.StudyTime, DICOMStudies.AccessionN, DICOMStudies.StudyModal, DICOMStudies.ReferPhysi, DICOMStudies.StudyDescr, DICOMStudies.PatientNam, DICOMStudies.PatientID, DICOMStudies.PatientBir, DICOMStudies.PatientSex, DICOMStudies.PatientsAg, DICOMStudies.StudyInsta, DICOMStudies.StudyID

[CONQUESTLOCAL] Where : DICOMStudies.PatientNam LIKE '%MARIA%'

[CONQUESTLOCAL] Order : DICOMStudies.PatientNam

[CONQUESTLOCAL] Records = 17716

Isn´t it what you asked for?

Hi, Marcel

I had looking into CC help and I get the text in the picture below.

So, It is as CC works. It appends '*' around the 'name'.

I´d need rebuild the source to fix it. It is out of my work scope.

From CC help search:

"- Name

Searches in the patient's name field. Enter as much of the patient's name as is known; for example, his/her entire last name. The search uses wildcards by adding an * to the beginning and end of the text you entered and will find all patients whose name contains the text anywhere in their full name."

Quote from marcelvanherk

Ok,

your example "MARIA" returns 17716 records. Is this correct?

Marcel

Yes, It is.

Quote from marcelvanherk

There are 17716 patients called Maria?

Marcel

Hi, Marcel.

No. There are 17716 patients with 'MARIA' included in your name.

For sample: MARIA DA SILVA, JOAO MARIA DE SOUZA, .......

Quote from marcelvanherk

Ok,

this is huge database. Indices do not work for LIKE searches. Apparently you need to upgrade to a more powerful database. The smallest change would be to add memory to the server or change the disk to SSD.

regards,

Marcel

Display More

Hi, Marcel,

I have created some table indexes after read your notes in 1.50b. There, I saw some table indexes suggestions.

The speed is better and acceptable now.

Luiz