4 Replies Latest reply on Aug 5, 2013 2:02 AM by a k

    Automatically filter hotfix releases, eg or, from maint, eg 4.2.1

    a k

      I'm building a report on support tickets. I want to filter out tickets raised for hot fixes, so we only see tickets for maintenance and major releases.  There are generally several hot fixes a week, so adding them to a set as they appear would be a drag.


      So, there's a dimension 'release', which includes major releases, eg 4.2, maintenance releases, eg 4.2.1, and hotfixes, eg  I can't use length, since sometimes releases go into double figures.  And I can't see a string function to count periods, or strip digits.


      Is there another way I could do this?  Or would I be best off doing the processing in the DB (which will slow the report down a bit)?