Drill Through - footer conditions in query

Idea created by pyurpaul on Feb 21, 2018
    Open for voting
    Score7
    • auron956
    • snanayakkara
    • Bob Gill
    • breuber
    • pyurpaul
    • jason.febo
    • mads_meissner

    For now its possible to define 'Where' conditions only.

     

    It would be helpful to define footer conditions too. Examples:

     

    GROUP BY

    ORDER BY

    LIMIT

    FETCH FIRST X rows only

    ...

     

    Applicationexample:

     

    Our users can do a drill through on P&L Lines and can get all booking details --> its a large table in datawarehouse.

    In some cases the server is getting down, because of heavy requisitions. To prevent this, i want to add a LIMIT in the drill through settings in board, so I do not have to change anything in the datawarehouse tables / views.