Query Library Count

In the Query Library, when you're testing your queries, it will return the data, what time it ran and for how long.

What would be really really useful is if as well as the data, it told you how many records were returned in total anywhere on that screen.

Why? When you're joining tables, it's a very simple way of knowing that you've done the query correctly.

2 Likes

Hi @Ross_Coombes, thanks for the feedback. While this isn't possible at this time, I'd recommend using the COUNT() function for testing.

Hi thanks Abbey, yeah that is what I do for SELECT queries.

Would also be a lot more reassuring if UPDATE and DELETE queries told you how many rows were affected as well, currently that's a bit of hope for the best type situation.

1 Like