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

Can I search a custom attribute (small string) by contains a comma?

Questions
Tags
Users
Badges
Sian O'Briain
(35●10●21) Sep 10 '15, 4:45 p.m.
When I create a query in the web client (5.0.2) to search a custom string attribute, I select 'contains' and add a comma as the search value. It returns everything. I know the comma is a reserved special character so is there a way to escape it? or use a regex? Thanks

0 votes

Comments
Donald Nong
Sep 11 '15, 6:19 a.m.
Funny enough almost all signs except for comma(,) are escaped automatically. For example, you can search an attribute contains a double quote (").

1 vote

Ralph Schoon
FORUM ADMINISTRATOR / FORUM MODERATOR / JAZZ DEVELOPER Sep 11 '15, 7:11 a.m.
In the past string attribute types were used to store enumeration lists as comma separated literal id's - hence not escaping them, I think.

1 vote

Sian O'Briain
Sep 15 '15, 5:44 p.m.
Thanks, so is that a  no then? We have used a small string attribute to store data from a migration. I need to check and see which work items contain multiple values which have been separated by a comma. Any workaround available?

Ralph Schoon
FORUM ADMINISTRATOR / FORUM MODERATOR / JAZZ DEVELOPER Sep 16 '15, 3:37 a.m.
You could use the Java API and read the attribute and use split to find ID's Another idea would be a CSV export with a different delimiter and searching that.

1 vote

Sian O'Briain
Sep 16 '15, 9:16 a.m.
Thank you very much. I did look at this route but didn't get very far (I'm a fairly novice java developer). Are there any sample classes i.e. one to authenticate and then maybe another to return some work items. If I had something to start with I'm sure I could tweak to suit our needs. Thanks!

0 answers
4,401 views
0 votes

Be the first one to answer this question!

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
× 26

Question asked: Sep 10 '15, 4:45 p.m.

Question was seen: 4,401 times

Last updated: Sep 16 '15, 9:16 a.m.

Confirmation Cancel Confirm