cube.js -模式维度部分中的mongodb DBref字段

Question

我正在尝试创建一个基于DBref id字段(mongodb)的过滤器。生成的SQL查询如下所示

SELECT
  `part_r_f_q_dpa`.`partRFQId` `part_r_f_q_dpa__partrfqid`,
  `part_r_f_q_dpa`.`noOfApproval` `part_r_f_q_dpa__noofapproval`,
  `part_r_f_q_dpa`.`CurrentApproved` `part_r_f_q_dpa__currentapprove`
FROM
  makethepart.`directPartApproval` AS `part_r_f_q_dpa`
  LEFT JOIN makethepart.`partRFQ` AS `part_r_f_q` ON `part_r_f_q_dpa`.partRFQId = `part_r_f_q`._id
WHERE
  (`part_r_f_q`.`creatorBuyer.$id` = ?)
GROUP BY
  1,
  2,
  3
ORDER BY
  1 ASC
LIMIT
  10000

我收到一个错误" error : Unknown column 'part_r_f_q.creatorBuyer.$id‘in 'where子句’“。模式中维度下的代码摘录如下

  creatorbuyer: {
    sql: `${CUBE}.\`creatorBuyer.$id\``,
    type: string

有没有人可以告诉我应该如何处理上面显示的dbrefs id

Answer 1

Mongo BI中的$id被引用为_id。您应该使用_id而不是$id。