Search multi-valued field with specific values

[vjajula]

Hi All,

Can someone help me with the following

 ColY represents multi-value field. I want to search all rows which have null, 0 and someother values in ColY

Based on the below example output rows should be for A123456, A123461 

ColX	ColY
A123456	null 0 56789 987654
A123457	4332
A123458	54322 0
A123459	null 0
A123460	2345667 7665443
A123461	null 788765 0
A123462	876543 null

[venkatasri · Accepted solution]

Hi @vjajula 

You can try search command,

<your base search> | search coIY=null AND coIy=0

 --

An upvote would be appreciated if this reply helps!

[vjajula]

Thanks for the solution. This is perfect