OrderItems is an auto generated table


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

The following examples demonstrate the types of queries processed on the server.

  • Retrieve information about all order items:\

  • Filter by ItemId to get detailed information about an order item:\

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.



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