Get Row Index by matching multiple column values

Getting help Questions
1

Hi,

Is there a way to get row index for a given criteria that matches multiple column values?
For e.g. I would like to get row index of the record that matches following criteria:
Name Column = ‘Tom’
Gender Column = ‘M’
Country column = ‘US’

If this record is in third position I should get 2 as returned row index.

2

Hey @RajDev

the Filter plugin does not support this functionality yet. But you can use search plugin https://handsontable.com/docs/6.2.1/demo-searching.html to hide all the rows that do not match the search query.