specs/models/M_TABLE_QUERY
Table Query
Table Queries are lists of Table Records with dynamic parameters that can be defined within apps.
They are meant to be used to display a list of records to an operator, and allow the operator to select any one of the options shown on the screen.
Or, you can run aggregations on top of them within apps in order to summarize all the values in a column.
Table Queries are saved in their current state with every published version of an app. So, when a new version of an app is created, it cannot be changed by changing the rules of a Table Query.
Table Queries can only reference a single Table. IDs, along with metadata fields Date Created and Date Updated, are available by default for filters and sorting options.
Fields
| Name | Description |
|---|---|
| Name | The name of the Table Query |
| ID | The unique ID of the Table Query |
| Filters | There can be 0-many filters that define a Table Query. Some may be defined statically in the Table Query Editor, while others may be defined in an app. Filters limit the query's output to certain number of rows that match the specified condition. |
| Sorting Rules | There can be 0-many sorting functions in the query. |
| Limit | the maximum number of records that the query can return. |
| Linked Apps | A list of all the development version of apps that reference the Table Query. |
Here are the possible filter functions.
| Name | Description |
|---|---|
| equals | Where a value equals another value |
| does not equal | Where a value does not equal another value |
| is null | Where a field is empty |
| is not null | Where a field is not empty |
| contains | Where a field value contains a substring |
| does not contain | Where a field value does not contain a substring |
| starts with | Where a field value starts with a substring |
| does not start with | Where a field value does not start with a substring |
| ends with | Where a field value ends with a substring |
| does not end with | Where a field value does not end with a substring |
| is in | Where an array of a single data type contains the field value |
| is not in | Returns any values that do not match any of the items in a provided array |
| is greater than | Where a field value is greater than a value |
| is less than | Where a field value is less than a value |
| is equal to | Where a field value is equal to a value |
| is not equal to | Where a field value is not equal to a value |
| is greater than or equal to | Where a field value is greater than or equal to a value |
| is less than or equal to | Where a field value is less than or equal to a value |
| is after | Where a datetime field value is after a value |
| is before | Where a datetime field value is before a value |
| is after or at | Where a datetime field value is after or equal to a value |
| is before or at | Where a datetime field value is before or equal to a value |
Tests
| ID | Name |
|---|---|
| QA-T570 | Table Queries : 01 - Create, Edit, Delete a Query |
| QA-T571 | Table Queries : 02 - Query Configuration |
| QA-T700 | Table Queries : 02 / Query for an Archived Field |
Requirements
| ID | Requirement |
|---|---|
| PLAT-8841 (289) | Ability to exclude a work order from the dispatch list. |
| PLAT-8881 (277) | Ability to view dispatching list by equipment. Ie for any element of the equipment hierarchy such as area, machine, work center, etc. |
| PLAT-8886 (94) | Ability to view material dispatching lists in a content. |
| PLAT-8892 (96) | Ability to view batch/lot dispatching lists in content |
| PLAT-8908 (396) | Ability to track and list materials for a work order for reconciliation. |