Drill Through - footer conditions in query

Options
Previous Member
Previous Member
5 Up Votes First Comment 5 Likes First Anniversary
edited February 2018 in Idea Exchange

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.

6
6 votes

Archived · Last Updated

Comments

  • Audrey Nobles
    Audrey Nobles Active Partner
    First Anniversary Level 200: Leveraging Board for Business Insights Level 100: Foundations of Building in Board First Answer
    Options

    I would also find this extremely helpful, running into issues applying order by in a drillthrough. Was this ever implemented / is there any known workaround?

Categories