Skip to content
AWS for Query.Farm

aws.medical_imaging.search_image_sets

Example SQL Queries

SELECT * FROM
aws.medical_imaging.search_image_sets
WHERE
"datastore_id" = 'VALUE';

Description

Search image sets based on defined input attributes.

SearchImageSets accepts a single search query parameter and returns a paginated response of all image sets that have the matching criteria. All date range queries must be input as (lowerBound, upperBound).

By default, SearchImageSets uses the updatedAt field for sorting in descending order from newest to oldest.

Table Definition

Column NameColumn Data Type
datastore_id Required Input Column

The identifier of the data store where the image sets reside.

VARCHAR
search_criteria Input Column

The search criteria that filters by applying a maximum of 1 item to SearchByAttribute.

STRUCT(
    "filters" STRUCT(
        "values" STRUCT(
            "dicom_patient_id" VARCHAR,
            "dicom_accession_number" VARCHAR,
            "dicom_study_id" VARCHAR,
            "dicom_study_instance_uid" VARCHAR,
            "dicom_series_instance_uid" VARCHAR,
            "created_at" TIMESTAMP_S,
            "updated_at" TIMESTAMP_S,
            "dicom_study_date_and_time" STRUCT(
                "dicom_study_date" VARCHAR,
                "dicom_study_time" VARCHAR
            )
        )[],
        "operator" VARCHAR
    )[],
    "sort" STRUCT(
        "sort_order" VARCHAR,
        "sort_field" VARCHAR
    )
)
Show child fields
search_criteria.filters[]
Show child fields
search_criteria.filters[].operator

The search filter operator for imageSetDateTime.

search_criteria.filters[].values[]
Show child fields
search_criteria.filters[].values[].created_at

The created at time of the image set provided for search.

search_criteria.filters[].values[].dicom_accession_number

The DICOM accession number for search.

search_criteria.filters[].values[].dicom_patient_id

The patient ID input for search.

search_criteria.filters[].values[].dicom_series_instance_uid

The Series Instance UID input for search.

search_criteria.filters[].values[].dicom_study_date_and_time

The aggregated structure containing DICOM study date and study time for search.

Show child fields
search_criteria.filters[].values[].dicom_study_date_and_time.dicom_study_date

The DICOM study date provided in yyMMdd format.

search_criteria.filters[].values[].dicom_study_date_and_time.dicom_study_time

The DICOM study time provided in HHmmss.FFFFFF format.

search_criteria.filters[].values[].dicom_study_id

The DICOM study ID for search.

search_criteria.filters[].values[].dicom_study_instance_uid

The DICOM study instance UID for search.

search_criteria.filters[].values[].updated_at

The timestamp input for search.

search_criteria.sort

The sort input for search criteria.

Show child fields
search_criteria.sort.sort_field

The sort field for search criteria.

search_criteria.sort.sort_order

The sort order for search criteria.

_aws_profile Input Column

The AWS profile defines the AWS identity used. It can be defined via credentials or by assuming a IAM role.

STRUCT(
    "type" VARCHAR,
    "name" VARCHAR,
    "account_id" VARCHAR,
    "via_profile_name" VARCHAR,
    "assumed_role_arn" VARCHAR,
    "organization" STRUCT(
        "account_name" VARCHAR,
        "id" VARCHAR,
        "tags" STRUCT(
            "key" VARCHAR,
            "value" VARCHAR
        )[],
        "master_account" STRUCT(
            "id" VARCHAR,
            "email" VARCHAR
        ),
        "parents" STRUCT(
            "type" VARCHAR,
            "id" VARCHAR,
            "name" VARCHAR,
            "tags" STRUCT(
                "key" VARCHAR,
                "value" VARCHAR
            )[]
        )[]
    )
)
Show child fields
_aws_profile.account_id

The AWS account id

_aws_profile.assumed_role_arn

The ARN of the assumed role

_aws_profile.name

The unique name of the profile.

_aws_profile.organization

Information about this profile's membership in the AWS organization.

Show child fields
_aws_profile.organization.account_name

The name of account speciifed by the organization

_aws_profile.organization.id

The organization id

_aws_profile.organization.master_account
Show child fields
_aws_profile.organization.master_account.email

The organization master account email address

_aws_profile.organization.master_account.id

The organization master account id

_aws_profile.organization.parents[]
Show child fields
_aws_profile.organization.parents[].id

