Virtual field breaks searching

[wszerad]

Link to reproduction

No response

Environment Info

Payload: v3.0.0-beta.110

Describe the Bug

Virtual field is used as search column which causes errors when searching in collection. Additionally, if such a field is used as "useAsTitle", it spoils the relationship search here: UI/Relationship

Reproduction Steps

Create collection like this:

{
  slug: 'students',
  admin: {
    useAsTitle: 'fullName',
  },
  fields: [
    {
      name: 'firstName',
      type: 'text',
    },
    {
      name: 'lastName',
      type: 'text',
    },
    {
      name: 'fullName',
      type: 'text',
      virtual: true,
      hooks: {
        afterRead: [
          (args) => {
            const { firstName, lastName } = args.siblingData
            return `${firstName} ${lastName}`
          }
        ]
      }
    },
  ],
}

Now searching in collection search is broken.

Adapters and Plugins

No response

[r1tsuu]

Virtual fields aren't supposed to search by them. This PR https://github.com/payloadcms/payload/pull/8541 removes a field from the search list if it's virtual and used as useAsTtile. Don't use virtual: true, if you care about filtering by it. And instead of afterRead you can use beforeChange.

[github-actions[bot]]

This issue has been automatically locked. Please open a new issue if this issue persists with any additional detail.

[github-actions[bot]]

🚀 This is included in version v3.0.0-beta.113

[github-actions[bot]]

This issue has been automatically locked. Please open a new issue if this issue persists with any additional detail.