nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Joint Data Sets

krysaund

This is my first time working with BIRT, so hopefully my question is clear. I am trying to populate the data from one dataset (table

to another dataset (table A). I have used the joint data set wizard and it did not work. I know this possible because I created the query in SQL Developer and it ran returning the exact results I wanted. I also tried to copy the query into BIRT making minor changes and this also did not work.

Please Help!

K

Find more posts tagged with

Comments

ANNKRUSE

<blockquote class='ipsBlockquote' data-author="'krysaund'" data-cid="99121" data-time="1334601488" data-date="16 April 2012 - 11:38 AM"><p>
This is my first time working with BIRT, so hopefully my question is clear. I am trying to populate the data from one dataset (table

krysaund

Ok, I hope this makes sense. Some of the fields i had to rename.

SELECT ticket.ticketid, ticket.assetnum, innerasset.tkassetdesc, ticket.location, ticket.cinum, tkci.tkciname
FROM
(SELECT ci.ciname AS tkciname
FROM ci
WHERE cinum =
(SELECT cinum
FROM ticket
WHERE ticket.ticketid = 'SR-1000033'
AND ticket.class = 'SR'
)
) tkci,
(SELECT asset.description AS tkassetdesc
FROM asset
WHERE assetnum =
(SELECT assetnum
FROM ticket
WHERE ticket.ticketid = 'SR-1000033'
AND ticket.class = 'SR'
)
) innerasset, ticket
WHERE ticket.ticketid = 'SR-1000033'
AND ticket.class = 'SR'
UNION ALL
SELECT srquery.tkticketid, srquery.assetnum, srquery.assetdesc, srquery.location, srquery.cinum, srquery.ciname
FROM(
SELECT
ticket.assetnum as tkassetnum,
ticket.ticketid as tkticketid,
multiassetlocci.assetnum,
asset.description assetdesc,
multiassetlocci.location,
locations.description locdesc,
multiassetlocci.cinum,
ci.ciname,
ci.description cietdesc,
multiassetlocci.targetdesc,
multiassetlocci.multiid
FROM multiassetlocci
LEFT OUTER JOIN asset
ON multiassetlocci.assetnum = asset.assetnum
AND multiassetlocci.siteid = asset.siteid
AND multiassetlocci.orgid = asset.orgid
LEFT OUTER JOIN ticket
ON multiassetlocci.recordkey = ticket.ticketid
AND multiassetlocci.recordclass = ticket.class
LEFT OUTER JOIN locations
ON multiassetlocci.location = locations.location
AND multiassetlocci.siteid = locations.siteid
AND multiassetlocci.orgid = locations.orgid
LEFT OUTER JOIN ci
ON multiassetlocci.cinum = ci.cinum
WHERE multiassetlocci.isprimary = 0
AND multiassetlocci.recordkey = 'SR-1000033'
AND multiassetlocci.recordclass = 'SR'
) srquery

Hans_vd

Hi Krysaund,

If you mean that you want to use the joint dataset to perform the UNION, that's not possible. At least if you don't have version 11 of Actuate BIRT.

You can read about it here:
http://www.birt-exchange.org/org/forum/index.php/blog/3/entry-180-joining-data-sets-has-never-been-so-easy33/

Regards
Hans