I cannot find a solution within OQL to find UserRequest or other tickets where no CIs are attached.
There is a field in the class namen functioncis_list or applicationsolutions_list but I found no way in OQL to do something like: SELECT UserRequest WHERE functioncis_list ISNULL or = NULL
I could select the lnkFunctionalCIToTicket but in this case I find only tickets with CIs attached :(
Id like to create an audit rule for that and I cant use arrays or php for that.
In the Datamodel there is mentioned "Array of objects" but I don`t know how to access it. I could also find nothing helpful in the OQL_Reference of Combodo.
Could someone please give me a hint how to solve it?
Thanks in advance
Last edit: TheBigOne 2013-11-29
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Hi,
I cannot find a solution within OQL to find UserRequest or other tickets where no CIs are attached.
There is a field in the class namen functioncis_list or applicationsolutions_list but I found no way in OQL to do something like: SELECT UserRequest WHERE functioncis_list ISNULL or = NULL
I could select the lnkFunctionalCIToTicket but in this case I find only tickets with CIs attached :(
I
d like to create an audit rule for that and I can
t use arrays or php for that.In the Datamodel there is mentioned "Array of objects" but I don`t know how to access it. I could also find nothing helpful in the OQL_Reference of Combodo.
Could someone please give me a hint how to solve it?
Thanks in advance
Last edit: TheBigOne 2013-11-29