oneOf filter support for user search - Can only search by string.email or equal._id

[andyburgessmd]

Checklist

• I have searched budibase discussions and github issues to check if my issue already exists

Hosting

• Self
  • Method: docker
  • Budibase Version: 2.21.5
  • App Version: 2.21.5

Describe the bug The application is shows the alert notification "Can only search by string.email or equal._id" And this in the console

This is intermittent and doesn't happen on every request.

To Reproduce Steps to reproduce the behavior: I've not been able to work out what is causing this yet to be able to provide replication steps. But will keep trying to diagnose what is specific.

[linear[bot]]

BUDI-8086 "Can only search by string.email or equal._id"

[andyburgessmd]

I think this is showing when a dataprovider (or in a block) has a filter that is filtering on a user table/relationship.

[andz-bb]

@andyburgessmd if this happens to you again could you please share the request payload? looks like something isn't right there and it would help us to investigate - thanks!

[andyburgessmd]

@andz-bb Yes, its still happening. The payload is {"query":{"oneOf":{"_id":["us_e80d550f8a944cc59eae0ab558b6757f"]}},"paginate":true,"limit":100}

[ConorWebb96]

Hey @andyburgessmd,

Does this happen when you are using the User column in conjunction with a form block? I think I've got a solid recreate. Will post it below, this seems to only affect the builder and doesn't affect the published or previewed apps.

block user test-export-1710317648727.tar.gz

[andyburgessmd]

@ConorWebb96 I've stripped a duplicate one of the pages that is showing the error back to try and figure out what is causing it. It now just has a table block Using data from internal table called Components with structure There is a relationship to the User table, another table called Templates and another called Environment, the formula field is static using the name field from the Environment relationship. There isn't a separate form block but the table block does use details side panel and the button uses a new row side block.

I get the error in the builder view, the preview and published apps.

[andyburgessmd]

@ConorWebb96 any progress on this? Still getting the error shown in 2.22.5