Jump to

• Request
• Response

[Deprecated]: Get query data based on multiple parameters

get

/ec-query-svc/rest/v10.0/studies/{studyId}/{mode}/queryDetails

Deprecated: Retrieves data related to queries based on any combination of the following parameters:

• study ID
• study mode (Testing, Training, or Production)
• subject ID
• site ID
• visit ID
• event ID
• form ID
• question ID
• query state

Additional Filter options can be found in request payload.

Request

Path Parameters

• assignedRoleId(required): string
  Assigned Role Id

  Example:

  6AF54DB79B764662B685D68C52AB0B84

• closedStudyRoleId(required): string
  Closed Study RoleId

  Example:

  E6A54005DBAF4A0F9315ABFEE70DBC47

• creatorStudyRoleId(required): string
  Creator Study RoleId

  Example:

  E6A54005DBAF4A0F9315ABFEE70DBC47

• currentRecord(required): string
  Get the current record of each query. (1 - Yes, 2 -No)

  Example:

  1

• dataElementId(required): string
  Get query data for a specific data element.

  Example:

  6B1321B7038349038B81F2AB3F3DFED1

• eventId(required): string
  Get query data for a specific visit event.

  Example:

  8F1E8B453D8F4B6EB278B324EFE38A7C

• eventInstanceNumber(required): string
  Get query data for a specific event instance number.

  Example:

  1

• formId(required): string
  Get query data for a specific form.

  Example:

  BEF84349611E441D8A3CC3555DA0E80E

• formIdList(required): array
  FormId List

  Example:

  E6A54005DBAF4A0F9315ABFEE70DBC47

• formInstanceNumber(required): string
  Get query data for a specific form instance number.

  Example:

  1

• itemId(required): string
  Get query data for a specific itemId.

  Example:

  F931D4F68BD54F5A9455D91583FFE3F7

• lastUpdated(required): string
  Last Updated

  Example:

  dd-MMM-yyyy

• limit(required):
  Specify the maximum number of queries to return.

  Example:

  100

• mode(required): string
  Study mode. (Test, Training, Active)

  Example:

  true

• offset(required):
  Specify the offset in the query results from which to start returning data

  Example:

  20

• oldest(required):
  Order query data in ascending time order if oldest=true. Descending order otherwise.

  Example:

  true

• propertyName(required): string
  Property Type

  Example:

  visitStartDate

• propertyType(required): string
  Property Type

  Example:

  visit

• queryByAge(required): string
  Query By Age

  Example:

  -7

• queryByID(required): string
  Query By ID

  Example:

  6AF54DB79B764662B685D68C52AB0B84

• queryClosedBy(required): string
  Query Closed By

  Example:

  6AF54DB79B764662B685D68C52113456

• queryCreatedBy(required): string
  Query Creator ID

  Example:

  6AF54DB79B764662B685D68C52AB0B84

• queryGridView(required): string
  For Query Management Grid View

  Example:

  True or False

• queryType(required): string
  Query Type

  Example:

  Auto

• searchStr(required): string
  Search String

  Example:

  Query on VSD

• siteId(required): string
  Get query data for a specific site.

  Example:

  8F1E8B453D8F4B6EB278B324EFE38A7C

• siteIdList(required): array
  List of SiteId

  Example:

  [6AF54DB79B764662B685D68C52AB0B84,32F54DB79B764662B685D68C52AB0B84]

• state(required): array
  Get query data in a specific state.

  Example:

  [Closed,Opened]

• studyId(required): string
  Study ID.

  Example:

  0D04308A0ECE4DD0AAA2C2C4C5FF8995

• subjectId(required): string
  Get query data for a specific subject.

  Example:

  7837ED89824C40329635EC020C290530

• subjectIdList(required): array
  List of SubjectId

  Example:

  [6AF54DB79B764662B685D68C52AB0B84,32F54DB79B764662B685D68C52AB0B84]

• visitId(required): string
  Get query data for a specific visit.

  Example:

  8F1E8B453D8F4B6EB278B324EFE38A7C

Query Parameters

• repeatFormNumber: integer
  Repeat Form Number

  Example:

  1

There's no request body for this operation.

Back to Top

Response

Supported Media Types

• application/json

200 Response

Successful operation.

Body ()

Root Schema : schema

Type: array

Show Source

• Array of: object QueryDetailsDTOv10Resp

{
    "type":"array",
    "items":{
        "$ref":"#/components/schemas/QueryDetailsDTOv10Resp"
    }
}

Nested Schema : QueryDetailsDTOv10Resp

Type: object

Show Source

• comments: array comments
• discrepancyId: integer
  Discrepancy Id
• eventInstanceNumber: number
  Sequence number (0, 1, 2, ...) of repeating event

  Example: 0
• formId: string (uuid)
  Form Unique GUID
• formInstanceNumber: number
  Sequence number (0, 1, 2, ...) of repeating form

  Example: 0
• formName: string
• id: string (uuid)
  Query Unique GUID
