GETDATALINKDRILLBACKQUERY

Returns a DataLink Server detail query from a summary query. The function can be used with, for example, an Open Dialog action to display a detailed analysis of values selected in a summary report.

The DataLink Server summary query is stored in a variable, which is specified on the Settings and Preview tab of the DataLink list designer. That variable is used as the 'Original Query' argument of the function. The 'row definition values' argument of the function is the name of a list object in which the original query is displayed, or the cell reference of that list object.

Typically, the function is used with an action. If you specify it in a cell, it returns #VALUE! in Design mode. In View mode, the xml definition of the detail query is displayed.

Syntax

GETDATALINKDRILLBACKQUERY("Alias","Original Query", "row definition values")