1
 Follower
6
 Likes

View Data - Add configurable number of rows returned in Service Studio preferences

Aggregates & Queries
On our radar

Similar to how you can go under Edit > Preferences in Service Studio to configure the amount of returned rows when executing a test query.


I would like to also be able to configure the amount of rows returns when using the 'View Data' option on a table.

Created on 13 Jun 2018
Comments (12)

Even better: show this in the "View Data" itself, so you don't need to go through a million clicks to get to it, and have it be for just that "View Data" window.

J.Ja

Changed the category to Backend


Hi Justin,

Thank for this feedback.


Do you think the value you configure on Edit > Preferences should be reflected on Advance Queries and Aggregates? Also that value should be able to be editable for each Advance Query and Aggregate on the fly?


Thanks,

Yes, and yes! :)

J.Ja

Both would be great additions.

Changed the status to
On our radar


Thanks for your feedback is something that are looking at it. It's on our radar at the moment and will try to include on a future version.

Changed the category to Aggregates & Queries


Merged this idea with 'Use "Returned Rows Limit" on Aggregate Data Preview' (created on 13 Nov 2018 16:21:59 by Rebecca Hall)

It seems that aggregates randomly pick a top count and you can't always see enough data on the preview for testing.  It would be nice if it used the same Returned Row Limit like with Advanced queries.



This comment was:
- originally posted on idea 'Use "Returned Rows Limit" on Aggregate Data Preview' (created on 13 Nov 2018 by Rebecca Hall)
- merged to idea 'View Data - Add configurable number of rows returned in Service Studio preferences' on 31 Dec 2018 12:13:48 by Vasco Pessanha

Nice suggestion !!

But I have some thoughts about it:

* How to handle a timeout / loss of user experience in Outsystems Studio if you retrieve 10000 records?
* How to handle the Service Studio memory consumption, because that is already high in my experience and with all the nice, new, intelligent solutions they are creating can put more stress on the system?



This comment was:
- originally posted on idea 'Use "Returned Rows Limit" on Aggregate Data Preview' (created on 13 Nov 2018 by Rebecca Hall)
- merged to idea 'View Data - Add configurable number of rows returned in Service Studio preferences' on 31 Dec 2018 12:13:48 by Vasco Pessanha

Same idea as: https://www.outsystems.com/ideas/4932/view-data-add-configurable-number-of-rows-returned-in-service-studio-preference



This comment was:
- originally posted on idea 'Use "Returned Rows Limit" on Aggregate Data Preview' (created on 13 Nov 2018 by Rebecca Hall)
- merged to idea 'View Data - Add configurable number of rows returned in Service Studio preferences' on 31 Dec 2018 12:13:48 by Vasco Pessanha

Changed the category to Aggregates & Queries




This comment was:
- originally posted on idea 'Use "Returned Rows Limit" on Aggregate Data Preview' (created on 13 Nov 2018 by Rebecca Hall)
- merged to idea 'View Data - Add configurable number of rows returned in Service Studio preferences' on 31 Dec 2018 12:13:48 by Vasco Pessanha
views
387
Followers
1