6 Query the list of optimizations in a workspace

Description: Get user's (specified workspace) optimization list

6.1. Interface URL

Post http://${server-host}:${server-port}/api/v1/listAnalyses  

6.2. Request Parameters

Field	Type	Required	Description
userKey	String	Y	Activation code
workspaceId	String	N	Workspace ID (returns all user optimization information list if empty)
pageNumber	int	N	Page number (default 1)
pageSize	int	N	Page size (default 10)

Request Example

{  
    "userKey": "CB698418-88B25371-67F15F01-XXXXXXXX",  
    "workspaceId": "1730187810133712898",
    "pageNumber": 1,  
    "pageSize": 10   
}

6.3. Response

Field	Type	Description
code	int	Status code
message	String	Description
data	Object	Data

Data structure of data

Field	Type	Description
records	array	Workspace list information
analysisId	String	Analysis ID
analysisName	String	Analysis name
workspaceId	String	Workspace ID
workspaceName	String	Workspace name
status	String	Analysis execution status
numberOfQuery	int	Number of analyzed queries
numberOfSyntaxError	int	Number of syntax errors
numberOfIndex	int	Number of recommended indices
numberOfRewrite	int	Number of rewritten queries
numberOfViolations	int	Number of violated rules
numberOfViolatedQuery	int	Number of queries that violated rules
performanceImprove	double	Performance improvement percentage
createUserId	String	Creator ID
createUserName	String	Creator name
createTime	String	Creation time
total	String	Total
size	String	Page size