Ok, but we need to be focused here on the current objective.
You need to create a view that is going to return the desired data. To do that, you need to identify what the data is that needs to be returned. If your current view is returning the correct data, great! We can move forward from there. If the current view is not returning the correct data, then we need to fix that.