Filtering results in data grid

DataRow allows you to filter the returned data without running another query. In this post, we’ll cover how you can filter and narrow your results in the DataRow's grid view.

After executing a query that returns a massive result set, DataRow allows you to filter the returned data without running another query. This process will enable you to analyze your results set without any additional queries or strain on your server.

  1. Prepare and run your query to get results in Data Grid.
  2. Click the Column Options icon and open the dropdown.
  3. Click the funnel icon and narrow your results — choose the result that you’re interested in so that DataRow displays only that row.
  4. Narrow your results by clicking the “rows icon” — choose the result that you’re interested in so that DataRow displays only that column.

datagrid_filtering-01-1024x803-1