Forum Discussion

Sergey's avatar
Sergey
Contributor III
3 years ago
Solved

Drill Back - Issue with drill to file share, only a message "Querying Source System" appears

Hi !

I am trying to use a Drill Back option in my Data Connector.

So far, I get the data from my connector in the staging area, which is great. Now I am trying to open an invoice document, which is stored noth in FileShare, or in Application Database for test purposes.

However, even though I get the drill back types name, when trying to open the PDF file I only get the message "querying source system" and then nothing happen!

Do you know of any reason why ? I thought it was a simple business rule ...

 

Regards,

  • Hi Sergey,

    If you take a look at the snippet editor (comes with golfstream but also avialable from the marketplace), you can find the Revenue Management example listed under Snippets > SQL Connector > General > Standard SQL Connector. It shows a good example of how to drill back to a file.

    It is important to set the display type and document path like so

    • Dim drillBackInfo As New DrillBackResultInfo
    • drillBackInfo.DisplayType = ConnectorDrillBackDisplayTypes.FileShareFile
    • drillBackInfo.DocumentPath = your path
    • Return drillBackInfo

    Hope this helps,

    Jaimie