# ResourceBookingsByCriteria: Bouw7 Resource Bookings by Criteria Returns a set of resource bookings by an organization, optionally filtered by project. Returns a set of resource bookings by an organization, optionally filtered by project. - Catalog: `Bouw7` - Schema: `Resource` - Label: Resource Bookings by Criteria This is a read-only table function. The Bouw7 API may not support changing the data or the Invantive UniversalSQL driver for Bouw7 does not cover it. In the latter case, please use the table NativePlatformScalarRequests to upload data to the Bouw7 API. ## Parameters of Table Function The following parameters can be used to control the behaviour of the table function `ResourceBookingsByCriteria`. A value must be provided at all times for required parameters, but optional parameters in general do not need to have a value and the execution will default to a pre-defined behaviour. Values can be specified by position and by name. In both cases, all parameters not specified will be evaluated using their default values. Value specification by position is done by listing all values from the first to the last needed value. For example: a `select * from table(value1, value2, value3)` on a table with four parameters will use the default value for the fourth parameter and the specified values for the first three. Value specification by name is done by listing all values that require a value. For example with `select * from table(name1 => value1, name3 => value3)` on the same table will use the default values for the second and fourth parameters and the specified values for the first and third. | Name | Data Type | Required | Default Value | Documentation | |---|:---:|:---:|:---:|---| | `projectId` | `` | ☐ | | The id of the project | | `q` | `` | ☐ | | Filter collections with the [Heimdall Query Language](https://heimdall.bouw7.nl/docs/query-language) | | `type` | `` | ☑ | | The type of resource | ## Columns of Table Function The columns of the table function `ResourceBookingsByCriteria` are shown below. Each column has an SQL data type. | Name | Data Type | Label | Required | Documentation | |---|:---:|---|:---:|---| | `amount` | `varchar2` | Amount | ☐ | The amount of the resource booking. | | `comment` | `varchar2` | Comment | ☐ | The comment of this booking. | | `createdAt` | `datetime` | Created at | ☐ | The creation time of the entity. | | `createdBy` | `varchar2` | Created by | ☐ | The user that created the entity. | | `group_id` | `int64` | Group ID | ☐ | The unique identifier of the resource group. | | `group_name` | `varchar2` | Group Name | ☐ | The name of the resource group. | | `id` | `int64` | ID | ☐ | The unique identifier of the resource booking. | | `logDate` | `datetime` | Log Date | ☐ | The cost price of this booking. | | `price` | `varchar2` | Price | ☐ | The price of this booking, if this is not provided, the price of the unit will be used for the booking. | | `priceTotal` | `varchar2` | Price Total | ☐ | The total price of this booking. | | `project_id` | `int64` | Project ID | ☐ | The unique identifier of the project the resource belongs to. | | `project_name` | `varchar2` | Project Name | ☐ | The name of the project the resource belongs to. | | `projectSecurityLink_chapterName` | `varchar2` | Project Security Link Chapter Name | ☐ | The name of the project security chapter. | | `projectSecurityLink_id` | `int64` | Project Security Link ID | ☐ | The unique identifier of the project security link. | | `projectSecurityLink_name` | `varchar2` | Project Security Link Name | ☐ | The name of the project security link. | | `projectSecurityLink_status` | `int64` | Project Security Link Status | ☐ | The status of the project security link. | | `resource_id` | `int64` | Resource ID | ☐ | The unique identifier of the resource. | | `resource_name` | `varchar2` | Resource Name | ☐ | The name of the resource. | | `sellingPrice` | `varchar2` | Selling Price | ☐ | The selling price of this booking. | | `sellingPriceTotal` | `varchar2` | Selling Price Total | ☐ | The total selling price of this booking. | | `type` | `varchar2` | Type | ☐ | Resource type, possible values: equipment. | | `unit_id` | `int64` | Unit ID | ☐ | The unique identifier of the resource unit. | | `updatedAt` | `datetime` | Updated At | ☐ | The last updated time of the entity. | | `updatedBy` | `varchar2` | Updated by | ☐ | The user that last updated the entity. |