Workflow: Search Records "where Id is <UUID>" Returns All Records

[AndrewBucklin]

Bug Description

When using the Search Records action within a Workflow, filtering a record by its primary Id using the "Is" operator (Where Id Is [UUID]) does not work as expected. Instead of returning the single object with the provided UUID, the action returns all records for that object type, respecting only the Limit parameter.

Expected behavior

The Search Records action, when filtering by Id Is [UUID], should return only the single record that precisely matches the provided UUID.

Steps to Reproduce

1. Create a new Workflow.
2. As a step, add the Search Records action.
3. Select any object (e.g., "Companies").
4. Under "Conditions", create a filter rule: Where Id Is [Paste a valid UUID for a record in that object].
5. Set the Limit to 10000.
6. Run the workflow and observe the output. The action will return all records from the object, not necessarily the one matching the specified ID.

Technical inputs

Based on a discussion in the community Discord (link), it appears there may be a mismatch between the workflow UI's filter implementation and the backend API's expectation.

• The "Is" operator in the UI may be translating to a comparator that is not correctly processed by the API for UUID fields.
• It was suggested that the backend API likely expects an eq (equals) comparator for this type of query, whereas the UI might be sending a different, less strict operator. This causes the filter condition on the Id field to be ignored, resulting in a query for all records.