Overview
The node named "EAVFW" is designed to interact with the EAVFW environment, specifically allowing users to query records from a specified table. It enables filtering records based on multiple search criteria with various comparison operators. This node is useful in scenarios where you need to retrieve data dynamically from an EAVFW-managed database or system by specifying conditions such as equality, inequality, or range comparisons.
Practical examples include:
- Fetching user records where the status equals "active".
- Retrieving orders with amounts greater than a certain value.
- Searching for entries where a text field matches a specific string ignoring case sensitivity.
Properties
| Name | Meaning |
|---|---|
| Table | The target table within the EAVFW environment from which to query records. |
| Search Criteria | One or more conditions to filter the records. Each condition includes: |
| - Field Name: The field in the table to apply the condition on. | |
| - Operator: Comparison operator to use (Equal, Not Equal, Greater Than, Greater Than or Equal, Less Than, Less Than or Equal). | |
| - Right: The value to compare the field against. | |
| Options | Additional options affecting query behavior: |
| - Ignore Case: Whether to ignore letter case when evaluating conditions (true/false). | |
| - Less Strict Type Validation: Whether to attempt casting value types based on the selected operator (true/false). |
Output
The node outputs JSON data representing the queried records matching the specified criteria from the selected table. Each output item corresponds to a record retrieved from the EAVFW environment. If binary data is present in any fields, it would be included accordingly, but this is not explicitly detailed in the provided code.
Dependencies
- Requires an API authentication token configured via OAuth2 credentials to connect securely to the EAVFW environment.
- Relies on internal methods to load available tables and fields dynamically for user selection.
- No other external services are indicated beyond the authenticated connection to EAVFW.
Troubleshooting
- Common Issues:
- Incorrect or missing API authentication may cause connection failures.
- Specifying a non-existent table or field will result in errors or empty results.
- Mismatched data types in search criteria might lead to no matches unless "Less Strict Type Validation" is enabled.
- Error Messages:
- Authentication errors typically indicate invalid or expired credentials; re-authenticate or update credentials.
- Validation errors on input properties suggest incorrect table or field names; verify selections.
- Empty results may mean no records match the criteria; try adjusting filters or disabling case sensitivity.
Links and References
- No direct external links are provided in the source code.
- For further details, consult the official EAVFW environment documentation or API reference related to querying records.