Link Expresion

Hi Experts,

 

In SM 9.33 we are tyring to query the affected,item field from link .

$query="(subtype=\"Type1\" or subtype=\"Type2\" and istatus~=\"Retired/Consumed\")"

 

But the above one doesnt filter properly . also tried the following line below which doenst work either.

 

$query =" subtype=\"Type1\""

$query =" or subtype=\"Type2\""

$query =" and istatus~=\"Retired/Consumed\""

 

Kindly suggest.