Skip to content

Next

  • Projects
  • Groups
  • Snippets
  • Help
    • Loading...
    • Help
    • Submit feedback
    • Contribute to GitLab
    • Switch to GitLab Next
  • Sign in / Register
Minds Backend - Engine
Minds Backend - Engine
  • Project
    • Project
    • Details
    • Activity
    • Releases
    • Cycle Analytics
  • Repository
    • Repository
    • Files
    • Commits
    • Branches
    • Tags
    • Contributors
    • Graph
    • Compare
    • Charts
    • Locked Files
  • Issues 140
    • Issues 140
    • List
    • Boards
    • Labels
    • Service Desk
    • Milestones
  • Merge Requests 28
    • Merge Requests 28
  • CI / CD
    • CI / CD
    • Pipelines
    • Jobs
    • Schedules
    • Charts
  • Registry
    • Registry
  • Packages
    • Packages
  • Wiki
    • Wiki
  • Snippets
    • Snippets
  • Members
    • Members
  • Collapse sidebar
  • Activity
  • Graph
  • Charts
  • Create a new issue
  • Jobs
  • Commits
  • Issue Boards
  • Minds
  • Minds Backend - EngineMinds Backend - Engine
  • Issues
  • #468

Closed
Open
Opened 1 hour ago by Mark Harding@markeharding
  • Report abuse
  • New issue
Report abuse New issue

(feat): create schema for recording views of feed entities

CREATE TABLE feed_impressions (
  year int,
  month tinyint,
  day tinyint,
  uuid timeuuid,
  entity_urn text,
  position tinyint,
  source text,
  medium text,
  campaign text,
  PRIMARY KEY (year, month, day, uuid, entity_urn)
);
INSERT INTO feed_impressions (year, month, day, uuid, entity_urn, position, source, medium, campaign)
VALUES (2019, 5, 23, NOW(),'urn:activity:123', 3, 'newsfeed/subscriptions', 'organic', 'none')

SELECT * from feed_impressions
  WHERE year=2019
  AND month=5
  AND day=23
  AND uuid>abd576c0-8149-11e9-a21b-6f86601385fd;

Please solve the reCAPTCHA

We want to be sure it is you, please confirm you are not a robot.

Related issues
0

    • Mark Harding @markeharding changed milestone to %sprint: Funny Frog 1 hour ago

      changed milestone to %sprint: Funny Frog

    • Mark Harding @markeharding added S - Backlog label 1 hour ago

      added S - Backlog label

    • Mark Harding @markeharding mentioned in issue #469 1 hour ago

      mentioned in issue #469

    • Mark Harding @markeharding mentioned in issue #470 1 hour ago

      mentioned in issue #470

    • You're only seeing other activity in the feed. To add a comment, switch to one of the following options.
    Please register or sign in to reply
    Assignee
    None
    Assign to
    None
    Epic
    None
    sprint: Funny Frog
    Milestone
    sprint: Funny Frog
    Assign milestone
    None
    Time tracking
    No estimate or time spent
    None
    Due date
    None
    1
    Labels
    S - Backlog
    Assign labels
    • View project labels
    None
    Weight
    None
    Confidentiality
    Not confidential
    Lock issue
    Unlocked
    1
    1 participant
    user avatar
    Mark Harding
    Reference: minds/engine#468