Question
Maantic Inc
Maantic Inc
US
Maantic Inc
Posted: Sep 26, 2016
Last activity: Sep 27, 2016
Last activity: 27 Sep 2016 2:51 EDT
Closed
Having same table in two different schemas, by passing same set of input parameter need to pull data from these tables. is it possible in report definition.
Having same table in two different schemas, by passing same set of input parameter need to pull data from these tables. is it possible in report definition.
Exmaple : table A schema - test 1
name age place
John 21 MD
Paul 22 CT
Table 2 schema test 2
Name age Place
Jack 20 NY
Josh 25 NJ
Result
John 21 MD
Paul 22 CT
Jack 20 NY
Josh 25 NJ
Posted: 9 years ago
PEGA
Pegasystems Inc.
IN
Hi ,
I dont think, with report definition , we can fetch results from tables in 2 different schemas unless you are a super user , since the query similar to below gets fired : where dbo is the schema name .
SELECT "PC0".pyID AS "pyID" , "PC0".pzInsKey AS "pzInsKey" FROM dbo.pc_Sae_sample_Work "PC0" WHERE "PC0".pxObjClass = ?
Probably, you must be a super user, who has access to both the schemas (test1 and test2), and in the Sub-reports section, you need to provide a classname that is present in the other schema i.e test2 .
Thanks,
Haritha.D