|
|||
|
|||
I am working on a standalone search engine that will return all tickets and history notes, where the search word(s) are in the ticket or history notes.
I have the ticket portion working, but I am missing tickets where the word(s) are not in the TICKETS but are in the HISTORYNOTE description. So the question is there a way to add a search with the tickets that will also search the historynotes and return the ticket result? I have a section that will then go into the historynotes and return all the historynotes for the given ticket. If not what route would you suggest? I am trying to use the API first before going down the ODBC/linkedserver route. Also trying to create the search to search for multiple words in any order within the tables (IE: if I enter "Jump new" in search it will look for tickets that contain both jump AND new in either description, resolution, or notes. So it could return "Sally has a new jumprope" or "John jumped the new truck") Quote:
Any direction would be appreciated |
|
|||
|
|||
My thoughts on this would be to maybe create two lists
-Tickets -History Notes This would give me a list of all the ticketId's of all the tickets and history notes. Then combine those two lists and return all tickets with history notes for the tickets in the combined list. Quote:
|
|
|||
|
|||
Yes, this makes sense, you should query tickets, query history notes and then based on the ticket identifier as part of the returned history notes bring the ticket details of that note. Then you can list all tickets after merging to two lists, ones that results were found as part of the ticket together with tickets that are listed because to search term was found in an history note linked to them.
Hope this helps. |
|
|||
|
|||
Yes, you can select only specific fields, for example, here is how you could fetch only two fields of accounts:
Quote:
In any case, there isn't probably much we can help with as, as you mentioned yourself, it seems to be related to coding in more general and less to RangerMSP. Maybe someone here will be able to help or maybe you can get someone working with you for a very reasonable fee on sites like eLance or oDesk. Hope this makes sense and helps. |