Searching Spry Data Sets

This post is more than 2 years old.

Need to quickly search through a Spry data set? Sam Mitchell shared this little gem with me: findRowsWithColumnValues. It allows you to search a dataset for a matching set of column, or columns. So for example, to return all boys from a set that has a gender column:

var boyRows = dsKids.findRowsWithColumnValues({"gender":"male"});

You can even tell the function to return immediately when it finds a match. This is useful for when you are searching by a primary key. Here is an example:

var theRow = dsKids.findRowsWithColumnValues({"id":"1"}, true);

Lastly, you can search by any number of columns:

var leftyBoyRows = dsKids.findRowsWithColumnValues({"gender":"male", "handiness":"left"});

A full example may be found here.

Raymond Camden's Picture

About Raymond Camden

Raymond is a senior developer evangelist for Adobe. He focuses on document services, JavaScript, and enterprise cat demos. If you like this article, please consider visiting my Amazon Wishlist or donating via PayPal to show your support. You can even buy me a coffee!

Lafayette, LA