Group by Request , Respponse and Message

Elastic Stack Elasticsearch
1

Hi

I have a request to build a query or dashboard to group

Group by Request , Response and Message in one view

has this been done?

2

Please give us examples of what your documents look like and what you mean by grouping exactly?

4

In Preformatted textsupport logs have these 3 elements which is what the testers require:
request, response, and complete JSON.

2018-02-19 16:02:57,387 INFO [WebContainer : 6] z.c.a.m.g.r.o.y.c.GetChoresByStatusImpl [GetChoresByStatusImpl.java:88] Request{
"childAdultIndicator": "Adult",
"filterValues": {
"filterValue": "**"
},
"sortValues": {
"sortValueList": [
{
"sortFieldName": "choreStatus",
"sortDirection": "DESC"
}
]
},
"choreStatus": "A",
"header": {
"statuscode": "0",
"userAgent": "Java/1.7.0",
"wfpt": "754e7af2e6c1977d500",
"jsessionid": "NIATkYVLG1hl0ZXIQcKB2m5",
"esessionid": "7196eb60d748a3788e48",
"xfpt": "754e7af2e6c1977d500",
"service": "YouthManagementFacade",
"operation": "GetChoresByStatus",
"channel": "I",
"timestamp": "2018-02-19 16:02:57",
"sourceip": "ddd",
"accessAccount": "4047940506",
"userNumber": "1",
"nonce": "_Wk5r_tnfNTO0sYWTbVhKp1kX5x63L8HCfjdI9emxyk",
"language": "en",
"organization": "ABSA",
"brand": "ABSA",
"applicationId": "MEGAU",
"resultMessages": null,
"paginationContext": {
"moreToCome": false,
"batchSize": 0,
"batchSizeLimit": 0,
"recordIdentity": "0",
"totalNoOfRecords": 0
}
}
}
2018-02-19 16:02:57,388 INFO [WebContainer : 6] c.b.m.g.o.b.AbstractPostAuthGatewayOperation [AbstractPostAuthGatewayOperation.java:99] Request Header:{Content-Type=[application/json], Accept=[application/json], Cookie=[JSESSIONID=0000NIATkYVLG1hl0ZXIQcKB2m5:19og8sca0, WFPT=754e7af2e6c1977d500, XFPT=754e7af2e6c1977d500]}
2018-02-19 16:02:57,517 INFO [WebContainer : 6] z.c.a.m.g.r.o.y.c.GetChoresByStatusImpl [GetChoresByStatusImpl.java:91] Response : {
"statusCode": "OK",
"headers": {
"X-Powered-By": [
"Servlet/3.0"
],
"Content-Type": [
"application/json; charset=UTF-8"
],
"Content-Language": [
"en-US"
],
"Content-Length": [
"970"
],
"Date": [
"Mon, 19 Feb 2018 14:02:57 GMT"
]
},
"body": {
"header": {
"statuscode": "0",
"userAgent": "Java/1.7.0",
"wfpt": null,
"jsessionid": "dkdkdjdjjjddjdd",
"esessionid": "djdkdkkdkdkkdidjd",
"xfpt": null,
"service": "YouthManagementFacade",
"operation": "GetChoresByStatus",
"channel": "I",
"timestamp": "2018-02-19 16:02:57.511",
"sourceip": "xx.xxxx.xx.xx",
"accessAccount": "ddddddddddddd",
"userNumber": "1",
"nonce": "ccccccccccccccccccccccccccc",
"language": "en",
"organization": "DEMO",
"brand": "DEMO",
"applicationId": null,
"resultMessages": [],
"paginationContext": {
"moreToCome": false,
"batchSize": 9999,
"batchSizeLimit": 9999,
"recordIdentity": "0",
"totalNoOfRecords": 1
}
},
"choreDetailsVOList": [
{
"choreStatus": "A",
"endDate": "2018-02-28",
"dueDate": "2018-02-28",
"description": "Test task",
"rewardAmount": "100.0",
"choreFrequency": "ONCE_OFF",
"choreType": null,
"startDate": "2018-02-16",
"adultIdNumber": "XXXXXXXXXXXXXXXX",
"childIdNumber": "YYYYYYYYYYYYYYYY",
"linkedChores": null,
"choreId": "302"
}
]
}
}

After ‘Complete JSON Response’ this JSON:

{
"payHeader": {
"resId": null,
"resCde": "0000",
"resMsg": "success",
"serVer": "2.0",
"expTrace": null
},
"payData": {
"op_gsn": "Test.com",
"op_status": "00000",
"op_msg": null,
"getChoresAssignedResponse": {
"choreDetailsVOList": [{
"choreStatus": "A",
"endDate": "2018-02-28",
"dueDate": "2018-02-28",
"description": "Test task",
"rewardAmount": "100.0",
"choreFrequency": "ONCE_OFF",
"choreType": null,
"startDate": "2018-02-16",
"adultIdNumber": "XXXXXXXXXXXXXXXX",
"childIdNumber": "YYYYYYYYYYYYYYYY",
"linkedChores": null,
"choreId": "302"
}]
}
}
}

5

any reponse on my request?

6

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.