API Filter by Custom Field

brendanb · 28 March 2018 05:35

Hi,

Im using Postman to test some Queries using the latest version of the API (8)

I have added a custom field to Accounts called: firm_id_c

What / Can I us this custom field as the filter?

Like:
api/v8/modules/Accounts?filter[Accounts.firm_id_c]=[eq]12345678

When I try this in the suitecrm.log I see:

MySQL error 1054: Unknown column ‘accounts.firm_id_c’ in ‘where clause’

Regards
Brendan

pgr · 28 March 2018 14:59

New issue opened here

Thanks for reporting!

pgr · 28 March 2018 17:51

… and that issue is now fixed! Visit the Issue and if you can test the solution and give some feedback there, that would be great. Thanks

brendanb · 28 March 2018 20:18

Thank you,
I will look at trying to test later today.