How do I iterate through a result set and fetch the data for each result?

[Anantha123]

I have a query to retrieve "Item_Number " in table. The results will be as below...

..| table Item_Number 

Item_Number
1234
2345
4567

Now, I want to calculate count for each of these "Item Number " .

I used below query to get the count .

|table Item_Number |  map search="search index=* $Item_Number$|stats count as cnt" 

but I am getting zero results .

Please suggest how to achieve this count for each result values of "Item_Number "

Thanks in Advance.

[arkadyz1]

Count of all instances of each value? If yes, try | stats count by Item_Number instead of table. stats generates values in such a way that you can use this search to power a table on a form/dashboard.

[Vijeta]

try using

\"$Item_Number$\" instead of $Item_Number$

[Anantha123]

Thanks for quick reply Vijeta, but its not working. I am still getting count 0's .

[Anantha123]

my query worked when I gave $$Item_Number$$..
your answer "\"$Item_Number$\"" also helped me when i had to use with eval ..like |eval ItemNo=\"$Item_Number$\"| ..
Thank you so much Vijeta.
Sorry for late reply.

[Vijeta]

No problem. Glad it worked!

[Vijeta]

@ananthan123 can you please accept the answer .

[Vijeta]

try using fields instead of table in main search

[Anantha123]

Yeah Vijeta, I even tried with fields and used the syntax that you shared . But did not helped me getting the count .