Hope someone con help or point me to some information. We have records in the Knowledge base module and use the /GET filter API to do a realtime search of these solutions on our website.
To give users more targeted results I need to also filter by our related module "Product Class" which is a custom module and related to Knowledge Base use a many to many relationship.
Is it possible to use the filter API to pass the Product Class ID?
I can create this using a custom API calling a custom SQL statement but would like to know if its possible with the filter API. Also is it more efficient to just go with the custom API route.
Below is my current filter payload in JSON
{ "filter":[ { "status":{ "$equals":"published" }, "$or":[ { "name":{ "$contains":"driver" } }, { "description":{ "$contains":"driver" } } ] } ], "max_num":10, "fields":"id" }