Get all historical records on table DC_Query_Study_Roles
get
/ec-query-svc/rest/v1.0/studies/{studyId}/{mode}/queries/queryStudyRolesTable
Retrieves all historical records on all database columns of the DC_Query_Study_Roles table in paginated format for a requested studyid and study mode sorted by version_start.
Request
Path Parameters
-
mode(required): string
Study mode.
-
studyId(required): string
Study ID.
Query Parameters
-
limit: integer(int32)
Limit
-
offset: integer(int32)
Offset
-
queryId: string
Query ID.
-
sort: string
Sort Order: desc-descending order, any other value-ascending order.Default Value:
asc
There's no request body for this operation.
Back to TopResponse
Supported Media Types
- application/json
200 Response
Successful operation.
Root Schema : schema
Type:
Show Source
array
-
Array of:
object QueryDTO Version 6
Title:
QueryDTO Version 6
Information for creating/editing query
Nested Schema : QueryDTO Version 6
Type:
object
Title:
QueryDTO Version 6
Information for creating/editing query
Show Source
-
comment: string
commentExample:
site12
-
id: string
(uuid)
QueryRoles Unique GUID
-
objectVersionNumber: number
Sequence number (0, 1, 2, ...) of object Version NumberExample:
0
-
operationType: string
operation typeExample:
CREATED
-
queryId: string
(uuid)
Query Unique GUID
-
reason: string
reasonExample:
Study roles assignment change
-
softwareVersionNumber: number
softwareVersionNumberExample:
1
-
studyRoleId: string
studyRole Unique GUIDExample:
B2B8327AFAA6412287106192AB5984EF
-
userId: string
user Unique GUIDExample:
B2B8327AFAA6412287106192AB5984EF
-
versionEnd: string
(date-time)
query Version end
-
versionStart: string
(date-time)
query Version Start
400 Response
Data is invalid.
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
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
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.
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
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
Nested Schema : result
Type:
object
Read Only:
true
Result Object
Nested Schema : details
Type:
object
Read Only:
true
Error Details