Collection hooks property filter doesn't work with complex objects

[yug1991]

Describe the bug
When I pass an object as value for a table component column, property filter (or free text filter) doesn't work properly. I can write a query like Data = [object Object] to see all rows. The bug is rooted in filterUsingOperator method in collection-hooks/dist/cjs/operations/property-filter.js
return (itemValue + '').toLowerCase().indexOf((tokenValue + '').toLowerCase()) > -1; where {} + '' => '[object Object]'.

Should have used JSON.stringify() instead of string concatenation.

To Reproduce
Create a table with filter, pass { a: 1 } as value for a column. Try search for this row.

Reproduction link
See screenshots below

Expected behavior
Filter should work with non-string objects.

Screenshots

Environment (please complete the following information):
n/a

Additional context
n/a

[gethinwebster]

This limitation is by design - the UX flows for the Property Filter were only designed with simple values in mind, and we would need to revisit those to ensure a good user experience for dealing with complex values. So I'm adding the enhancement label, and will add this to our internal backlog for consideration as a feature request.

Note that you can also override this behavior by passing a custom propertyFiltering.filteringFunction (of type (item: T, query: Query) => boolean) to useCollection.

[yug1991]

Sounds good. I see 2 workarounds in the meantime:

1. Serialize complex object before passing it into useCollection hook, so filter works, and convert string back to complex object in Table, etc. for rendering.
2. Create my own hook which provides a filteringFunction that supports complex objects

   function useMyCollection (items, options) {
     options.propertyFiltering.filteringFunction = myfilteringFunction
     return useCollection(items, options)
   }

   and essentially copy & paste defaultFilteringFunction in property-filter.js and change itemValue + '' to JSON.stringify(itemValue).