entityDefs link conditions

Collapse
X
 
  • Time
  • Show
Clear All
new posts

  • yuri
    replied
    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.

    Leave a comment:


  • a.slyzhko
    commented on 's reply
    Log file says no column default_team_id in middle table, which is obvious. Question is how to perform join user table?

  • shalmaxb
    replied
    log-file would be helpful

    Leave a comment:


  • a.slyzhko
    started a topic entityDefs link conditions

    entityDefs link conditions

    Hi there!
    I have custom Event type entity with many to many link with User entity. Here its link definition
    PHP Code:
    "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!
Working...