View Issue Details

Jump to NotesJump to History
IDProjectCategoryView StatusDate SubmittedLast Update
0004610CaseTalk ModelerData Explorerpublic2024-05-07 14:332024-05-07 14:47
ReporterBCP Software Assigned ToBCP Software  
PrioritynormalSeverityfeatureReproducibilityhave not tried
Status resolvedResolutionfixed 
PlatformIntelOSWindowsOS Version11
Target Version13.3.1Fixed in Version13.3.1 
Summary0004610: Use query output as virtual tables
DescriptionUse query output as virtual table in the casetalk-schema to build cross database queries.
TagsNo tags attached.
CaseTalk Editionunknown

Activities

BCP Software

BCP Software

2024-05-07 14:38

administrator   ~0005244

In Query1-tab write the following to query the server:
select otft_name
from ctk_otft
where ig_version = 254

Create a new query tab and enter the following:
select otftname as name
from ig.otft

union all

select otft_name
from query1

order by name

This second will render the union of a local IG resultset with the resultset from the server.

Remember the connection for the second tab must be set to CaseTalk
BCP Software

BCP Software

2024-05-07 14:47

administrator   ~0005245

QueryAsVirtualTable.png (44,139 bytes)   
QueryAsVirtualTable.png (44,139 bytes)   

Issue History

Date Modified Username Field Change
2024-05-07 14:33 BCP Software New Issue
2024-05-07 14:33 BCP Software Status new => assigned
2024-05-07 14:33 BCP Software Assigned To => BCP Software
2024-05-07 14:38 BCP Software Status assigned => resolved
2024-05-07 14:38 BCP Software Resolution open => fixed
2024-05-07 14:38 BCP Software Fixed in Version => 13.3.1
2024-05-07 14:38 BCP Software Note Added: 0005244
2024-05-07 14:47 BCP Software Note Added: 0005245
2024-05-07 14:47 BCP Software File Added: QueryAsVirtualTable.png