AnsweredAssumed Answered

IN statement for BRELS and brackets

Question asked by Gutis Champion on Oct 5, 2015
Latest reply on May 8, 2018 by andholmes

Hello Community,

 

As we all know to get tickets assigned to groups of logged in user we should use the following notation:

 

group.[group]group_list.member IN (@cnt.id)

 

according to CA documentation (Scoreboard Queries - CA Service Management - 14.1 - CA Technologies Documentation) this will also work:

 

 

group.group_list.member IN (@cnt.id)

 

citation from documentation:

It works in this case, more out of luck, that the group_list object has an attribute named ‘group’ in it. If it were named anything else, the where clause would fail to parse!

 

 

So i decidet to try another query that will find all incidents that have CI which is related to change 400201:

affected_resource.[nr]chgnr.chg IN 400201







 

According to documentation this query should fail to parse

 

 

affected_resource.chgnr.chg IN 400201

 

 

but it also works without any problems and i get the same results as in the case with the brackets.

 

May it be so, that after CA introduced new lrel system, when each relationship has its own relation table, brackets are absolete? Or i am missing something?

 

 

There is another statement in documentation:

 

Note: You cannot extend the dot notation. For example, the following does not work:
affected_resource.[parent]child_hier.child.name IN ('chicago1')

It seems that it is not true since following querys works for me as well

 

(assignee.[member]group_list.group.last_name IN '%UG%')
(assignee.group_list.group.last_name IN '%UG%')

Outcomes