Synca Priority ERP icon

Synca Priority ERP

Interact with Priority ERP for Products, Sales, Purchase Orders, Agents, and Procedures

Actions29

Generic → Search Sub Form

AI-generated

Overview

This node operation allows users to search within a subform of a specified main form entity in the Synca Priority ERP system. It is useful for retrieving filtered and paginated data from nested subforms related to a parent entity, enabling detailed data queries within complex form structures. For example, a user can search for specific entries in a subform related to a customer or order by applying filters and selecting specific fields to return.

Use Case Examples

  1. Search for all subform entries related to a specific main entity ID with filters applied to certain fields.
  2. Retrieve a limited number of records from a subform with pagination support using skip and limit parameters.

Properties

Name Meaning
credentials Select the credentials to use for authenticating with the Synca Priority ERP system.
formName Select the main form to search on.
mainEntityId Set the ID of the parent entity to select and update its subforms.
subFormName Select the subform to search within the main form.
filters Add filters to narrow down the search results based on field values and operators.
fields Specify which fields to return in the search results; leave empty to return all fields.
limit Maximum number of results to return.
skip Number of items to skip for pagination.

Output

JSON

  • json - The JSON object containing the search results from the subform query.

Dependencies

  • Synca Priority ERP API credentials

Troubleshooting

  • Ensure that the 'mainEntityId' is correctly set to reference the parent entity; otherwise, the subform search will not work properly.
  • Filters must be correctly configured with valid fields and operators to avoid empty or incorrect results.
  • If no results are returned, verify that the 'formName' and 'subFormName' are correctly selected and that the filters are appropriate.

Links

Discussion