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

    Automatically filter hotfix releases, eg 4.1.12.3 or 4.2.1.2, 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 4.2.1.1.  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)?

       

      thanks