PageBuilderTableRows snippet

Returns rows from a resource data table (manager Tables tab). Output: JSON or a Fenom chunk.

Write markup in a template, widget, or chunk. Pro section data_table uses the package chunk pagebuilder_data_table.

Where to call

Template, chunk, or a snippet field in another section. The table is on the current resource or on resource_id.

Parameters

Parameter	Default	Description
resource_id	0	Resource ID. 0 = current resource
table_key	empty	Table key on the resource
table_id	0	Database table ID. When greater than zero it wins over table_key
limit	20	Max rows (1–100)
return	json	json or chunk
tpl	pagebuilder_table_rows	Chunk when return=chunk

The response stays empty ([] or an empty string) only when no resource can be resolved.

When table_id is greater than zero, the snippet does not check that the table belongs to resource_id. A resource must still be resolved.

Filtering and pagination

Every key works in the snippet. The manager processor mgr/datatable/rows/list accepts only page, limit, search, and filters. Context and UTM filters are not sent to it.

Parameter	Default	Description
page	1	Page number
search	empty	Row search
filters	empty	JSON column filters
context_column	empty	Column for context filter
use_context	1	Use current resource context_key in context_column
context_key	empty	Explicit context instead of current
use_utm	0	Add filters from UTM session
utm / utm_filters	empty	JSON UTM filters for columns

Example filters:

{"price": {"op": "gte", "value": "100"}}

Operators: eq, contains, in, gt, lt, gte, lte, between, empty, not_empty. Details: System settings → Tabular resource data.

Event pbOnBeforeTableGetList receives table, query, and criteria by reference:

• The row query reads search, filters, page, and limit from query
• Pairs from criteria other than table_id go into the where clause
• After the plugin, table_id is written again: a plugin cannot switch the table
• The list event runs from the snippet and from mgr/datatable/rows/list

pbOnTableRowSave passes data by reference. That value is stored on the row.

JSON

Missing table → []. Otherwise an array of records: id, table_id, position, data, editedon, editedby. Cell values live in data.

return=chunk passes only data into the chunk. Any return value other than json renders the chunk.

modx

[[!PageBuilderTableRows?
  &resource_id=`[[*id]]`
  &table_key=`offices`
  &limit=`50`
]]

fenom

{'!PageBuilderTableRows' | snippet : [
  'resource_id' => $_modx->resource.id,
  'table_key' => 'offices',
  'limit' => 50
]}

Chunk

The chunk gets Fenom variables rows (array of row data) and table (table metadata).

modx

[[!PageBuilderTableRows?
  &resource_id=`[[*id]]`
  &table_key=`offices`
  &return=`chunk`
  &tpl=`my_table_rows`
]]

fenom

{'!PageBuilderTableRows' | snippet : [
  'resource_id' => $_modx->resource.id,
  'table_key' => 'offices',
  'return' => 'chunk',
  'tpl' => 'my_table_rows'
]}

See also

• data_table section
• Developer → Resource data tables