Workflow - SEARCH node returns a maximum of 200 records

[StephanieJoly4]

Bug Description

The search actions return a maximum of 200 records. export const QUERY_MAX_RECORDS = 200;
However, there is nothing to inform the user of this
-> we either need to wave this condition or inform users that this is happening.
Ideas: hard code a limit to 200 and prevent users from increasing this number (or any better options).
We discussed it live and @martmull mentioned this limit could be raised to 10k.

Other item to check while we're in this topic. I believe @thomtrp told me there is a limit in the # of records that can be selected with the Global / Bulk / Single manual trigger. But this information is not given to users which could lead to the same issues.

[martmull]

I think we should think about executing iterators by batch. Most of the time iterator step does not used previous step results. So in that case we could execute by batch of like 20 or 50 items
See this conv for context -> https://discord.com/channels/1130383047699738754/1436338694029180998