Skip to content

aws.mturk.list_qualification_types

Example SQL Queries

SELECT * FROM
aws.mturk.list_qualification_types
WHERE
"must_be_requestable" = 'VALUE';

Description

The ListQualificationTypes operation returns a list of Qualification types, filtered by an optional search term.

Table Definition

Column NameColumn Data Type
must_be_requestable Required Input Column

Specifies that only Qualification types that a user can request through the Amazon Mechanical Turk web site, such as by taking a Qualification test, are returned as results of the search. Some Qualification types, such as those assigned automatically by the system, cannot be requested directly by users. If false, all Qualification types, including those managed by the system, are considered. Valid values are True | False.

BOOLEAN
must_be_owned_by_caller Input Column

Specifies that only Qualification types that the Requester created are returned. If false, the operation returns all Qualification types.

BOOLEAN
query Input Column

A text query against all of the searchable attributes of Qualification types.

VARCHAR
_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.

num_results

The number of Qualification types on this page in the filtered results list, equivalent to the number of types this operation returns.

BIGINT
qualification_types

The list of QualificationType elements returned by the query.

STRUCT(
"qualification_type_id" VARCHAR,
"creation_time" TIMESTAMP_S,
"name" VARCHAR,
"description" VARCHAR,
"keywords" VARCHAR,
"qualification_type_status" VARCHAR,
"test" VARCHAR,
"test_duration_in_seconds" BIGINT,
"answer_key" VARCHAR,
"retry_delay_in_seconds" BIGINT,
"is_requestable" BOOLEAN,
"auto_granted" BOOLEAN,
"auto_granted_value" BIGINT
)[]
Show child fields
qualification_types[]
Show child fields
qualification_types[].answer_key

The answers to the Qualification test specified in the Test parameter.

qualification_types[].auto_granted

Specifies that requests for the Qualification type are granted immediately, without prompting the Worker with a Qualification test. Valid values are True | False.

qualification_types[].auto_granted_value

The Qualification integer value to use for automatically granted Qualifications, if AutoGranted is true. This is 1 by default.

qualification_types[].creation_time

The date and time the Qualification type was created.

qualification_types[].description

A long description for the Qualification type.

qualification_types[].is_requestable

Specifies whether the Qualification type is one that a user can request through the Amazon Mechanical Turk web site, such as by taking a Qualification test. This value is False for Qualifications assigned automatically by the system. Valid values are True | False.

qualification_types[].keywords

One or more words or phrases that describe theQualification type, separated by commas. The Keywords make the type easier to find using a search.

qualification_types[].name

The name of the Qualification type. The type name is used to identify the type, and to find the type using a Qualification type search.

qualification_types[].qualification_type_id

A unique identifier for the Qualification type. A Qualification type is given a Qualification type ID when you call the CreateQualificationType operation.

qualification_types[].qualification_type_status

The status of the Qualification type. A Qualification type's status determines if users can apply to receive a Qualification of this type, and if HITs can be created with requirements based on this type. Valid values are Active | Inactive.

qualification_types[].retry_delay_in_seconds

The amount of time, in seconds, Workers must wait after taking the Qualification test before they can take it again. Workers can take a Qualification test multiple times if they were not granted the Qualification from a previous attempt, or if the test offers a gradient score and they want a better score. If not specified, retries are disabled and Workers can request a Qualification only once.

qualification_types[].test

The questions for a Qualification test associated with this Qualification type that a user can take to obtain a Qualification of this type. This parameter must be specified if AnswerKey is present. A Qualification type cannot have both a specified Test parameter and an AutoGranted value of true.

qualification_types[].test_duration_in_seconds

The amount of time, in seconds, given to a Worker to complete the Qualification test, beginning from the time the Worker requests the Qualification.