How to limit search results on Web.Instance.Search

when managing asset instances, it is possible to encounter tens of thousands of rows as the number of rows increases, the load time on instance pages in activate may be adversely affected to mitigate this, consider reducing the initial load to the first 100 rows this can be achieved in activate by adding the top clause to the query in the web instance search parameter steps open the web instance search parameter in text mode modify the query node of the web form and add top 100 as the first clause in the query each query returned will now only return the top 100 results it's also possible to add a control to make the desired row count selectable, an example of how to achieve this is attached