news

Fields

Field	Type	Description
id	uuid	Unique identifier for the news item (auto-generated)
orgId	uuid	Reference to the organization
circleId	uuid	Reference to the circle (optional)
threadId	uuid	Reference to the source thread (if applicable)
decisionId	uuid	Reference to the source decision (if applicable)
meetingId	uuid	Reference to the source meeting (if applicable)
createdAt	Timestamp	When the news item was created

Implementation

The news entity is implemented as a SQL view that combines:

1. Non-preparation threads — All non-archived threads except those with “Preparation” status
2. Non-archived decisions — All decisions that have not been archived
3. Completed meetings — Meetings that have ended and are not archived

Relationships

Object Relationships

• org — The organization this news item belongs to
• circle — The circle associated with this news item (if any)
• thread — The source thread (if news is from a thread)
• decision — The source decision (if news is from a decision)
• meeting — The source meeting (if news is from a meeting)

Query Examples

List Recent News

query GetRecentNews($orgId: uuid!) {
  news(
    where: { orgId: { _eq: $orgId } }
    order_by: { createdAt: desc }
    limit: 10
  ) {
    id
    createdAt
    thread {
      title
      status
    }
    decision {
      title
      description
    }
    meeting {
      title
      summary
    }
    circle {
      role {
        name
      }
    }
  }
}

Query News with Filters and Aggregation

query GetFilteredNews($where: news_bool_exp!) {
  news(
    where: { _and: [{ orgId: { _eq: $orgId } }, $where] }
    order_by: { createdAt: desc }
  ) {
    id
    createdAt
    threadId
    decisionId
    meetingId
    org {
      name
    }
  }
  news_aggregate(where: { _and: [{ orgId: { _eq: $orgId } }, $where] }) {
    aggregate {
      count
    }
  }
}

Permissions

News access is controlled based on organization membership:

• Organization members can view all news entries from their organization. Each entry contains only references (UUIDs) to the source entity. Access to the actual thread, decision, or meeting data depends on the permissions of each linked entity