• isCycle: boolean
• isQueryCreator: boolean
  Is Query creator (true or false)

  Example: true
• itemId: string (uuid)
  Item Unique GUID
• itemName: string
• objectVersionNumber: number
  Sequence number (0, 1, 2, ...) of object Version Number

  Example: 0
• propertyName: string
• propertyType: string
• queryAge: string
• queryModAllowedByUser: boolean
• repeatFormNumber: integer
  Repeat Form Number
• ruleId: string (uuid)
• siteId: string (uuid)
  Site Unique GUID
• studyRoles: array studyRoles
• studyVersion: string
• subjectId: string (uuid)
  Subject Unique GUID
• subjectName: string
• userCanAnswerQuery: boolean
• userCanCloseQuery: boolean
• visitId: string (uuid)
• visitName: string

{
    "type":"object",
    "properties":{
        "id":{
            "type":"string",
            "description":"Query Unique GUID",
            "format":"uuid"
        },
        "subjectId":{
            "type":"string",
            "description":"Subject Unique GUID",
            "format":"uuid"
        },
        "formId":{
            "type":"string",
            "description":"Form Unique GUID",
            "format":"uuid"
        },
        "formInstanceNumber":{
            "type":"number",
            "description":"Sequence number (0, 1, 2, ...) of repeating form",
            "example":0
        },
        "siteId":{
            "type":"string",
            "description":"Site Unique GUID",
            "format":"uuid"
        },
        "eventInstanceNumber":{
            "type":"number",
            "description":"Sequence number (0, 1, 2, ...) of repeating event",
            "example":0
        },
        "studyRoles":{
            "type":"array",
            "items":{
                "$ref":"#/components/schemas/QueryStudyRoleDTOv6"
            }
        },
        "discrepancyId":{
            "type":"integer",
            "description":"Discrepancy Id"
        },
        "repeatFormNumber":{
            "type":"integer",
            "description":"Repeat Form Number"
        },
        "objectVersionNumber":{
            "type":"number",
            "description":"Sequence number (0, 1, 2, ...) of object Version Number",
            "example":0
        },
        "itemId":{
            "type":"string",
            "description":"Item Unique GUID",
            "format":"uuid"
        },
        "propertyName":{
            "type":"string"
        },
        "propertyType":{
            "type":"string"
        },
        "ruleId":{
            "type":"string",
            "format":"uuid"
        },
        "isQueryCreator":{
            "type":"boolean",
            "description":"Is Query creator (true or false)",
            "example":true
        },
        "subjectName":{
            "type":"string"
        },
        "visitName":{
            "type":"string"
        },
        "formName":{
            "type":"string"
        },
        "visitId":{
            "type":"string",
            "format":"uuid"
        },
        "studyVersion":{
            "type":"string"
        },
        "itemName":{
            "type":"string"
        },
        "comments":{
            "type":"array",
            "items":{
                "$ref":"#/components/schemas/CommentDetailsDTOV2"
            }
        },
        "queryModAllowedByUser":{
            "type":"boolean"
        },
        "userCanCloseQuery":{
            "type":"boolean"
        },
        "userCanAnswerQuery":{
            "type":"boolean"
        },
        "queryAge":{
            "type":"string"
        },
        "isCycle":{
            "type":"boolean"
        }
    }
}

Nested Schema : comments

Type: array

Show Source

• Array of: object CommentDetailsDTOV2

{
    "type":"array",
    "items":{
        "$ref":"#/components/schemas/CommentDetailsDTOV2"
    }
}

Nested Schema : studyRoles

Type: array

Show Source

• Array of: object QueryStudyRoleDTOv6

{
    "type":"array",
    "items":{
        "$ref":"#/components/schemas/QueryStudyRoleDTOv6"
    }
}

Nested Schema : CommentDetailsDTOV2

Type: object

Show Source

• queryComment: string
• state: string
  Allowed Values: [ "Candidate", "Opened", "Answered", "Deleted", "Closed" ]
• userDisplayName: string
• userInfo: object DisplayUserDto
  User details including name, username, and email address.
• userStudyRoleId: string
• userStudyRoleName: string
• value: string
• versionStart: string (date-time)

{
    "type":"object",
    "properties":{
        "state":{
            "type":"string",
            "enum":[
                "Candidate",
                "Opened",
                "Answered",
                "Deleted",
                "Closed"
            ]
        },
        "queryComment":{
            "type":"string"
        },
        "versionStart":{
            "type":"string",
            "format":"date-time"
        },
        "value":{
            "type":"string"
        },
        "userInfo":{
            "$ref":"#/components/schemas/DisplayUserDto"
        },
        "userDisplayName":{
            "type":"string"
        },
        "userStudyRoleId":{
            "type":"string"
        },
        "userStudyRoleName":{
            "type":"string"
        }
    }
}

Nested Schema : DisplayUserDto

Type: object

User details including name, username, and email address.

Show Source

• emailAddress: string
  User's email address.

  Example: [e-mail]
• firstName: string
  User's first name.

  Example: Alice
