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 (1441533) | 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 (1441533) | 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.