Is this possible to take substring in JRS 6.0.1
Accepted answer
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
Comments
Rosa Naranjo
FORUM MODERATOR / JAZZ DEVELOPER Jun 06 '16, 10:00 p.m.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?
Shubhangi yadav
Jun 06 '16, 10:01 p.m.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) )
Jackie Albert
Jun 06 '16, 10:00 p.m.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.