Record List by Query

Presents a curated list of records based on a user-defined query

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 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.

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.