Great screenshots! They definitely helped to understand what you're asking.
Here's the nuance:
- Subject is combined into the Request field on the ticket Basic Search.
- Similarly, Subject appears in the Request Detail column when updating your column set.
- The Subject is actually the bold text that appears before the actual request detail.
If you need to search tickets exclusive of text in the actual Request Detail field of the ticket, you should use the Advanced Search function and use the Subject parameter. I hope this helps! Please let me know if you have any questions or concerns.
The reason I would like to have the Subject field listed is because of the Export functionality.
This morning i noticed by just adding and removing a few other columns and then Exporting, I know do get the "Subject" exported as a separate column. See below:
So, that problem is for now resolved.
However, I do have another weird issue that you may be able to assist with:
I have created a few Custom fields.
When I add them to the Search window as viewable columns, no problem. When I export to the TSV file, all the various Columns are exported and separated by tabs except the Custom Field names. I mention names because the actual values of the fields are correctly exported and separated by tabs.
What do you think I should do?
I'm glad that we got the first conundrum resolved!
Your second issue is definitely perplexing and I cannot replicate it. When I export ticket data to .tsv and open it in Excel, the integrity of the custom field data is maintained in the row/column layout.
WHD build 12.3.0 - #18.104.22.1684-HF3-703
Tested in Excel 2016
Perhaps try opening the file in Sheets or another spreadsheet application and see if the issue is maintained. There may be an issue with the .tsv that is being output by WHD. If you have SQL access, you could always query the data directly without using the .tsv export function. My apologies that there's not an easier answer...but do know that this functionality should normally work. As such, a ticket to SolarWinds may be in your best interest! Good luck -
I do have mySQL, but not clever enough to know how to export from the various tables and keeping the various fields linked.
Anyways, Ill play around a bit more and see if I can figure this out.
Thank's for your all your help!