CA Service Management

 View Only
  • 1.  Property Validation Rules

    Posted Mar 14, 2019 08:54 AM

    Is there way for me to find and see which categories have properties set on the "Property List" tab which references a specific validation rule?


    I have a request to change the drop-down options listed for a specific validation rule and category-which I can do, however my issue is that I do not know what all categories reference this list to know if the change will impact other groups who may use a different category than the one I am being asked to modify it for.



    thank you


  • 2.  Re: Property Validation Rules
    Best Answer

    Posted Mar 14, 2019 10:22 AM

    Hi Katherine,


    If I got your requirements and we talk about req/inc/prb categories, this query should work:

    properties.validation_rule.sym like '%yes%no%'

    this one would display all categories with properties which contains rules with thoes words ("Yes No")




  • 3.  Re: Property Validation Rules

    Posted Mar 14, 2019 10:53 AM

    Thank you Timur ... that query worked great for me and will be so useful.



    thank you