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

Changing datatype of an attribute in RTC project area

Questions
Tags
Users
Badges
Rakesh A
(33●5●33) edited
Feb 11 '19, 8:56 a.m.

Hello,
           I have changed the data type of an attribute from Large String to Medium String in project area

           Major reason is because I wanted attribute to be appearing in work-item queries - condition (as large string is not supported in WI query conditions.).

          Even after changing to Medium String datatype, I can’t find this attribute in work-item queries - condition, because I believe attribute of data type large string is already existing in the database.
           
            Let me know if there is a solution to make it work (searchable) in project areas instead of renaming/changing the ID of that attribute .

0 votes

1 answer
2,561 views
0 votes

One answer

Permanent link
Ralph Schoon
FORUM ADMINISTRATOR / FORUM MODERATOR / JAZZ DEVELOPER (63.9k●3●36●48) Feb 12 '19, 2:44 a.m.

 After you created an attribute, you can not just change the type as far as I know. What you can do is:

  1. Change the display name of the attribute e.g. ThisAttributeWasDeprecated
  2. Create a new attribute NewAttribute
  3. Use some automation e.g. csv import/export or the APIs to copy the value from the old to the new  attribute
  4. Remove the old attribute after all data has been moved. 

0 votes

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,121
× 457
× 72

Question asked: Feb 11 '19, 8:32 a.m.

Question was seen: 2,561 times

Last updated: Feb 12 '19, 2:44 a.m.

Confirmation Cancel Confirm