Reason why i cant filter by both execution status and workflowType

[dhiaayachi]

Hi, We have noticed that we cant be able to filter by both execution status and workflowtype, we are inquiring on why it is configured so. As per the test on converter_test.go line 62, ExecutionStatus = "Running" AND WorkflowType = "xyz", is part of unsupported queries. Kindly shed light on this so that it may guide us in the future.

Thanks.

[dhiaayachi]

Hi,

Thanks for reporting this. Filtering by both execution status and workflow type is currently not supported. This is because the Temporal query language is designed for efficient querying based on specific criteria. Combining these two filters can result in complex queries that might impact performance.

To achieve the desired filtering, you can explore these alternatives:

• Use Temporal's advanced filtering options: You can filter by workflow type and then filter the results by execution status using the Temporal SDK.

• Use Temporal's history events: You can use Temporal's history events to query for workflow executions that have the desired workflow type and execution status.

Let me know if you have any further questions or need further assistance.

[dhiaayachi]

Hi,

Thanks for reporting this. Currently, Temporal does not support filtering by both execution status and workflow type in a single query. The restriction is to prevent unintended query behavior, as combining these filters might result in ambiguous or unexpected results.

The documentation does not provide a specific workaround for this case. However, you could consider using two separate queries: one for execution status and another for workflow type. The results could then be combined using logic in your application to achieve the desired filtering.

We appreciate your feedback and will consider adding this feature in the future.