# Group by Request , Respponse and Message

**URL:** <https://discuss.elastic.co/t/group-by-request-respponse-and-message/123864>\
**Category:** Elasticsearch\
**Created:** [March 14, 2018, 9:04am UTC](https://discuss.elastic.co/t/group-by-request-respponse-and-message/123864 "2018-03-14T09:04:51Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![mbvelo](https://avatars.discourse-cdn.com/v4/letter/m/59ef9b/32.png) [@mbvelo](https://discuss.elastic.co/u/mbvelo)\
**Post date:** [March 14, 2018, 9:04am UTC](https://discuss.elastic.co/t/group-by-request-respponse-and-message/123864/1 "2018-03-14T09:04:51Z")

</div>

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?

---

<div class="post-metadata">

**Author:** ![jpountz](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/jpountz/32/45836_2.png) [@jpountz](https://discuss.elastic.co/u/jpountz)\
**Post date:** [March 14, 2018, 10:02am UTC](https://discuss.elastic.co/t/group-by-request-respponse-and-message/123864/2 "2018-03-14T10:02:07Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![mbvelo](https://avatars.discourse-cdn.com/v4/letter/m/59ef9b/32.png) [@mbvelo](https://discuss.elastic.co/u/mbvelo)\
**Post date:** [March 14, 2018, 10:13am UTC](https://discuss.elastic.co/t/group-by-request-respponse-and-message/123864/4 "2018-03-14T10:13:09Z")

</div>

In `Preformatted text`support 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](http://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"  
}]  
}  
}  
}

---

<div class="post-metadata">

**Author:** ![mbvelo](https://avatars.discourse-cdn.com/v4/letter/m/59ef9b/32.png) [@mbvelo](https://discuss.elastic.co/u/mbvelo)\
**Post date:** [April 5, 2018, 9:30am UTC](https://discuss.elastic.co/t/group-by-request-respponse-and-message/123864/5 "2018-04-05T09:30:13Z")

</div>

any reponse on my request?

---

<div class="post-metadata">

**Author:** ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)\
**Post date:** [May 3, 2018, 9:30am UTC](https://discuss.elastic.co/t/group-by-request-respponse-and-message/123864/6 "2018-05-03T09:30:18Z")

</div>

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