Uploaded image for project: 'Jira Service Management Data Center'
  1. Jira Service Management Data Center
  2. JSDSERVER-7451

Add an IQL function to search in a recursive way outbound references

XMLWordPrintable

    • We collect Jira Service Desk feedback from various sources, and we evaluate what we've collected when planning our product roadmap. To understand how this piece of feedback will be reviewed, see our Implementation of New Features Policy.

      Hello,Instead of doing something like this to get all objects having a top parent by following a outbound Ref : object having outR(Name=10258) orobject having outR(object having outR(Name=10258)) orobject having outR(object having outR(object having outR(Name=10258))) orobject having outR(object having outR(object having outR(object having outR(Name=10258)))) orobject having outR(object having outR(object having outR(object having outR(object having outR(Name=10258))))) orobject having outR( object having outR(object having outR(object having outR(object having outR(object having outR(Name=10258)))))) orobject having outR(object having outR( object having outR(object having outR(object having outR(object having outR(object having outR(Name=10258))))))) ....Could be replace by somthing like "object having cascadingOutR(IQL, refTypes, depth)"Regards

            [JSDSERVER-7451] Add an IQL function to search in a recursive way outbound references

            Beverley Moysey added a comment -

            Yes please – I am using Assets to help me figure out MS SQL database dependencies.  I've created objects in Assets representing every table, view, synonym, stored procedure, etc, and then linked each object in Assets to the other objects it depends on.  My goal is to be able to determine if I retired database X, which objects in other databases will be impacted.

             

            However, I'm having to do manual recursion like in the original ticket and guess at how many levels deep I need to go.  For example, when I did the query below, increasing the number of levels deep I searched each time, I found that 1 or 2 levels returned 7 objects, while 3, 4, and 5 levels each returned 8 objects.  So it would seem that I'm safe to only check 3 levels deep... but what if there's something 6 levels deep that I didn't detect yet?  So deeper I go until I'm absolutely sure I'm safe.

            objectType = "SQL Job" 
            and 
            (
            object having outR("Parent SQL Database" = FireWeather)
            OR object having outR(object having outR("Parent SQL Database" = FireWeather)) 
            OR object having outR(object having outR(object having outR("Parent SQL Database" = FireWeather)))
            OR object having outR(object having outR(object having outR(object having outR("Parent SQL Database" = FireWeather))))
            OR object having outR(object having outR(object having outR(object having outR(object having outR("Parent SQL Database" = FireWeather)))))
            )

            Beverley Moysey added a comment - Yes please – I am using Assets to help me figure out MS SQL database dependencies.  I've created objects in Assets representing every table, view, synonym, stored procedure, etc, and then linked each object in Assets to the other objects it depends on.  My goal is to be able to determine if I retired database X, which objects in other databases will be impacted.   However, I'm having to do manual recursion like in the original ticket and guess at how many levels deep I need to go.  For example, when I did the query below, increasing the number of levels deep I searched each time, I found that 1 or 2 levels returned 7 objects, while 3, 4, and 5 levels each returned 8 objects.  So it would seem that I'm safe to only check 3 levels deep... but what if there's something 6 levels deep that I didn't detect yet?  So deeper I go until I'm absolutely sure I'm safe. objectType = "SQL Job"  and  ( object having outR("Parent SQL Database" = FireWeather) OR object having outR(object having outR("Parent SQL Database" = FireWeather))  OR object having outR(object having outR(object having outR("Parent SQL Database" = FireWeather))) OR object having outR(object having outR(object having outR(object having outR("Parent SQL Database" = FireWeather)))) OR object having outR(object having outR(object having outR(object having outR(object having outR("Parent SQL Database" = FireWeather))))) )
            Marc Dacanay made changes -
            Labels Original: affects-server insight-h New: affects-server insight-h ril
            Marc Dacanay made changes -
            Remote Link New: This issue links to "Internal ticket (Web Link)" [ 977095 ]
            Alex Cooksey made changes -
            Labels New: affects-server insight-h
            Alex Cooksey created issue -

              Unassigned Unassigned
              da0dd4439f59 Alex Cooksey
              Votes:
              5 Vote for this issue
              Watchers:
              5 Start watching this issue

                Created:
                Updated: