It's all about the answers!

Ask a question

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

Bill Taylor (1441535) | asked Mar 18 '13, 8:46 a.m.
edited Mar 18 '13, 11:57 a.m. by Millard Ellingsworth (2.5k12431)
In a BIRT Report (in RTC 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?

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

permanent link
Bill Taylor (1441535) | 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

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 work item?

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

Your answer

Register or to post your answer.

Dashboards and work items are no longer publicly available, so some links may be invalid. We now provide similar information through other means. Learn more here.