Skip to main content

​
Use Cases

Query data from other forms within a core form. Applies to a wide range of data lookup scenarios, such as: ● In HR OA management systems, view your own employee records, Meeting reservation records, attendance records, and other data on the Profile home page.

​
1. Field Overview

Association Query is a standalone query and display feature. It automatically retrieves one or more records from other forms without saving them to the database. Component usage scope:
  1. Supported in all editions of YiDA (cross-platform compatible).
  2. Applies to YiDA regular form and workflow form page types. Not currently supported on custom pages.
  3. Because of how this component works, it is intended for pure data lookup or view scenarios that do not require submitting Data to the database. As a result, the component is currently available only on the form detail page. Other feature surfaces (such as the data management page) do not expose this component at this time.
  4. Show/hide logic in components such as dropdown Select and dropdown Multiselect can reference the “Association Query component”.

​
2. Field Attributes

​
2.0 General Attributes

General attributes of the Association Query component include:
  1. Title
  2. Status: Normal / Read-only / Hidden
  3. Content shown when there is no data: Custom supported

​
2.1 Association Attributes

Select an associated form. Both same-app and cross-App associations are supported.

​
2.2 Show Field

1

Show field: retrieve and display fields from a target associated form via Association Query

2

Added Show fields support Sort, Rename, Delete, and other actions

​
2.3 Data Filtering

Apply filters to the records returned by the Association Query. Records that match the Filter conditions appear in the corresponding fields.

​
2.4 Number of Records Displayed

Choose how Association Query results are displayed: “Single record” or “Multiple records”. a. “Single record”: Suited for associated detail lookups. Displays the most recently submitted record in submission order. b. “Multiple records”: Suited for associated list lookups. All records that meet the Filter and other constraints appear together in the List. i. When the associated form is a workflow form, only records with an instance status of “Completed” can be queried.

​
2.5 Associated Table Actions

When the associated form has no data, if the display mode is set to “Multiple records”, select “Allow record creation” for the associated table. Records can then be added directly to the target form from within the List. ⚠️ Note: If the current associated form is a workflow form, adding records is not supported, and only records with a status of “Completed” are displayed.

​
3. Notes

  1. The Association Query List displays at most 5,000 records.
  2. When querying workflow form data via Association Query, only records whose workflow status is Completed are returned.
  3. Public access cannot be enabled while this Component is present on a Page.
  4. Records returned by the Association Component inherit the scope of the form’s field permissions and Data Permissions.
  5. If the associated form has been deleted, an error message appears: