Agent Desktop

Get Involved. Join the Conversation.

Topic

    Chethana KM
    Global ind and Replace Export to Excel
    Topic posted September 30, 2019 by Chethana KMRed Ribbon: 250+ Points, tagged Service Console 
    15 Views, 1 Comment
    Title:
    Global ind and Replace Export to Excel
    Summary:
    To convert the field value to hyperlink within the generated excel sheet of Global Find and Replace
    Content:

    Hi,

    Under Service->Knowledge Base->Authoring menu, we have Global Find and Replace feature under Tools tab. Now, when we find and Replace with some keyword using this feature, we have the option of exporting the results to excel using "Export document list to Excel" option. When we open the Excel sheet, we have the columns:

    Content Type ID Master Identifier Version Status Workflow

    In the above listed columns, the ID field displays the document Id. But, the requirement we have is that we want the "ID" field to be a hyperlink to the article. 

    Is there anyway, we can convert the "ID" field to answer hyperlink (link to answer), even before generating the excel sheet? so that the users can open the generated excel sheet and click on the document Id (ID field) to open the answer. Please advise.

    Thanks,

    Chethana

    Version:
    18D
    Image:
    Document:

    Comment