The id of the parent

_aws_profile.organization.parents[].name

The name of the parent

_aws_profile.organization.parents[].tags[]
Show child fields
_aws_profile.organization.parents[].tags[].key
_aws_profile.organization.parents[].tags[].value
_aws_profile.organization.parents[].type

The type of parent can be an organization unit or a root

_aws_profile.organization.tags[]
Show child fields
_aws_profile.organization.tags[].key
_aws_profile.organization.tags[].value
_aws_profile.type

The type of profile, either 'credentials' or 'assumed_role'

_aws_profile.via_profile_name

This IAM role for this profile is assumed by first utilizing another profile with this name to obtain credentials.

image_sets_metadata_summaries

The model containing the image set results.

STRUCT(
    "image_set_id" VARCHAR,
    "version" BIGINT,
    "created_at" TIMESTAMP_S,
    "updated_at" TIMESTAMP_S,
    "dicom_tags" STRUCT(
        "dicom_patient_id" VARCHAR,
        "dicom_patient_name" VARCHAR,
        "dicom_patient_birth_date" VARCHAR,
        "dicom_patient_sex" VARCHAR,
        "dicom_study_instance_uid" VARCHAR,
        "dicom_study_id" VARCHAR,
        "dicom_study_description" VARCHAR,
        "dicom_number_of_study_related_series" BIGINT,
        "dicom_number_of_study_related_instances" BIGINT,
        "dicom_accession_number" VARCHAR,
        "dicom_series_instance_uid" VARCHAR,
        "dicom_series_modality" VARCHAR,
        "dicom_series_body_part" VARCHAR,
        "dicom_series_number" BIGINT,
        "dicom_study_date" VARCHAR,
        "dicom_study_time" VARCHAR
    )
)[]
Show child fields
image_sets_metadata_summaries[]
Show child fields
image_sets_metadata_summaries[].created_at

The time an image set is created. Sample creation date is provided in 1985-04-12T23:20:50.52Z format.

image_sets_metadata_summaries[].dicom_tags

The DICOM tags associated with the image set.

Show child fields
image_sets_metadata_summaries[].dicom_tags.dicom_accession_number

The accession number for the DICOM study.

image_sets_metadata_summaries[].dicom_tags.dicom_number_of_study_related_instances

The total number of instances in the DICOM study.

image_sets_metadata_summaries[].dicom_tags.dicom_number_of_study_related_series

The total number of series in the DICOM study.

image_sets_metadata_summaries[].dicom_tags.dicom_patient_birth_date

The patient birth date.

image_sets_metadata_summaries[].dicom_tags.dicom_patient_id

The unique identifier for a patient in a DICOM Study.

image_sets_metadata_summaries[].dicom_tags.dicom_patient_name

The patient name.

image_sets_metadata_summaries[].dicom_tags.dicom_patient_sex

The patient sex.

image_sets_metadata_summaries[].dicom_tags.dicom_series_body_part

The DICOM provided identifier for the series Body Part Examined.

image_sets_metadata_summaries[].dicom_tags.dicom_series_instance_uid

The DICOM provided identifier for the Series Instance UID.

image_sets_metadata_summaries[].dicom_tags.dicom_series_modality

The DICOM provided identifier for the series Modality.

image_sets_metadata_summaries[].dicom_tags.dicom_series_number

The DICOM provided identifier for the Series Number.

image_sets_metadata_summaries[].dicom_tags.dicom_study_date

The study date.

image_sets_metadata_summaries[].dicom_tags.dicom_study_description

The DICOM provided Study Description.

image_sets_metadata_summaries[].dicom_tags.dicom_study_id

The DICOM provided identifier for the Study ID.

image_sets_metadata_summaries[].dicom_tags.dicom_study_instance_uid

The DICOM provided identifier for the Study Instance UID.

image_sets_metadata_summaries[].dicom_tags.dicom_study_time

The study time.

image_sets_metadata_summaries[].image_set_id

The image set identifier.

image_sets_metadata_summaries[].updated_at

The time an image set was last updated.

image_sets_metadata_summaries[].version

The image set version.

sort

The sort order for image set search results.

STRUCT(
    "sort_order" VARCHAR,
    "sort_field" VARCHAR
)
Show child fields
sort.sort_field

The sort field for search criteria.

sort.sort_order

The sort order for search criteria.