We would like a query which shows the following information:
Summary the call was logged with
Summary the call was closed with
Who closed the call
We will prompt the user for a specific date.
My issue is that I have tried creating said quesry on the incident module which doesnt show me the closure information there is a relationship between the incident and closure module but for some reason the summary information doesnt pull through.
I have then tried creating the query on the closure module which brings back all the information I would like but it doesnt show the calls which are close on creation. I have tried adding the close on creation equals true into the criteria but this doesnt bring them all back.
Has anyone else had a similar issue which they have managed to resolve any help would be appriciated.