> For the complete documentation index, see [llms.txt](https://docs.labii.com/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.labii.com/widgets/section-widgets/data-display/record-list/record-list-by-query.md).

# Record List by Query

## Specs

| Label                     | Value                         |
| ------------------------- | ----------------------------- |
| **Version**               | 3.0.0 (updated on 2022-09-26) |
| **Developer**             | Labii Inc.                    |
| **Type**                  | Section                       |
| **Support Configuration** | Yes                           |

## Overview

The "Record List by Query" widget presents a curated list of records based on a user-defined query. Users can seamlessly configure the displayed fields, tailoring the widget to showcase specific information relevant to their needs. This widget not only facilitates a detailed and customizable view of records but also empowers users to update the values of these records directly from the interface.

## Use cases

* Display list of reagents that is running low and to be ordered.

Explore [this resource](/widgets/section-widgets/data-display/record-list.md) to find comparisons between this widget and other similar widgets.

## Settings

To enable the widget's functionality, it is essential to provide settings for both the table and query. These settings will determine the specific list of records to be displayed and the fields that should be included in the presentation.

* **Table** - Select a table that has columns referred to this record as the value of ForeignKey or ForeignKeys.
* **Filter** - Select a filter. The query will be updated once selected.
* **Query** - Display a limited list of records by configuring the query.
* **Fields** - Fields of the table to display. The name field will always be included.
* **Group fields** - Select one or more fields used to group records in the list view. The selected order determines the grouping priority.

## **Interface**

The widget interface exhibits a list of records result from the query.

## Update field value

With Edit permissions, you have the ability to update one or multiple fields of the displayed records by clicking the edit icon next to the respective field.

## Open list view

Utilize the "**Open List View**" button to present the records in a list view, where you can access various functions such as export, bulk edit, bulk print, and more.

## Reload

Occasionally, the list may be refreshed in alternative locations, and you can select the **Reload** button to update the record list.

## Execute workflows

If one or more workflows are chosen in the settings, a list of workflows will appear, and you can initiate each workflow by clicking the "Execute Workflow" button.