Okta Workflows Table Search Rows Limits on Using OR in a Where Expression
Last Updated:
Workflows
Okta Classic Engine
Okta Identity Engine
Overview
This document provides performance guidance for using the Okta Workflows Table Search Rows functionality. Specifically, whether there are any performance limitations on the number of "OR" statements that can be used with a "Where" clause. For more information on Search Rows, please refer to the product documentation.
Applies To
- Okta Classic Engine
- Okta Identity Engine (OIE)
- Workflows
- Tables
- Search Rows
Solution
The general recommendation for search rows performance is that "OR" statements should be as short as possible, ideally less than 10 and no more than 50. For other limitations, please refer to the product documentation.
