REST API: GET products belonging to multiple specific categories

Using my Dolibarr
1

Dolibarr 10.x

I am using the REST API Explorer. I am trying to perform a GET method on products for a list of products that might belong to more than one specified categorie.

Examples:

A product might have a categorie with the categorie.rowid in 5 or 6. Or a product might have a categorie with the categorie.label being ‘internet’ or ‘tv’.

  • categorie.rowid IN (5, 6)
  • categorie.label = ‘internet’ OR categorie.label = ‘tv’

My question is: how can I achieve this without writing in a subquery in the sqlfilters? Ideally, I would like to specify which categories I want to include in the Parameters without including them all.

I am just uncomfortable with writing in subqueries into the sqlfilter because I am concerned about speed performance.

Thank you!

2

I’m not convinced this can be done with Dolibarr “out of the box” upon closer review of the index function’s query builder in htdocs/product/class/api_products.class.php.