• id: string
  Unique identifier for the user.

  Example: 1BC29B36F5D64B1B95F4BDBBCEA481BE
• lastName: string
  User's last name.

  Example: Brown
• userName: string
  User's login name.

  Example: alicebrown

{
    "type":"object",
    "properties":{
        "id":{
            "type":"string",
            "description":"Unique identifier for the user.",
            "example":"1BC29B36F5D64B1B95F4BDBBCEA481BE"
        },
        "firstName":{
            "type":"string",
            "description":"User's first name.",
            "example":"Alice"
        },
        "lastName":{
            "type":"string",
            "description":"User's last name.",
            "example":"Brown"
        },
        "userName":{
            "type":"string",
            "description":"User's login name.",
            "example":"alicebrown"
        },
        "emailAddress":{
            "type":"string",
            "description":"User's email address.",
            "example":"[e-mail]"
        }
    },
    "description":"User details including name, username, and email address."
}

Nested Schema : QueryStudyRoleDTOv6

Type: object

Show Source

• studyRoleId: string (uuid)
  Study role of the user performing the query operation
• studyRoleName: string
  Study role name of the user performing the query operation

  Example: CRA

{
    "type":"object",
    "properties":{
        "studyRoleId":{
            "type":"string",
            "description":"Study role of the user performing the query operation",
            "format":"uuid"
        },
        "studyRoleName":{
            "type":"string",
            "description":"Study role name of the user performing the query operation",
            "example":"CRA"
        }
    }
}

Examples

Select an example QueryDetailsDTOResponseExample

400 Response

Data is invalid.

Body ()

Root Schema : Response DTO

Type: object

Response from Query APIs

Show Source

• errorData: object Error details DTO
  Read Only: true

  Error details from Query APIs
• result: object result
  Read Only: true

  Result Object
• status: string
  Read Only: true

  Allowed Values: [ "success, failed" ]

  Status
• version: string
  Read Only: true

  Response version

{
    "type":"object",
    "properties":{
        "status":{
            "type":"string",
            "description":"Status",
            "readOnly":true,
            "enum":[
                "success, failed"
            ]
        },
        "result":{
            "type":"object",
            "description":"Result Object",
            "readOnly":true
        },
        "errorData":{
            "$ref":"#/components/schemas/Error details DTO"
        },
        "version":{
            "type":"string",
            "description":"Response version",
            "readOnly":true
        }
    },
    "description":"Response from Query APIs"
}

Nested Schema : Error details DTO

Type: object

Read Only: true

Error details from Query APIs

Show Source

• details: object details
  Read Only: true

  Error Details
• errorCode: string
  Read Only: true

  Error Code
• errorMessage: string
  Read Only: true

  Error Message

{
    "type":"object",
    "properties":{
        "errorCode":{
            "type":"string",
            "description":"Error Code",
            "readOnly":true
        },
        "errorMessage":{
            "type":"string",
            "description":"Error Message",
            "readOnly":true
        },
        "details":{
            "type":"object",
            "description":"Error Details",
            "readOnly":true
        }
    },
    "description":"Error details from Query APIs",
    "readOnly":true
}

Nested Schema : result

Type: object

Read Only: true

Result Object

Nested Schema : details

Type: object

Read Only: true

Error Details

404 Response

The query could not be found.

Body ()

Root Schema : Response DTO

Type: object

Response from Query APIs

Show Source

• errorData: object Error details DTO
  Read Only: true

  Error details from Query APIs
• result: object result
  Read Only: true

  Result Object
• status: string
  Read Only: true

  Allowed Values: [ "success, failed" ]

  Status
• version: string
  Read Only: true

  Response version

{
    "type":"object",
    "properties":{
        "status":{
            "type":"string",
            "description":"Status",
            "readOnly":true,
            "enum":[
                "success, failed"
            ]
        },
        "result":{
            "type":"object",
            "description":"Result Object",
            "readOnly":true
        },
        "errorData":{
            "$ref":"#/components/schemas/Error details DTO"
        },
        "version":{
            "type":"string",
            "description":"Response version",
            "readOnly":true
        }
    },
    "description":"Response from Query APIs"
}

Nested Schema : Error details DTO

Type: object

Read Only: true

Error details from Query APIs

Show Source

• details: object details
  Read Only: true

  Error Details
• errorCode: string
  Read Only: true

  Error Code
• errorMessage: string
  Read Only: true

  Error Message

{
    "type":"object",
    "properties":{
        "errorCode":{
            "type":"string",
            "description":"Error Code",
            "readOnly":true
        },
        "errorMessage":{
            "type":"string",
            "description":"Error Message",
            "readOnly":true
        },
        "details":{
            "type":"object",
            "description":"Error Details",
            "readOnly":true
        }
    },
    "description":"Error details from Query APIs",
    "readOnly":true
}

Nested Schema : result

Type: object

Read Only: true

Result Object

Nested Schema : details

Type: object

Read Only: true

Error Details

Back to Top