View Issue Details

IDProjectCategoryView StatusLast Update
0001557CaseTalk ModelerConstraintspublic2023-10-13 19:54
ReporterBCP Software Assigned ToBCP Software  
PrioritynormalSeveritymajorReproducibilitysometimes
Status resolvedResolutionfixed 
Target Version13.0.1Fixed in Version13.0.1 
Summary0001557: Primary key on grouped level
DescriptionPrimary key is only available on UC's inside an OTFT. However a binary fact type with two UC's could contain a preferred primary key, and this binary fact type is outside an Object Type.

Instead of setting an UC's as a Primary Key preference, the OTFT should allow any UC from a grouped view, to be candidate for primary key. This marked UC should then perhaps be visualized as a thicker arrow.
TagsNo tags attached.
CaseTalk Edition

Activities

BCP Software

BCP Software

2018-01-16 12:10

administrator   ~0001073

When GLR is performed and a primary key is automatically selected, perhaps we should prefer the non-null roles, and the smallest amount of roles under a relevant uc. To prefer similar sets, we could choose for the oldest (as in lowest role numbers).
BCP Software

BCP Software

2021-02-27 09:45

administrator   ~0001911

Instead of using the term "Primary Key" (which is a database implementation term) the more generic "Preferred Identification" should be used. This would allow the change of current PK when transforming to use the "Preferred" instead. Which, by design, may be outside an OT.
BCP Software

BCP Software

2022-10-25 18:10

administrator   ~0004648

Also: When 'generate artificial key' is set, the UC on the roles are no longer really required. The consequences need to be discussed and investigated.
BCP Software

BCP Software

2023-10-13 19:54

administrator   ~0004979

The UC Dialog now collects UCs inside the selected OTFT, but also checks for groupable roles and UCs related to those OTFTs.

Issue History

Date Modified Username Field Change
2018-01-16 12:09 BCP Software New Issue
2018-01-16 12:09 BCP Software Status new => assigned
2018-01-16 12:09 BCP Software Assigned To => BCP Software
2018-01-16 12:10 BCP Software Note Added: 0001073
2020-04-19 09:25 BCP Software Category Model Constraints => Constraints
2021-02-27 09:45 BCP Software Note Added: 0001911
2021-02-27 09:45 BCP Software Target Version Future => 13.0.1
2022-10-25 18:10 BCP Software Note Added: 0004648
2023-10-13 19:53 BCP Software Status assigned => resolved
2023-10-13 19:53 BCP Software Resolution open => fixed
2023-10-13 19:53 BCP Software Fixed in Version => 13.0.1
2023-10-13 19:54 BCP Software Note Added: 0004979