Skip to main content
R
RH_99820918-Gravel
8-Gravel
August 29, 2022
Solved

[Reports] Select top 50 Rows

  • August 29, 2022
  • 2 replies
  • 1042 views

Hello,

 

i need to create a report that selects only the top 50 rows of a report. 

I couldn´t find a statement equals to the "SELECT TOP" SQL. 

Could anyone explain how i an do that in the query builder?

 

Greetings!

Best answer by HelesicPetr

@RH_9982091 

I haven't found any solution to do so in query builder. 

The SQL option TOP is missed from the builder UI in a select. 

 

as @MikeLockwood mentioned. you can only set the limit of tables

 

PetrH 

2 replies

M
22-Sapphire I
MikeLockwood22-Sapphire I
22-Sapphire I
August 29, 2022

This is a good question.

Query builder returns 2000 values by default, then waits for the user to select Next if desired.

That's due to this preference - which every user can set to desired value.

MikeLockwood_0-1661790010739.png

Don't see a way to override this preference for a specific report, but possibly others will know how to do so using a custom input.

 

Or, possibly there is a way to programmatically change this preference value every time the report is run, then change it back.

 

Or... possibly the report can be save, then a data monitor set up and that data monitor run daily but as a dummy user who has this preference set to 50.

 

 

HelesicPetr
22-Sapphire II
HelesicPetr22-Sapphire IIAnswer
22-Sapphire II
September 15, 2022

@RH_9982091 

I haven't found any solution to do so in query builder. 

The SQL option TOP is missed from the builder UI in a select. 

 

as @MikeLockwood mentioned. you can only set the limit of tables

 

PetrH 

    Terms & ConditionsCookie settingsAccessibility statement