| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0001723 | CaseTalk Modeler | Generation (SQL, XML, etc) | public | 2018-05-18 11:17 | 2022-01-10 20:40 |
| Reporter | Marco Wobben | Assigned To | Marco Wobben | ||
| Priority | normal | Severity | feature | Reproducibility | N/A |
| Status | closed | Resolution | fixed | ||
| Target Version | 9.1 | Fixed in Version | 9.1 | ||
| Summary | 0001723: Generate views which express the data | ||||
| Description | CaseTalk uses expression to enter the datamodel, and generates databases in structure. It would be nice to generate a view on tables which represent the data in a readable format similar to the original expressions. | ||||
| Tags | No tags attached. | ||||
| CaseTalk Edition | unknown | ||||
 |
CREATE VIEW $SCHEMA$.Employee_Expression AS SELECT employee_no, 'Employee ' || employee_no || ' has name ' || Employee_Name || '.' AS FactExpression FROM Employee UNION SELECT employee_no, 'Employee ' || employee_no || ' has title ' || Title || '.' AS FactExpression FROM Employee UNION SELECT employee_no, 'Employee ' || employee_no || ' is arranged to division ' || Division || '.' AS FactExpression FROM Employee; |
|
|
Closing automatically, stayed too long in resolved state. Feel free to re-open with additional information if you think the issue is not resolved. |
