Active Query Builder support area

Get a limited number of lines

Avatar
  • updated
  • Completed

Hi,

I would like to understand if it is possible to obtain, in some way, a limited number of rows in the result.

 

Daniele

Avatar
Andrey Zavyalov, PM

Hello, Daniele.

Yes, it is possible via the Query Properties sidebar in all of the .NET versions of Active Query Builder:

WinForms/WPF:

https://www.activequerybuilder.com/scr/winforms/panels.png

ASP.NET:

https://www.activequerybuilder.com/scr/asp/aspnet-30.png

To display this bar, click on the Design Pane background and then "Properties" tab at the right of it. 

Note that propeties displayed on this tab vary depending on the syntax provider being used.

If you want to add row limitation clause seamlessly for the end-user, you must use the QueryTransformer API which is described here: https://support.activequerybuilder.com/hc/en-us/articles/115001063925-How-to-change-sorting-add-filters-limits-and-aggregations-to-the-query-

Avatar
Andrey Zavyalov, PM

Hello, Daniele.

Yes, it is possible via the Query Properties sidebar in all of the .NET versions of Active Query Builder:

WinForms/WPF:

https://www.activequerybuilder.com/scr/winforms/panels.png

ASP.NET:

https://www.activequerybuilder.com/scr/asp/aspnet-30.png

To display this bar, click on the Design Pane background and then "Properties" tab at the right of it. 

Note that propeties displayed on this tab vary depending on the syntax provider being used.

If you want to add row limitation clause seamlessly for the end-user, you must use the QueryTransformer API which is described here: https://support.activequerybuilder.com/hc/en-us/articles/115001063925-How-to-change-sorting-add-filters-limits-and-aggregations-to-the-query-

Avatar
Daniele

Hi Sergey,

i'm using the java version. It's possible?

 

Daniele

Avatar
Andrey Zavyalov, PM

In the Java and VCL versions, you should right-click on the Design Pane and select "Properties" or "Edit" menu item, then input the row number the TOP or LIMIT edit box. See the User's Guide for details: https://www.activequerybuilder.com/hs130.html