ビジネス問合せの取得
get
/OracleBAMREST/bam/api/projects/{projectname}/queries/businessqueries/{businessqueryname}
ビジネス問合せ名に基づいてビジネス問合せの詳細を取得します。
リクエスト
この操作にはリクエスト・パラメータはありません。
レスポンス
サポートされているメディア・タイプ
- application/json
- application/xml
200レスポンス
成功
本文
ルート・スキーマ: /paths/~1projects~1{projectname}~1queries~1businessqueries~1{businessqueryname}/get/responses/200/schema
application/jsonの例
{
"query":{
"opaqueSql":"",
"systemManaged":false,
"selectedFields":[
],
"internal":false,
"groupFilter":{
"name":"groupFilter",
"type":"ALL",
"branches":[
],
"entries":[
],
"none":false
},
"displayName":"ErrorCategory_DRL_BQ_v1",
"createdDate":"2015-05-12T23:55:24.345+0000",
"runtimeFilter":{
"name":"runtimeFilter",
"type":"ALL",
"branches":[
],
"entries":[
],
"none":false
},
"topNEnabled":false,
"internalFilter":{
"name":"internalFilter",
"type":"ALL",
"branches":[
{
"name":null,
"type":"ANY",
"branches":[
],
"entries":[
{
"column":"ErrorType",
"lhsColumn":{
"name":"ErrorType",
"displayName":"Error Type"
},
"operator":"EQ",
"rhsValue":{
"value":"Permanent",
"beamObject":null
},
"isDateTimeLike":false,
"dateCompareMode":"DATETIME"
},
{
"column":"ErrorType",
"lhsColumn":{
"name":"ErrorType",
"displayName":"Error Type"
},
"operator":"EQ",
"rhsValue":{
"value":"Transient",
"beamObject":null
},
"isDateTimeLike":false,
"dateCompareMode":"DATETIME"
}
],
"none":false
}
],
"entries":[
{
"column":"CF_To_Extract_Year",
"lhsColumn":{
"name":"CF_To_Extract_Year",
"displayName":"CF_To_Extract_Year"
},
"operator":"EQ",
"rhsValue":{
"beamObject":{
"itemType":"Parameter",
"projectName":"BAMFramework",
"itemName":"ASN_DAYWISEVOL_YEAR_PARAM"
}
},
"isDateTimeLike":false,
"dateCompareMode":"DATETIME"
},
{
"column":"CF_To_Extract_Month",
"lhsColumn":{
"name":"CF_To_Extract_Month",
"displayName":"CF_To_Extract_Month"
},
"operator":"EQ",
"rhsValue":{
"beamObject":{
"itemType":"Parameter",
"projectName":"BAMFramework",
"itemName":"ASN_DAYWISEVOL_MONTH_PARAM"
}
},
"isDateTimeLike":false,
"dateCompareMode":"DATETIME"
},
{
"column":"CF_To_Extract_DAY",
"lhsColumn":{
"name":"CF_To_Extract_DAY",
"displayName":"CF_To_Extract_DAY"
},
"operator":"EQ",
"rhsValue":{
"beamObject":{
"itemType":"Parameter",
"projectName":"BAMFramework",
"itemName":"ASN_DAYWISEVOL_DAY_PARAM"
}
},
"isDateTimeLike":false,
"dateCompareMode":"DATETIME"
},
{
"column":"LAST_24_HOUR_DATE",
"lhsColumn":{
"name":"LAST_24_HOUR_DATE",
"displayName":"LAST_24_HOUR_DATE"
},
"operator":"LT",
"rhsValue":{
"value":3,
"beamObject":null
},
"isDateTimeLike":false,
"dateCompareMode":"DATETIME"
}
],
"none":false
},
"dataObjectName":"CommonAudit_DO",
"id":"/project/BAMFramework/businessquery/ErrorCategory_DRL_BQ_v1",
"createdBy":"testuser",
"name":"ErrorCategory_DRL_BQ_v1",
"hierarchy":null,
"topN":3,
"virtualDO":null,
"dataSourceName":"",
"opaque":false,
"modifiedBy":"testuser",
"type":"GROUP",
"topNMeasure":null,
"dataSeries":[
"COUNT(*)"
],
"modifiedDate":"2015-05-12T23:55:24.345+0000",
"projectName":"BAMFramework",
"labelSeries":[
"ErrorType"
],
"calculatedFields":[
],
"groups":[
"CF_To_Extract_DAY",
"CF_TO_EXTRACT_HOUR"
],
"description":null,
"timeGroupings":{
"entries":[
]
},
"sorts":{
"CF_To_Extract_DAY":0,
"CF_TO_EXTRACT_HOUR":0
}
},
"links":[
{
"rel":"self",
"href":"http://example.com:7001/OracleBAMREST/bam/api/projects/BAMFramework/queries/businessqueries/ErrorCategory_DRL_BQ_v1"
}
]
}