Select to filter data for a number column inside a collection using a number column from another table

Hi guys,

how can I filter a number column from a collection by comparing it to another number column from a different table ?

I see that when we choose other text columns in the filter data section, the option to select other tables and their columns is available, for number entries only the columns from the current table are available.

Also, because the source for the view is in another table, I can’t add the value to the table I use for the collection.

It will be great if we would have the possibility also for number entries to compare them with data from other tables.

So, any suggestions ?


Another option I see is to pass the value to the desired table in another column, but it doesn’t take it as a number and I can’t compare it

Really? I don’t think so. Can you show me evidence of that?

Generally, when applying filters to collections, you should have options to compare columns to:

  • other columns in the same table (the source) of the collection
  • User Profile columns (if User Profiles are configured)
  • screen columns (columns in the table the parent screen is attached to)

So if you want to filter against a column value from some other table, then you need to temporarily copy that value into a computed column in one of those 3 locations listed above.

The way you do this depends on your exact use case, but it often involves an action that sets a user specific value somewhere, which in turn gets picked up by a single value column.

1 Like