# DishRecipeIngredients: Horeko Gerecht Receptingrediënten Returns dishes Returns list of dishes. Available sort options: Id,Name,NumberOfPersons,ArticleNumber,CreatedOn,LastModifiedOn This is a read-only table function. The Horeko API may not support modifying the data, or the Invantive UniversalSQL driver for Horeko does not support it. In the latter case, use the table NativePlatformScalarRequests to upload data to the Horeko API. - Catalog: `Horeko` - Schema: `Dish` - Label: Dish Recipe Ingredients ## Parameters of Table Function | Name | Data Type | Required | Default Value | Documentation | |---|:---:|:---:|:---:|---| | `ingredientId` | `int32` | ☐ | | filter dishes that contain this ingredient | | `lastAffectedOn` | `datetime` | ☐ | | filter dishes which recipes are update after this date (format yyyy-mm-dd hh:mm:ss) | | `lastUpdatedOn` | `datetime` | ☐ | | filter dishes updated after this date (format yyyy-mm-dd hh:mm:ss) | | `loadChildrenFolders` | `boolean` | ☐ | | check if dishes are contained into subfolders of the folders above | | `pluNumber` | `string` | ☐ | | article number | | `sortBy` | `string` | ☐ | | comma separated list of available options for sorting | | `sortDescending` | `boolean` | ☐ | | true = descending \| false = asceding. default is false | | `subrecipeId` | `int32` | ☐ | | filter dishes that contain this subrecipe | | `typeId` | `int32` | ☐ | | type id | ## Columns The columns of the table `DishRecipeIngredients` are shown below. Each column has an SQL data type. | Name | Data Type | Label | Required | Documentation | |---|:---:|---|:---:|---| | `Amount` | `double` | Amount | ☐ | | | `CreatedOn` | `datetime` | Created On | ☐ | | | `Description` | `string` | Description | ☐ | | | `Folder_Id` | `int32` | Folder ID | ☐ | | | `Folder_Name` | `string` | Folder Name | ☐ | | | `HTMLDescription` | `string` | HTML Description | ☐ | | | `Id_2` | `int32` | | ☐ | | | `Id` | `int32` | ID | ☐ | | | `IsValid` | `boolean` | Is Valid | ☐ | | | `LaborPreparationTime` | `string` | Labour Preparation Time | ☐ | | | `LaborWashingTime` | `string` | Labour Washing Time | ☐ | | | `LastModifiedOn` | `datetime` | Last Modified On | ☐ | | | `LineNumber` | `int32` | Line Number | ☐ | | | `Name_2` | `string` | | ☐ | | | `Name` | `string` | Name | ☐ | | | `NumberOfPersons` | `int32` | Number of Persons | ☐ | | | `PluNumber` | `string` | PLU Number | ☐ | | | `PreparationDescription` | `string` | Preparation Description | ☐ | | | `RecipeComments` | `string` | Recipe Remarks | ☐ | | | `ServingDescription` | `string` | Serving Description | ☐ | | | `Type_Id_2` | `int32` | | ☐ | | | `Type_Id` | `int32` | Type ID | ☐ | | | `Type_Name_2` | `string` | | ☐ | | | `Type_Name` | `string` | Type Name | ☐ | | | `Unit` | `int32` | Unit | ☐ | | | `UnitType_Id` | `int32` | Unit Type ID | ☐ | | | `UnitType_Name` | `string` | Unit Type Name | ☐ | | | `UsableAmount` | `double` | Usable Quantity | ☐ | |