I want my search results should display in below format:
From above image we can see that, I have searched drilling and I am getting matching results. And here all the data for one single submitted ticket is merged in one single result.
For example when we submit any ticket, entry goes to various database tables. I have indexed all that table using different sql queries. So when I search anything about submitted ticket it should give me single result. As data for that submitted ticket is not present in one table, currently I am getting more than one results for that submitted ticket. To avoid that, what I can do? Should I change my sql query or it can be handled in any other way? Kindly guide.