erxes/erxes

const { tableSchema } = require('../tablePrefix');

cube(`Tickets`, {
  sql: `SELECT * FROM ${tableSchema()}__tickets`,

  joins: {},

  measures: {
    count: {
      type: `count`
    }
  },

  dimensions: {
    priority: {
      sql: `priority`,
      type: `string`
    },

    stageName: {
      sql: `${CUBE}."stageId"`,
      type: `string`
    },

    pipeline: {
      sql: `${CUBE}."stageId"`,
      type: `string`
    },

    assignedUser: {
      sql: `${CUBE}."assignedUserIds"`,
      type: `string`
    },

    board: {
      sql: `${CUBE}."stageId"`,
      type: `string`
    },

    status: {
      sql: `status`,
      type: `string`
    },

    modifiedBy: {
      sql: `${CUBE}."modifiedBy"`,
      type: `string`
    },

    createdDate: {
      sql: `${CUBE}."createdAt"`,
      type: `time`
    },

    closedDate: {
      sql: `${CUBE}."closedDate"`,
      type: `time`
    },

    modifiedDate: {
      sql: `${CUBE}."modifiedAt"`,
      type: `time`
    }
  }
});