View Issue Details

Jump to NotesJump to History
IDProjectCategoryView StatusDate SubmittedLast Update
0001723CaseTalk ModelerGeneration (SQL, XML, etc)public2018-05-18 11:172022-01-10 20:40
ReporterBCP Software Assigned ToBCP Software  
PrioritynormalSeverityfeatureReproducibilityN/A
Status closedResolutionfixed 
Target Version9.1Fixed in Version9.1 
Summary0001723: Generate views which express the data
DescriptionCaseTalk 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.
TagsNo tags attached.
CaseTalk Editionunknown

Activities

BCP Software

BCP Software

2018-05-28 12:30

administrator  

DatabaseExpressions.png (40,672 bytes)   
DatabaseExpressions.png (40,672 bytes)   
BCP Software

BCP Software

2018-05-28 12:30

administrator   ~0001185

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;
BCP Software

BCP Software

2022-01-10 20:40

administrator   ~0003489

Closing automatically, stayed too long in resolved state. Feel free to re-open with additional information if you think the issue is not resolved.

Issue History

Date Modified Username Field Change
2018-05-18 11:17 BCP Software New Issue
2018-05-18 11:17 BCP Software Status new => assigned
2018-05-18 11:17 BCP Software Assigned To => BCP Software
2018-05-28 12:30 BCP Software File Added: DatabaseExpressions.png
2018-05-28 12:30 BCP Software Note Added: 0001185
2018-06-21 12:28 BCP Software Status assigned => resolved
2018-06-21 12:28 BCP Software Resolution open => fixed
2018-06-21 12:28 BCP Software Fixed in Version => 9.1
2022-01-10 20:40 BCP Software Note Added: 0003489
2022-01-10 20:40 BCP Software Status resolved => closed