Retrieve a Business Query
get
/OracleBAMREST/bam/api/projects/{projectname}/queries/businessqueries/{businessqueryname}
Retrieves the business query details based on business query name.
Request
There are no request parameters for this operation.
Response
Supported Media Types
- application/json
- application/xml
200 Response
Success
Body
Root Schema : /paths/~1projects~1{projectname}~1queries~1businessqueries~1{businessqueryname}/get/responses/200/schema
Example 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"
}
]
}