英文:
Is there a way to perform complex filters on object sets without coding a function?
问题
目前，我正在使用Quiver转换表执行筛选。然而，似乎不能在Quiver中使用转换表的结果来筛选对象集。
唯一的其他选择似乎是编写一个函数来筛选数据以生成一个新的对象集。
函数是唯一的方式吗，还是有无代码解决方案？
英文:
I would like to generate an object set from the results of a complex filter that involves aggregates and then perform an Action on that object set.
Currently, I am using Quiver transform tables to perform the filter. However, it doesn't look like you can then use the results of a transform table in Quiver to filter an object set.
The only other alternative looks to be writing a Function to filter the data to generate a new object set.
Is a function the only way or is there a no-code solution?
答案1
得分: 1
简短回答： 您可以通过将转换表（TT）中的一列减少为数组来实现此操作，然后可以使用该数组来筛选对象集合（OSF）。
详细信息：
- 从您的输入对象集合（OSI）开始。
- 添加一个转换表（TT）。添加您想要的任何转换和筛选逻辑。
- 选择TT，在选择该板时在下面出现的“转换”菜单下，选择“将转换表列值”板之一。选择适合您要用于筛选对象集合的数据类型的选项。结果将是一个值的单一数组。
- 选择OSI并添加一个筛选板。选择要进行筛选的属性（例如，“...其中某个属性是”）。而不是输入静态值，请点击类型选择器并选择您在前一步中创建的数组。现在您将拥有您筛选后的对象集合（OSF）。
英文:
Short answer: You can do this by reducing a column in the Transform Table (TT) into an array, which can then be used to filter the Object Set (OSF).
Details:
- Start with your input object set (OSI)
- Add a Transform Table (TT). Add whatever transformation and filter logic you want.
- With the TT selected, under the "Convert" menu that appears below a board when you select that board, choose one of the "Transform table column values" boards. Pick the right one for the data type you're going to use to filter the object set. The result will be a single array of values.
- Select OSI and add a Filter board. Pick the property you want to filter on (e.g. "...where someProperty is"). Instead of inputting a static value, click on the type selector and choose the array you created in the previous step. Now you'll have your filtered object set (OSF).
通过集体智慧和协作来改善编程学习和解决问题的方式。致力于成为全球开发者共同参与的知识库，让每个人都能够通过互相帮助和分享经验来进步。
评论