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?