Status filter（状态筛选器（Status filter））¶
A specific type of object set filter that takes as input object sets which have start date/time and end date/time properties as well as a time range. The status filter returns a filtered set of events that were open or closed during a given date range. This object set is useful when you do not want to define logic based on when the start date or event date occurred, but would rather have the start and end dates define a period for a certain status (such as being open or closed over a certain time period).
- Objects open during the specified date range include:
- Objects opened before the date range and closedafter the date range.
- Objects opened during the date range and closedafter the date range.
- Objects closed during the specified date range include:
- Objects opened before the date range and closedduring the date range.
- Objects opened during the date range and closedduring the date range.
- This does not include objects closed before thestart of the date range.
Input type¶
Object set, time range
Output type¶
Object set
Examples¶
In the example below, we used the status filter toreturn the set of stock events that were open during the year 2017.
Usage information¶
| Functionality | Availability |
|---|---|
| Standard Quiver card | Supported |
| Transform table transform | Unsupported |
中文翻译¶
状态筛选器（Status filter）¶
一种特定类型的对象集筛选器，其输入为具有开始日期/时间和结束日期/时间属性的对象集，以及一个时间范围。状态筛选器返回在指定日期范围内处于开启或关闭状态的事件筛选集。当您不希望根据开始日期或事件发生日期来定义逻辑，而是希望用开始和结束日期来定义某个状态（例如在特定时间段内处于开启或关闭状态）的周期时，此对象集非常有用。
- 在指定日期范围内处于开启状态的对象包括：
- 在日期范围之前开启，并在日期范围之后关闭的对象。
- 在日期范围期间开启，并在日期范围之后关闭的对象。
- 在指定日期范围内处于关闭状态的对象包括：
- 在日期范围之前开启，并在日期范围期间关闭的对象。
- 在日期范围期间开启，并在日期范围期间关闭的对象。
- 这不包括在日期范围开始之前已关闭的对象。
输入类型¶
对象集（Object set），时间范围（Time range）
输出类型¶
对象集（Object set）
示例¶
在以下示例中，我们使用状态筛选器返回在2017年期间处于开启状态的股票事件集。
使用信息¶
| 功能 | 可用性 |
|---|---|
| 标准 Quiver 卡片 | 支持 |
| 转换表转换 | 不支持 |