Is this possible to take substring in JRS 6.0.1
Hi Team,
Is it posible to take substring in JRS 6.0.1. For example: There are some data where we need to cut the string like xyz_1010 here we want only numeric value then how we are going to take this in JRS?? |
Accepted answer
Steven Shaw (551●1●3)
| answered May 31 '16, 8:35 a.m.
FORUM MODERATOR / JAZZ DEVELOPER edited May 31 '16, 8:37 a.m.
Hello,
This is not currently part of the core wizard capability. It may be possible using advanced SQL and experimenting with conditions such as Proj_TEAM_CALC LIKE'%_[0-9]%'.
You can do partial match searches at report creation time where if you type something in the search box for the condition it will narrow down the choices based on a fuzzy match of the search string. Then you can "Select all" to choose all the displayed values.
We have a story that seems related to your request: 391983: As a user, I would like the ability to use a wildcard as part of defining a condition in a report. Feel free to add comments related to this workflow and / or vote for it.
Regards,
-Steve
Rosa Naranjo selected this answer as the correct answer
|
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.
Comments
Sorry. I don't understand your question. Could you provide a screenshot of what you are trying to construct in Report Builder? What kind of condition or query are you trying to build?
As shown in below expression:
if(position( '', [Proj_TEAM_CALC] ) = 0)
then
([Proj_TEAM_CALC])
else
(substring( [Proj_TEAM_CALC], 1, position( '', [Proj_TEAM_CALC] )-1) )
I'm not sure about the original poster, but for us we aren't looking for a substring in conditioning, but more a substring capability in the formatting/output.