Conflicting `length` for resource result

[dguzzo]

1. My goal: Understand the true length of the result of a RetoolDB resource response.
2. Issue: The hover value of the resource is showing 50 instead of the block's data output pane as well as the value of logging it to the console.
3. Steps I've taken to troubleshoot: Reloaded the page.
4. Additional info: (Cloud or Self-hosted, Screenshots)

I have a RetoolDB resource query in a new Workflow. The result of the query yields an array of length 386:

However, when I hover over getOldEntries.data?.length in subsequent, connected blocks the value for it shows 50.

And via the hovering the resource name itself showing the inspector:

This is suspicious because 50 tends to be a common page-size value, but there's no pagination here that I'm aware of. But the more troubling aspect is just the flat-out contradiction of the block's data response and logging it to console vs the hover & inspect.

So, it seems like it's just a UI bug, and the actual value of the resource's data is correct at 386. This is my hope! If so, it's still quite confusing.

For good measure, the JSON pane shows the same 386, and there are no pagination or obvious limits in Settings:

[Tess]

Hey @dguzzo,

Thanks for the detailed report! I've run into this and agree, it is confusing

It happens because we limit to showing the first 50 elements in the tooltip. Technically, it is to help with performance, in case the output is too large, but maybe there is some better way for us to convey it is a preview of the data so that folks don't rely on that number or spend too much time troubleshooting it. I'll put in a request to the Workflows team

[dguzzo]

Thanks for the explanation and request, Tess!

Yeah, if there were a way for Retool to just add [truncated] or similar to the 50 preview that'd go a long way in preventing confusion.