javascript - 如何查看环回中第二个表中的字段？

Question

我在环回中有这两个模型，第一个称为 Permissions，第二个称为 langs_translate。

表格如下所示:

许可:

--------------------------
| id | icon      | link  |
--------------------------
| 1  | dashboard | home  |
--------------------------
| 2  | users     | users |
--------------------------
| 3  | inbox     | inbox |
--------------------------

 ...
 "relations": {
   "langsTranslates": {
     "type": "hasMany",
     "model": "langs_translates",
     "foreignKey": "permission_id"
   }
 },
 ....

lang_翻译

-------------------------------------------------------
| id | label     | permission_id  | lang | translate  |
-------------------------------------------------------
| 1  | HOME_TXT  | 1              | eng  | Dashboard  |
-------------------------------------------------------
| 2  | USERS_TXT | 2              | eng  | Users      |
-------------------------------------------------------
| 3  | INBOX_TXT | 3              | eng  | Inbox      |
-------------------------------------------------------
| 4  | USERS_TXT | 2              | heb  | לקוחות     |
-------------------------------------------------------
| 5  | INBOX_TXT | 3              | heb  |  הודעות    |
-------------------------------------------------------
| 6  | HOME_TXT  | 1              | heb  | לוח בקרה   | 
-------------------------------------------------------

...
"relations": {
  "permissions": {
    "type": "belongsTo",
    "model": "permissions",
    "foreignKey": "permission_id"
  }
},
...

我想从权限表中查看“图标”，并通过键“permission_id”连接到 lang_translate 表，并从这些表中获取字段“label”。但它只获取权限表中的字段。我正在使用此代码来获取数据:

$rootScope.menus = Permissions.find({
    include: 
        {"relation": "langsTranslates"},
    filter: {
        where: {
            lang : "heb"
        }
    } 
}, function(data){
    console.log(data);
});

非常感谢。

Answer 1

您应该在 filter 键下指定 include:

Permissions.find({
    filter: {
        where: { lang : "heb" },
        include: {"relation": "langsTranslates"},
    } 
}, function(data){
    console.log(data);
});

从技术上讲，where、include、order、fields、limit 和 offset 都是不同类型的滤波器，对于 Angular SKD 应该这样指定。检查AngularJS SDK docs了解更多信息。