# _RecordsMediaVideosDishes 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` ## 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 `_RecordsMediaVideosDishes` are shown below. Each column has an SQL data type. | Name | Data Type | Label | Required | Documentation | |---|:---:|---|:---:|---| | `CreatedOn` | `datetime` | Created On | ☐ | | | `Description` | `string` | Description | ☐ | | | `Folder_Id` | `int32` | Folder ID | ☐ | | | `Folder_Name` | `string` | Folder Name | ☐ | | | `Id` | `int32` | ID | ☐ | | | `LaborPreparationTime` | `string` | Labour Preparation Time | ☐ | | | `LaborWashingTime` | `string` | Labour Washing Time | ☐ | | | `LastModifiedOn` | `datetime` | Last Modified On | ☐ | | | `Name` | `string` | Name | ☐ | | | `NumberOfPersons` | `int32` | Number of Persons | ☐ | | | `PluNumber` | `string` | PLU Number | ☐ | | | `PreparationDescription` | `string` | Preparation Description | ☐ | | | `RecipeComments` | `string` | Recipe Remarks | ☐ | | | `ServingDescription` | `string` | Serving Description | ☐ | | | `TEXT` | `string` | Text | ☐ | | | `Type_Id` | `int32` | Type ID | ☐ | | | `Type_Name` | `string` | Type Name | ☐ | | | `UnitType_Id` | `int32` | Unit Type ID | ☐ | | | `UnitType_Name` | `string` | Unit Type Name | ☐ | | | `UsableAmount` | `double` | Usable Quantity | ☐ | |