How to create a Track-It report with Parent Folder Category only

Version 2
    Share This:

    This document contains official content from the BMC Software Knowledge Base. It is automatically updated when the knowledge article is modified.


    PRODUCT:

    Track-It!


    COMPONENT:

    Track-It! 2019 R3


    APPLIES TO:

    All Web base Track-It! versions



    QUESTION:

    How to generate the report ‘Ticket by category’ with Parent Folder Category


    ANSWER:

    In order to obtain the Parent Category Folder,

       
    1. Add a calculated field to your report     
           
      • Click on the icon at the right to add a calculated field
      •   
    2.  
    3. Provide the inputs required     
           
      • User-added image
      •   
    4.  
    5. Script (In Expression field):     
           
      • Substring([Category Full Path],0, CharIndex('->',[Category Full Path]) )
      •   
    6.  
    7. Add the field in the Report canvas     
           
      • User-added image
      •   
    8.  
    9. Preview the report     
           
      • User-added image
      •   
      
    Now you can see the Category itself and the Parent Folder 


      

     


    Article Number:

    000180982


    Article Type:

    FAQ/Procedural



      Looking for additional information?    Search BMC Support  or  Browse Knowledge Articles