locked
ACT 5.6 - Filtering "____" from list RRS feed

  • Question

  • Hello,

    I have been using the ACT app in a test here to see if it would meet my needs.  I noticed that it captures a lot of "____" like Intel drivers, and other items that aren't of concern to me.  I want to filter my application list to NOT INCLUDE these items.

     

    I created a category (Legitimacy) and sub-category (Legit) or (Not Legit).

     

    I tried filetering with

    Contains category Legitimacy

    AND

    Not Contains sub-category Not Legit

     

    This displays nothing.

    Wednesday, August 18, 2010 4:48 PM

Answers

  • You can create a customized filter by the steps below:

     

    1.    In the Windows 7 - Application Report screen, click Toggle Filter.

    2.    In the Field list, click Priority.

     

    The Operator field will automatically update with the Equals option, and the Value box will automatically update with the Priority 1 – Business Critical option.

     

    3.    Press the TAB key to create a new query row.

    4.    In the And/Or list, click And.

    5.    In the Field list, click 32-bit Internal Assessment.

    6.    In the Value list, click Works.

    7.    Press the TAB key to create a new query row.

    8.    In the And/Or list, click And.

    9.    In the Field list, click Categories (+).

     

    The remaining filter criteria is completed and a linked row is automatically created.

     

    10. In the linked row Field list, click Category Name.

     

    The Operator field will automatically update with the Equals option and another linked row is created.

     

    11. In the Value box, select Location.

    12. In the linked row And/Or list, click And.

    13. In the Field list, click Subcategory Name.

    The Operator field will automatically update with the Equals option.

    14. In the Value box, select United States.

    15. Right-click anywhere in the row, and then click Execute.

     

    The filter sorts your data to display the Microsoft Application Compatibility Toolkit 5.6 because it is the only application that fulfills all the filter criteria.

     

    Regards,

    Linda


    Please remember to click “Mark as Answer” on the post that helps you, and to click “Unmark as Answer” if a marked post does not actually answer your question. This can be beneficial to other community members reading the thread. ”
    • Marked as answer by Linda Yan Wednesday, August 25, 2010 2:23 AM
    Friday, August 20, 2010 7:29 AM

All replies

  • You can create a customized filter by the steps below:

     

    1.    In the Windows 7 - Application Report screen, click Toggle Filter.

    2.    In the Field list, click Priority.

     

    The Operator field will automatically update with the Equals option, and the Value box will automatically update with the Priority 1 – Business Critical option.

     

    3.    Press the TAB key to create a new query row.

    4.    In the And/Or list, click And.

    5.    In the Field list, click 32-bit Internal Assessment.

    6.    In the Value list, click Works.

    7.    Press the TAB key to create a new query row.

    8.    In the And/Or list, click And.

    9.    In the Field list, click Categories (+).

     

    The remaining filter criteria is completed and a linked row is automatically created.

     

    10. In the linked row Field list, click Category Name.

     

    The Operator field will automatically update with the Equals option and another linked row is created.

     

    11. In the Value box, select Location.

    12. In the linked row And/Or list, click And.

    13. In the Field list, click Subcategory Name.

    The Operator field will automatically update with the Equals option.

    14. In the Value box, select United States.

    15. Right-click anywhere in the row, and then click Execute.

     

    The filter sorts your data to display the Microsoft Application Compatibility Toolkit 5.6 because it is the only application that fulfills all the filter criteria.

     

    Regards,

    Linda


    Please remember to click “Mark as Answer” on the post that helps you, and to click “Unmark as Answer” if a marked post does not actually answer your question. This can be beneficial to other community members reading the thread. ”
    • Marked as answer by Linda Yan Wednesday, August 25, 2010 2:23 AM
    Friday, August 20, 2010 7:29 AM
  • Hi, and thank you for the response.  I am familiar with creating a custom filter, but in this case my filter doesn't work. 


    Rather than add a sub-category of "Legit" to every piece of legitimate software I tagged the ones that were "Not-Legit".  Now I want to create a filter with a condition which ONLY shows the Legit software.  Thus I tried to create filter like this:

    Contains category Legitimacy

    AND

    Not Contains sub-category Not Legit

     

    That doesn't work...maybe this won't work with null values??

     

    Wednesday, August 25, 2010 3:12 PM