Tanya,
I am following this example above and created the middle table "account_task".
I keep getting error messages in log for what I added in Task.json in order to retrieve the value from the middle table:"account_task.attend", even though I managed to retrieve the value.
--------Task.json (Task-Account many-many relation that I refrenced from account-contact relation)------
"tradeshowRole": { "type": "varchar", "maxLength": 100, "notStorable": true, "select": "account_task.attend", "where": { "LIKE": { "leftJoins": ["accounts"], "sql": "accountsMiddle.attend LIKE {value}", "distinct": true }, "=": { "leftJoins": ["accounts"], "sql": "accountsMiddle.attend = {value}", "distinct": true }, ....
------------------above produces error below----------------
[2019-02-11 16:48:24] Espo.ERROR: API [GET]:/:controller/action/:action, Params:Array ( [controller] => Activities [action] => listUpcoming ) , InputData: - SQLSTATE[42S22]: Column not found: 1054 Unknown column 'account_task.attend' in 'field list' [] []
[2019-02-11 16:48:24] Espo.ERROR: Display Error: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'account_task.attend' in 'field list', Code: 42S22 URL: /api/v1/Activities/action/listUpcoming?entityTypeList%5B%5D=Meeting&entityTy peList%5B%5D=Call&entityTypeList%5B%5D=Task&future Days=3&maxSize=10&offset=0&sortBy=id&asc=false
--------------------------------------------------------------------------
Same error if I use " accountTask "
What table name should I use?
Thanks!
I am following this example above and created the middle table "account_task".
I keep getting error messages in log for what I added in Task.json in order to retrieve the value from the middle table:"account_task.attend", even though I managed to retrieve the value.
--------Task.json (Task-Account many-many relation that I refrenced from account-contact relation)------
"tradeshowRole": { "type": "varchar", "maxLength": 100, "notStorable": true, "select": "account_task.attend", "where": { "LIKE": { "leftJoins": ["accounts"], "sql": "accountsMiddle.attend LIKE {value}", "distinct": true }, "=": { "leftJoins": ["accounts"], "sql": "accountsMiddle.attend = {value}", "distinct": true }, ....
------------------above produces error below----------------
[2019-02-11 16:48:24] Espo.ERROR: API [GET]:/:controller/action/:action, Params:Array ( [controller] => Activities [action] => listUpcoming ) , InputData: - SQLSTATE[42S22]: Column not found: 1054 Unknown column 'account_task.attend' in 'field list' [] []
[2019-02-11 16:48:24] Espo.ERROR: Display Error: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'account_task.attend' in 'field list', Code: 42S22 URL: /api/v1/Activities/action/listUpcoming?entityTypeList%5B%5D=Meeting&entityTy peList%5B%5D=Call&entityTypeList%5B%5D=Task&future Days=3&maxSize=10&offset=0&sortBy=id&asc=false
--------------------------------------------------------------------------
Same error if I use " accountTask "
What table name should I use?
Thanks!
Comment