BIRT - How can I add a filter to LARGE_STRING_KEY in data set WORKITEM_EXTRA_DATA

Bill Taylor (144●15●31) | asked Mar 18 '13, 8:46 a.m.
edited Mar 18 '13, 11:57 a.m. by Millard Ellingsworth (2.5k●1●24●31)

In a BIRT Report (in RTC 4.0.0.1 but not in 3.0.1), even when I add a filter for LARGE_STRING_KEY in data set WORKITEM_EXTRA_DATA, it retrieves all values of the key.

This can be seen in "Preview Results" in the data set definition, whether I add a filter or use a parameter.

Is there any way I can avoid retrieving every attribute?

Comments

Tommy Wu commented Aug 19 '14, 1:52 a.m. | edited Aug 20 '14, 3:02 a.m.

i also have such issue , who can help on this ?

One answer

Most liked answers ↑|Newest answers|Oldest answers

permanent link

Bill Taylor (144●15●31) | answered Aug 19 '14, 2:07 p.m.

This is a defect introduced into RTC 4. There is no workaround. I believe it's fixed in 4.0.3, but it's definitely fixed in 4.0.6

Comments

Tommy Wu commented Aug 19 '14, 2:13 p.m. | edited Aug 20 '14, 3:02 a.m.

Hi Bill , Thanks. I'm using 401 and will try 403 later. BTW, since this data set will be binding to another main dataset, then I found it works well during the join session without the bug .

Bill Taylor commented Aug 20 '14, 2:21 p.m.

But it does retrieve all the records before doing the join!

Krzysztof Kaźmierczyk commented Aug 21 '14, 11:29 a.m.

Hi Bill,
Do you have a link to corresponding jazz.net work item?

Bill Taylor commented Aug 21 '14, 3:58 p.m.

Defect 323132

It's all about the answers!

Related questions

BIRT - How can I add a filter to LARGE_STRING_KEY in data set WORKITEM_EXTRA_DATA

One answer

Your answer