What is PMQL?

Overview
ProcessMaker Query Language (PMQL) is a custom language to search ProcessMaker data. Similar in ways to search query language (SQL), which is a standard language for storing, manipulating and retrieving data in databases, use PMQL to find Requests, Tasks, and Collection record information.
Use PMQL in the following ways:
Requests: Perform advanced searches to find Request summaries.
Tasks: Perform advanced searches through your Tasks.
Collection records: Search through the records in a Collection.
To understand how to use PQML, understand the basic concepts how to compose a PMQL search query:
Syntax: Syntax specifies how to compare, combine, exclude, or group the "building blocks" of a PMQL search query. An example of a comparative operator is to compare if the last name of a Request participant is (or is not) "Canera".
Data types: Data types specify which type of ProcessMaker data to search. There are three data types in PMQL: Request, Task, and Collection.
Properties: Properties are the "building blocks" from which to compose PMQL queries regardless of which data type a PMQL query applies. Some PMQL properties are a Process name, Request or Task status, who started a Request (also known as the Request starter), Request participants, and dates associated with Requests, Tasks, or Collection records.
Related Topics
PMQL Syntax to Search ProcessMaker Data
PMQL Data Types: Request, Task, and Collection
Request Data Type PMQL Properties
Task Data Type PMQL Properties
Collection Data Type PMQL Properties
What is Request Data?
What is a Request Variable?
​

Use ProcessMaker - Previous

Search ProcessMaker Data Using ProcessMaker Query Language (PMQL)

PMQL Syntax to Search ProcessMaker Data

Last modified 1yr ago

Export as PDF

Copy link

Edit on GitHub

Contents

Overview