entityDefs link conditions

[yuri]

It's not possible. The "conditions" parameter is not for the middle table. Which I believe is enough. Otherwise, it should not be a relationship. It works for read by an incident, not by design.

[a.slyzhko]

Log file says no column default_team_id in middle table, which is obvious. Question is how to perform join user table?

[shalmaxb]

log-file would be helpful

[a.slyzhko]

Hi there!
I have custom Event type entity with many to many link with User entity. Here its link definition

"attendees": {
    "type": "hasMany",
    "relationName": "cBusinessTripUser",
    "foreign": "cBusinessTrips",
    "entity": "User",
    "audited": false,
    "conditions": {
        "user.defaultTeamId!=": "665080eda8f96c718"
    },
    "additionalColumns": {
        "status": {
            "type": "varchar",
            "len": "36",
            "default": "None"
        }
    },
    "columnAttributeMap": {
        "status": "acceptanceStatus"
    }
}​ 

It works perfectly fine for displaying info, but when I try to manipulate data of this link, I always get en error. I discovered, that when I open record view of an entity, it uses join user table, so condition works perfectly fine, but when I try to update data, no join user table is present in raw sql, so it fails. What should I change/add to negate the error?
P.S. I know that I can add extra field defaultTeamId to middle table, but it will be db normalization, and defaultTeamId sometimes changes, so I will end up with inconsistent data. If there a way to add join every time this table is selected, it would be great solution!