Show the number of records obtained with the query in the preview
1088
Views
8
Comments
On our RadarOn our Radar
Aggregates & Queries

Show in the previous result, the number of records returned by the query when using the test variables.


As shown when testing with SQL.


It would help to verify that the query logic is running as expected.

Merged this idea with 'Show record count in Aggregate preview' (created on 09 Jan 2021 03:25:04 by Leandro Oliveira)

It would be nice if aggregate's preview displayed a count information like "Showing 30 of 1000 records. Remaining results truncated."


A new preference could control wheter or not it execute the count:


Leandro Rodrigues



This comment was:
- originally posted on idea 'Show record count in Aggregate preview' (created on 09 Jan 2021 by Leandro Oliveira)
- merged to idea ' Show the number of records obtained with the query in the preview' on 12 Jan 2021 09:31:59 by Ângela Dinis

This idea will help to show all the counts upfront, instead of querying the DB..



This comment was:
- originally posted on idea 'Show record count in Aggregate preview' (created on 09 Jan 2021 by Leandro Oliveira)
- merged to idea ' Show the number of records obtained with the query in the preview' on 12 Jan 2021 09:31:59 by Ângela Dinis
Merged this idea with 'Record count in Aggregates' (created on 13 Nov 2014 12:06:56 by Hélio Cardoso)

This comment was:
- originally posted on idea 'Show record count in Aggregate preview' (created on 09 Jan 2021 by Leandro Oliveira)
- merged to idea ' Show the number of records obtained with the query in the preview' on 12 Jan 2021 09:31:59 by Ângela Dinis
2015-12-21 12-13-48
Hélio Cardoso
This use case if for a developer persona.

While developing it will be must usefull to have a total record count when opening an aggregate. It will avoid mistakes and ensures that the developer has more information available from the start.


This comment was:
- originally posted on idea 'Record count in Aggregates' (created on 13 Nov 2014 by Hélio Cardoso)
- merged to idea 'Show record count in Aggregate preview' on 11 Jan 2021 09:32:37 by Ângela Dinis


This comment was:
- originally posted on idea 'Show record count in Aggregate preview' (created on 09 Jan 2021 by Leandro Oliveira)
- merged to idea ' Show the number of records obtained with the query in the preview' on 12 Jan 2021 09:31:59 by Ângela Dinis
Changed the category to
Aggregates & Queries
and the status to
On our RadarOn our radar

Hi Leandro!

Thank you so much for your idea! I've marked it as on our radar, so we can continue to keep an eye on it.

Happy new year,

Ângela



This comment was:
- originally posted on idea 'Show record count in Aggregate preview' (created on 09 Jan 2021 by Leandro Oliveira)
- merged to idea ' Show the number of records obtained with the query in the preview' on 12 Jan 2021 09:31:59 by Ângela Dinis

Great idea Leandro!

I believe that the following idea is similar to what was suggested:

https://www.outsystems.com/ideas/8139/show-the-number-of-records-obtained-with-the-query-in-the-preview



This comment was:
- originally posted on idea 'Show record count in Aggregate preview' (created on 09 Jan 2021 by Leandro Oliveira)
- merged to idea ' Show the number of records obtained with the query in the preview' on 12 Jan 2021 09:31:59 by Ângela Dinis
Changed the category to
Aggregates & Queries
and the status to
On our RadarOn our radar

Thank you for your idea, Eduardo.

Happy 2021!