ProductCategories is an auto generated table


The CategoryId_p column can be used to filter data within this table. The CategoryId_p can be used only with the equals (=) operator.

The driver will use the Magento API to filter the results by CategoryId_p while the rest of the filter is executed client side within the driver.

The following examples show the types of queries processed server side.

  • Retrieve all product categories:\

  • Retrieve detailed information about a single product category:\

You can turn off client-side execution by setting SupportEnhancedSQL to false, in which case any search criteria that refers to any other columns will cause an error.


The Name and IsActive columns are required to create a new category.\


To update a category, you must set the Id column.\


Product categories can be deleted by providing the Id column.\



Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.

Last updated