View Issue Details

IDProjectCategoryView StatusLast Update
0002345CaseTalk ModelerRepositorypublic2022-01-10 20:40
ReporterBCP Software Assigned ToBCP Software  
PrioritynormalSeveritytrivialReproducibilityhave not tried
Status closedResolutionfixed 
Target Version9.9.0Fixed in Version9.9.0 
Summary0002345: Add sql function to get custom attribute value
DescriptionUsing sql functions it always requires an elaborate inline select to extract a specific custom attribute value.

Select
  OTFTNAME,
  (select attributevalue from customattributes where ...........! )
From OTFT

Could CaseTalk introduce a simple function to replace the subselect as a simple:

Select
  OTFTNAME,
  customattribute('OTFT', OTFTNAME, 'SOURCE', 'MODELER') as Owner
FROM OTFT
TagsNo tags attached.
CaseTalk Editionunknown

Activities

BCP Software

BCP Software

2022-01-10 20:40

administrator   ~0003945

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
2020-01-07 12:13 BCP Software New Issue
2020-01-07 12:13 BCP Software Status new => assigned
2020-01-07 12:13 BCP Software Assigned To => BCP Software
2020-01-07 12:14 BCP Software Status assigned => resolved
2020-01-07 12:14 BCP Software Resolution open => fixed
2020-01-07 12:14 BCP Software Fixed in Version => 9.9.0
2022-01-10 20:40 BCP Software Note Added: 0003945
2022-01-10 20:40 BCP Software Status resolved => closed