Get a limited number of lines
Hi,
I would like to understand if it is possible to obtain, in some way, a limited number of rows in the result.
Daniele
Replies 4
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-
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
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-