Search Formula Character Limits
Search formulas have character limits for text manipulation and regular expression patterns. Text values exceeding 4,000 characters can return an Unexpected Error. Regular expression patterns exceeding 512 characters result in a FORMULA_ERROR.
4,000-Character Formula Text Limit
Searches that manipulate text area fields containing large amounts of text return an Unexpected Error when the manipulated values exceed 4,000 characters. Truncate the string before manipulating it to avoid this error.
The following search returns an error when the combined values of the message and case details fields exceed 4,000 characters.
nx.crud.select('task', true, 'formulatext:substr({message}||{case.custevent_nx_case_details},1,1000)')
The following search works because it truncates each field before concatenating the values.
nx.crud.select('task', true, 'formulatext:substr({message},1,1000)||substr({case.custevent_nx_case_details},1,1000)')
512-Character Regular Expression Pattern Limit
Regular expression patterns used in search formulas have a 512-character limit. A pattern that exceeds this limit results in a FORMULA_ERROR.
For more information, see REGEXP_LIKE in the Oracle Database SQL Reference.