Merged Persona View

Shows the full effective state of each persona instance by combining archetype and instance fields. Scalar fields use the instance override if set, otherwise fall back to the archetype value. List fields merge archetype and instance values.

All Persona Instances (Merged View)

TABLE WITHOUT ID
  this-row.name AS "Persona",
  choice(this-row.job_statement,
    this-row.job_statement,
    this-row.archetype_parent.job_statement) AS "Job Statement",
  choice(this-row.decision_authority,
    this-row.decision_authority,
    this-row.archetype_parent.decision_authority) AS "Authority",
  choice(this-row.role_title,
    this-row.role_title,
    this-row.archetype_parent.role_title) AS "Role Title",
  flat(list(this-row.archetype_parent.frustrations,
    this-row.frustrations)) AS "All Frustrations",
  flat(list(this-row.archetype_parent.goals,
    this-row.goals)) AS "All Goals",
  flat(list(this-row.archetype_parent.tools_currently_used,
    this-row.tools_currently_used)) AS "All Tools",
  this-row.segment AS "Segment"
FROM "03-Market/2-Personas/Instances"
WHERE persona_type = "instance"
SORT name ASC

Single Instance Lookup

To view a specific instance, create an inline query on that instance’s page:

`= choice(this.job_statement, this.job_statement, this.archetype_parent.job_statement)`
`= choice(this.decision_authority, this.decision_authority, this.archetype_parent.decision_authority)`
`= flat(list(this.archetype_parent.frustrations, this.frustrations))`