CQ Import: Can tag field be extended beyond 1k?
We are in the midst of converting from CQ to RTC, and are trying to import some CQ multi-select list values into RTC as tags. We have run into a problem where one of the fields holding these values contains more than 1k of text, and trying to update the imported CQ record in RTC fails when we try to apply these values. I was wondering if there is a way to extend the amount of data a tag field holds. I'm also wondering if there is a limit on the number tags or the total size in bytes of the possible tag values for a field.
This is what we're doing - In CQ, the field in question holds a multi-select list of values that the user selects by querying a predefined table with all possible values. By clicking Add, the user is taken to a separate dialog window where they can enter a search string that will return a list of possible values, then use the <Ctrl> key to select multiple entries from this list. Clicking OK in this dialog window will save the values in the original multi-select list. The user can repeat the Add process as many times as they need to populate the list. They can also select mulitple entries from the list and hit a Remove button to have the values removed from the list. At this time, the predefined CQ table users select from holds about 250 entries, each of which are from 10-80 bytes long. We were going to auto-populate this list of possible values as tags in RTC, then later restrict which users could add additional tags. The auto-complete feature of typing in the tags field would be a reasonable alternative to allowing the users to search for multiple values. This field typically only has a handful of entries stored in it, so all our records except for one got updated just fine. All of these reasons are why we originally thought that using tags would be a good fit. We did not realize there was a 1k restriction on the data being saved in the tags field. I'm also not sure how many of the values from the predefined CQ table have been brought over yet, and if having 250 10-80 byte values would be OK for a tag field. Any suggestions would be appreciated! |
2 answers
|
Here is the exception reported when we try to do a CSV update to the RTC work item that had been imported from CQ in order to populate the tag field with a value that is too large:
|
|
From: Geoffrey Clemm
To: Tom Loeber Cc: Gerry Cullen Date: 12/20/2011 09:15 AM Subject: Re: Work Item Tags limit Hi Tom, You'll probably want to post these questions to the forum. My take: 1: Probably not. But you should be able to import them as a custom field (they just wouldn't be treated as "tags" though). 2: I have never heard of someone encountering a limit on the total number of tags in the repo, but that doesn't mean there isn't one (:-). 3: There must be a way via the API, because the Eclipse client obtains a list of them for Control-Space completion when adding an entry to the Tag field of a work item. Cheers, Geoff From: Tom Loeber To: Geoffrey Clemm Cc: Gerry Cullen Date: 12/20/2011 06:48 AM Subject: Work Item Tags limit Hi Geoffrey - We've just discovered, during a migration from CQ, that attributes of type tag on work items seem to have a size limit of 1000 bytes. See the forum entry below. This raises a few questions. Can this limit be adjusted some how? Tag seems to be defined as medium string. This limit is on the size of the actual tag type attribute on the work item. Is there a limit on the total number of available tags in the repository? Is there a way to query or find out what tags are currently available in the repository? https://jazz.net/forums/viewtopic.php?t=21547 Regards, Tom Loeber |
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.