Meetings — OQL | OnePageCRM Developers

OQL field reference for meetings. Logged meetings with contacts, including location.

Meetings are logged meetings with contacts, including location and free-text notes.

Fields

Legend: F filterable, S sortable, A aggregatable, G groupable.

Field	Type	F	S	A	G	Description
`id`	ID	Y	—	—	—	Meeting ID
`text`	string	—	—	—	—	Meeting notes (select only)
`contact_id`	ID	Y	—	—	Y	Associated contact ID
`author`	string	—	—	—	—	Author display name (select only)
`author_id`	ID	Y	—	—	Y	Author user ID
`place`	string	Y	—	—	—	Meeting location (max 100 chars)
`meeting_time`	time	Y	Y	—	Y	When the meeting occurred
`created_at`	time	Y	Y	—	Y	Record creation timestamp
`modified_at`	time	Y	Y	—	Y	Last modification timestamp

Notes

text is select-only — OQL has no full-text search over meeting notes.
place is freeform. There is no enum or place lookup.
Lookups: contact (via contact_id). Reference the contact’s fields inline as contact.<field> in select, where, and order_by. See Concepts › Lookups.

Example queries

My meetings this week:

{
  "from": "meetings",
  "where": {
    "author_id": "ME()",
    "meeting_time": { ">=": "THIS_WEEK()" }
  },
  "order_by": [{ "meeting_time": "asc" }]
}

Meeting count by author this quarter:

{
  "from": "meetings",
  "select": ["author_id", "count()"],
  "where": { "meeting_time": { ">=": "THIS_QUARTER()" } },
  "group_by": ["author_id"]
}

All meetings on a specific contact:

{
  "from": "meetings",
  "where": { "contact_id": "507f1f77bcf86cd799439011" },
  "order_by": [{ "meeting_time": "desc" }]
}