Collection
data type to perform PMQL search queries from any of the pages accessible from the Collections sidebar icon in the Admin top menu option. PMQL search queries apply to records within the displayed Collection. Selecting any PMQL search result displays the Collection record for that result.created
: Record's Creation Datecreated
property represents when the record was created from the currently displayed Collection.YYYY-MM-DD HH:MM:SS
using 24-hour time. Example: "2020-07-01 14:25:15"
.NOW
KeywordNOW
keyword to dynamically compare the current datetime with a specified number of chronological units. Use the Less Than operator (<
) followed by the number of chronological units to search for Requests of that age. Note that the interval unit of time is singular. PMQL supports the following units of time:data
object. The data
object stores the accumulated data from Screen controls used to create and edit records in its Collection by referencing the controls' Variable Name setting values.AcademicInterests
stores multiple options in a JSON object that each Freshman student selected as academic interests.LIKE
operator with the %
wildcard to search for any Task name that includes the characters engineering
as an academic interest, but excludes those records with software
preceding any academic interest.lower
function to ensure all options from AcademicInterests
are evaluated regardless of their case sensitivity.data
object: Search Collection Data for Specific Record Informationdata
JSON object to search for sought Collection records. The data
object stores the accumulated data from Screen controls used to create and edit records in its Collection by referencing the controls' Variable Name setting values.data
is the accumulation of data for each Collection. Each Request also stores its Request data in a data
JSON object. The key names for each JSON object or array derive from the Variable Name setting values in the Screens used for that Collection or any data injected into that Collection's JSON data model by Scripts or calls to the RESTful Application Program Interface (API).data
JSON object in PQML search queries helps answer the question "Which Collection records have specific information in them that I seek?" Use operators to compare the value for a particular Screen control to find records that only contain the value(s) you seek.data
JSON object precedes the Variable Name setting value, as noted above. Use JSON dot notation to reference sub-properties in the referenced Screen control if necessary. Major
stores the JSON object value for the option that each student selects as a major.TotalCredits
stores as an integer the sum of all credits that the student selected for enrollment.CodingLanguages
stores the JSON object value of programming languages in which the employment candidate has experience.id
: Collection Record ID Numberid
property represents the ID number for the sought record(s) from the currently displayed Collection.id
property for the Request
data type or for the id
property for the Task
data type.created
property to search for which Collections were created by a particular date. Note that PMQL interprets strings in the format YYYY-MM-DD HH:MM:SS
as dates and can be used in comparative queries if that string is in quotation marks ("2020-03-14 00:00:00"
).modified
: Datetime Record Last Modifiedmodified
property represents when the record was last modified from the currently displayed Collection. A record modifies when the contents of the a record changes from any of the following:YYYY-MM-DD HH:MM:SS
using 24-hour time. Example: "2020-07-01 14:25:15"
.NOW
KeywordNOW
keyword to dynamically compare the current datetime with a specified number of chronological units. Use the Less Than operator (<
) followed by the number of chronological units to search for Requests of that age. Note that the interval unit of time is singular. PMQL supports the following units of time:NOW
keyword to represent the current datetime, and then uses the Less Than operator (<
) to determine the datetime 30 minutes ago that the applicable Collection records were modified. Note that the unit of chronological measurement (minute
) is singular.data
object. The data
object stores the accumulated data from Screen controls used to create and edit records in its Collection by referencing the controls' Variable Name setting values. The following Screen controls store data that this PMQL search query references:GraduationYear
control stores at which year a student graduates. This value is stored as a string.AdvisorMeetingDate
control stores at which date a student met with her or his advisor.CAST
function to convert the string to a number for comparison in the PMQL search.