Table filters for custom columns

Queries and Resources
1

When I define custom columns in a table I am not able to filter on those columns, the where drop down does not list any of the custom columns I defined. Am I doing something wrong? Is filtering on custom columns supported?

2 Likes
2

Hey there @pjc714! Unfortunately we don’t support table filters on custom columns quite yet :frowning:

3

Thanks for your reply Justin :smiley: :+1:

1 Like
4

Hey any update on this? When will support for table filters on custom columns be added?

5

Hi @Irfan Not yet, but it is on the roadmap. It's hard to estimate a timeline on this since it is contingent on a related bug fix, but I'll post on this thread when we ship a fix

7

Hi @Tess, has this been implemented yet? Can u suggest a workaround if not? If I want a user to be able to filter using a custom column, can I set up some sort of form with an equivalent query to filter a table?

8

For what its worth you can use a transformation first to get the data in exactly the right shape, which might make it so you don't need a custom field. This worked for us. Here's a function you can use to flatten an object with nested values (which is why we needed custom columns):

const flattenObject = (obj, keyPrefix) => {
  const flattened = {};

  Object.keys(obj).forEach((key) => {
    const value = obj[key];

    if (typeof value === "object" && value !== null && !Array.isArray(value)) {
      Object.assign(flattened, flattenObject(value, key));
    } else {
      const newKey = keyPrefix + key;
      flattened[newKey] = value;
    }
  });
  return flattened;
};
9

I've also written up a workaround in this thread in case it's helpful for anyone! :slight_smile:

1 Like