View Issue Details

Jump to NotesJump to History
IDProjectCategoryView StatusDate SubmittedLast Update
0004610CaseTalk ModelerData Explorerpublic2024-05-07 14:332024-05-07 14:47
ReporterMarco Wobben Assigned ToMarco Wobben  
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

Marco Wobben

Marco Wobben

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

Marco Wobben

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 Marco Wobben New Issue
2024-05-07 14:33 Marco Wobben Status new => assigned
2024-05-07 14:33 Marco Wobben Assigned To => Marco Wobben
2024-05-07 14:38 Marco Wobben Status assigned => resolved
2024-05-07 14:38 Marco Wobben Resolution open => fixed
2024-05-07 14:38 Marco Wobben Fixed in Version => 13.3.1
2024-05-07 14:38 Marco Wobben Note Added: 0005244
2024-05-07 14:47 Marco Wobben Note Added: 0005245
2024-05-07 14:47 Marco Wobben File Added: QueryAsVirtualTable.png