job_title). See Request Information why
data.precedes each Request variable in each example.
LOWERFunction to Disregard Case Sensitivity in Strings and Request Variables
lowerfunction to disregard case-sensitivity evaluation by lower-casing strings and Request variable names. The
lowerfunction is useful for when you are unsure of the case sensitivity of the comparing string or Request variable name.
RequestVariableis the Request variable name
lower(data.job_title) LIKE "prod%" OR lower(data.job_title) LIKE "proj%"
LIKEare not case-sensitive. PMQL operators are capitalized in this document for easier readability.
data.last_name = "Canera"
LIKEOperator for Wildcard Pattern Matching
LIKEoperator, then include wildcards
_within the quotation marks (
") of your search parameter.
%wildcard represents zero, one, or more characters. The
_wildcard represents exactly one character.
request LIKE "P%"finds Requests associated with all Processes that begin with
status LIKE "c%"finds Requests with both Completed and Canceled statuses.
data.last_name LIKE "Ca%"finds all values from Requests that begin with
data.last_name LIKE "Ca___"finds all values from Requests that begin with
Caand those that match three following characters in the
task LIKE "T%"finds all Tasks that begin with
LIKEoperator with the
%wildcard to find text in a specified JSON array within Request data. Consider the following JSON array in Request data that contains two JSON objects. Each JSON object contains the first name, last name, and email address.
company. PMQL finds the string
companyregardless of what string precedes or follows the sought pattern because the
%wildcard disregards all content in the JSON array preceding and following that pattern.
NOT INOperators for Array Values
(status IN ["Completed", "Error"]) AND data.date NOT IN ["2021-07-01", "2021-05-01"]
(status IN ["Completed", "Error"]) AND data.date IN ["2021-07-01", "2021-05-01"]
Melissa. The last modified is equal or major to
participant IN ["admin", "Melissa"] AND status NOT IN ["Completed", "In Progress"] AND modified >= "2020-07-01 00:00:00"
CASTFunction to Convert Data Types
CASTfunction is a standard SQL syntax that PMQL supports for specific data types.
CASTfunction converts data from one data type to another. PMQL supports the
CASTfunction for the following data types:
2), convert that value to text ("2").
2). For example, use the
CASTfunction in a PMQL query to perform a numerical comparison to the
ExperienceRequest variable that stores a job candidate's experience in an industry to find job candidates with two (2) years of experience or greater, use the following PMQL query:
CAST(data.Experience as number) >= 2.
NOWKeyword to Perform Temporal Comparisons from Now
NOWkeyword represents the current datetime. Use the
NOWkeyword in PMQL search queries to find Requests or Tasks in the following ways:
daterepresents the date
operatorrepresents the comparative operator
-represents the addition or subtraction (respectively) from the
numberrepresents the number to add or subtract from the
intervalis the interval of time
ProcessNamethat are not more than two (2) days old:
ProcessNamein which its Request participants are 25 years old or younger by only having their date of birth in a Request variable called
DOB, use the following PQML search parameter: