v8 API Does not support Custom Field Filtering on the Get Modules.

SuiteCRM Forum - English Language SuiteCRM General Discussion
1

https://10.90.0.13/suitecrm/Api/V8/module/Accounts?fields[Accounts]=name,account_type&page[size]=4&page[number]=4&sort=name&filter[operator]=and&filter[masterid_c][eq]=‘1234’

The custom field is masterid_id.

Here is the error.

{
“errors”: {
“status”: 400,
“title”: null,
“detail”: “Database failure. Please refer to suitecrm.log for details.”
}
}Database failure. Please refer to suitecrm.log for details.

Here is the error from the suitecrm.log

Thu Oct 17 13:52:17 2019 [47412][1][FATAL] Error retrieving Account list: Query Failed: SELECT accounts.* ,accounts_cstm.masterid_c,accounts_cstm.jjwg_maps_lng_c,accounts_cstm.jjwg_maps_geocode_status_c,accounts_cstm.jjwg_maps_addres$

AND jt0.deleted=0 LEFT JOIN users jt1 ON accounts.created_by=jt1.id AND jt1.deleted=0

AND jt1.deleted=0 LEFT JOIN users jt2 ON accounts.assigned_user_id=jt2.id AND jt2.deleted=0

AND jt2.deleted=0 LEFT JOIN accounts jt3 ON accounts.parent_id=jt3.id AND jt3.deleted=0

AND jt3.deleted=0 LEFT JOIN campaigns jt4 ON accounts.campaign_id=jt4.id AND jt4.deleted=0

AND jt4.deleted=0 where (accounts.masterid_c = ‘‘1234’’ AND accounts.deleted = ‘0’) AND accounts.deleted=0 ORDER BY accounts.name ASC LIMIT 12,4: MySQL error 1054: Unknown column ‘accounts.masterid_c’ in ‘where clause’

2

Hi, I have the same problem. This has been discussed many times on github as well and it was marked for repair but to be honest - I dont really understand how sprint works so not sure when to expect this to be repaired… But it has been marked as bug like 3 versions ago… :frowning: Anybody has any info about that?

Still not working on the latest 7.11.8… :dry:

3

https://github.com/salesagility/SuiteCRM/issues/7285#issuecomment-545625129

here is the issue on github…