Jazz Forum Welcome to the Jazz Community Forum Connect and collaborate with IBM Engineering experts and users

Sorting custom attribute in RTC query

Questions
Tags
Users
Badges
Bareket Matmon
(17●1●13) Mar 28 '18, 9:30 a.m.

Hi, 

After creating new query in RTC, I'm trying to sort one of the custom attribute called 'Value' (from type: Large HTML), but I couldn't find it in 'Sorting' list. how I can add it there? I want to sort this attribute.


Thanks, 
Bareket  

0 votes

1 answer
3,819 views
0 votes

Accepted answer

Permanent link
Piotr Aniola
(3.7k●1●17●38) Mar 28 '18, 9:52 a.m.

 It seems you can't sort by a Large HTML attribute, regardless of whether it's a custom or built-in attribute (for example, you can sort by Summary which is of type Medium HTML, but not Description, which is Large HTML). 

I believe this is a deliberate limitation due to performance reasons. You can create an enhancement request on jazz.net to address that.

Bareket Matmon selected this answer as the correct answer

0 votes

Comments
Donald Nong
Mar 29 '18, 4:20 a.m.
I think the limitation is due to how Large String and Large HTML are stored in the database. There is no efficient way to pull the data of these types and sort them. Assuming that the content cannot be accommodated in a Medium HTML attribute which holds 1000 bytes of XML text (including tags), the length of the content is more than 1000 bytes. Does it really make sense to sort them? If absolutely necessary, probably use a different attribute for sorting, or add a new attribute to hold the first XXX bytes of the Large HTML attribute for sorting.

Your answer

Register or log in 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.

Ask a question
Guidelines
FAQ
Search context
Follow this question

By Email: 

Once you sign in you will be able to subscribe for any updates here.

By RSS:

Answers
Answers and Comments
Question details
× 6,180

Question asked: Mar 28 '18, 9:30 a.m.

Question was seen: 3,819 times

Last updated: Mar 29 '18, 4:20 a.m.

Confirmation Cancel Confirm