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?