AnsweredAssumed Answered

IN clause applied to QREL

Question asked by Gutis Champion on Oct 21, 2015
Latest reply on Nov 10, 2015 by cdtj

Hello,

According to CA documentation (Scoreboard Queries - CA Service Management - 14.1 - CA Technologies Documentation) "CA SDM supports the IN clause applied to QREL or BREL lists".

But if you try to use it you will get an error. For example if you will search for particular incident child:

children IN ( 'cr:400080' )

system will give an error (Attr not found or not atomic)

You my also search for related CMDB configuration item

bm_parent_hier.parent IN ( U'1D5A46C05D491345B482810AC7C04E7E' )

system will give an error (Bad where clause: invalid constraint. Unable to resolve bm_parent_hier.parent)

If you will do this on BREL list

parent_hier.parent IN ( U'1D5A46C05D491345B482810AC7C04E7E' )

Search will work as expected.

 

Is it some kind of BUG, or once again documentation regarding scoreboards are wrong? Maybe IN statement on QRELs should be used somehow differently?

Outcomes