If a job/pipeline name contains any regex metacharacters then the query will return no data even though the user is entering the exact name of the job/pipeline.
Would need to implement a UDF to escape characters on behalf of user or add a simple OR statement to do a direct comparison with = operator.
From https://www.w3schools.com/python/gloss_python_regex_metacharacters.asp:
Character | Description | Example
-- | -- | -- | --
[] | A set of characters | "[a-m]"
\ | Signals a special sequence (can also be used to escape special characters) | "\d"
. | Any character (except newline character) | "he..o"
^ | Starts with | "^hello"
$ | Ends with | "planet$"
- | Zero or more occurrences | "he.*o"
- | One or more occurrences | "he.+o"
? | Zero or one occurrence | "he.?o"
{} | Exactly the specified number of occurrences | "he.{2}o"
| | Either or | "falls|stays"
() | Capture and group |
If a job/pipeline name contains any regex metacharacters then the query will return no data even though the user is entering the exact name of the job/pipeline.
Would need to implement a UDF to escape characters on behalf of user or add a simple OR statement to do a direct comparison with = operator.
From https://www.w3schools.com/python/gloss_python_regex_metacharacters.asp:
Character | Description | Example
-- | -- | -- | --
[] | A set of characters | "[a-m]"
\ | Signals a special sequence (can also be used to escape special characters) | "\d"
. | Any character (except newline character) | "he..o"
^ | Starts with | "^hello"
$ | Ends with | "planet$"
? | Zero or one occurrence | "he.?o"
{} | Exactly the specified number of occurrences | "he.{2}o"
| | Either or | "falls|stays"
() | Capture and group |