View Issue Details

IDProjectCategoryView StatusLast Update
0001557CaseTalk ModelerConstraintspublic2023-10-13 19:54
ReporterMarco Wobben Assigned ToMarco Wobben  
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

Marco Wobben

Marco Wobben

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).
Marco Wobben

Marco Wobben

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.
Marco Wobben

Marco Wobben

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.
Marco Wobben

Marco Wobben

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 Marco Wobben New Issue
2018-01-16 12:09 Marco Wobben Status new => assigned
2018-01-16 12:09 Marco Wobben Assigned To => Marco Wobben
2018-01-16 12:10 Marco Wobben Note Added: 0001073
2020-04-19 09:25 Marco Wobben Category Model Constraints => Constraints
2021-02-27 09:45 Marco Wobben Note Added: 0001911
2021-02-27 09:45 Marco Wobben Target Version Future => 13.0.1
2022-10-25 18:10 Marco Wobben Note Added: 0004648
2023-10-13 19:53 Marco Wobben Status assigned => resolved
2023-10-13 19:53 Marco Wobben Resolution open => fixed
2023-10-13 19:53 Marco Wobben Fixed in Version => 13.0.1
2023-10-13 19:54 Marco Wobben Note Added: 0004979