Menu

OQL query to select related incidents to a change

2021-02-18
2021-03-02
  • Sandra Marín

    Sandra Marín - 2021-02-18

    Hi everyone
    I need a OQL query to select related incidents to a change.
    Can someone help me please?
    Thanks
    Sandra

     
  • Pierre Goiffon

    Pierre Goiffon - 2021-03-02

    Hello,

    Check the data model viewer (Administration / Data Model) for the Change class, see the related classes tab : you'll see the link between both classes.

    Something like this should work :

    SELECT Incident AS i
    WHERE i.parent_change_id = :change_id
    
     

Log in to post a comment.

Want the latest updates on software, tech news, and AI?
Get latest updates about software, tech news, and AI from SourceForge directly in your inbox once a month.