Summary:
Use Data filters to control which source records are forwarded by an interface.
Requirements:
- You need access to Interfaces.
- You need permission to edit the interface.
- The interface must have available source fields for filtering.
Use Data Filters in an Interface
Data filters help you send only the source data that matches the rules you define.
Open the Data filters tab
- Go to Interfaces.
- Open the interface you want to edit.
- If you are viewing the live version, select Create draft.
- If a draft already exists, select Show draft.
- Open the Data filters tab.
Changes can only be edited in a draft. Published or inactive versions may be read-only.
Add your first filter
- Select Add filters.
- Select Add a rule if the first rule is not already shown.
- In Select a field, choose the source field BrynQ should check.
- Choose an operator, for example Equals, Contains, Greater than, or Is empty.
- In Enter a value, enter the value the source data must match.
- Select Save filters.
Use a filter when only some source records should continue through the interface. For example, filter on a status field so only approved records are sent.
Build Filter Rules
Filter rules decide when a source record is included or excluded.
Choose the right operator
Use the operator that matches the type of check you need:
- Equals or Not equals checks for an exact value.
- Contains or Does not contain checks whether text includes a specific value.
- Greater than, Less than, Greater than or equal to, and Less than or equal to are useful for numbers or dates.
- Between needs two values and checks whether the source value is inside that range.
- Is empty and Is not empty check whether a field has a value. These options do not need an entered value.
Make the entered value match the format used by the source field. This helps BrynQ compare the data correctly.
Combine rules with AND or OR
When you add more than one rule, choose how BrynQ should combine them:
- AND means all connected rules must match.
- OR means at least one connected rule must match.
Use AND when every condition is required. Use OR when several values or cases are acceptable.
Use groups for more complex filters
- Select Add a group.
- Add one or more rules inside the group.
- Choose AND or OR between rules and groups.
- Use Copy when you want to reuse a similar group or rule.
- Use Delete only when the group or rule should no longer apply.
Groups are useful when you need separate sets of conditions, for example one set for new records and another set for changed records.
Finish and Review
Review the filter setup before you publish the draft.
Check the result before publishing
- Confirm every rule has a selected field and operator.
- Confirm every rule that needs a value has a value in Enter a value.
- Check the AND and OR choices so the filter matches the business rule you want.
- Select Save filters.
- Use Reset filters only if you want to discard the current filter changes and start again.
- Review the other required interface tabs, such as General, Scenarios, Mapping, and Schedule.
- Select Publish when the full draft is ready.
If Publish is disabled, complete the missing required information in the interface draft first.
More Information
Data filters affect which source records are forwarded by the interface. They do not replace field mapping or scheduling. Use Mapping to decide where fields go, and use Schedule to decide when the interface runs.
Related Articles
Interface Concepts and Lifecycle
Summary: Learn what a BrynQ interface is, which states it can have, and how it moves from setup to live use. Requirements: - You need access to Interfaces to view interfaces. - You need the correct permissions to create, edit, publish, or run an ...
Create Your First Interface
Summary: Create your first BrynQ interface by choosing a template or starting a custom interface with BrynQ support. Requirements: - You need Create interfaces permission. - The source and target apps must be active before you can use a template. - ...
Create an Interface from a Template
Summary: Create a new BrynQ interface by selecting a ready-made template and, when needed, activating the apps used by that template. Requirements: - You need the Create interfaces permission. - Your plan must have space for another interface. - If ...
Set Up Scenarios in a Template Interface
Summary: Set up Scenarios in an interface template so BrynQ knows which data flow each template step supports, which fields are required, and which mappings users must complete. Requirements: - You need access to Admin portal and permission to manage ...
Use Variables When Running an Interface
Summary: Use variables to enter run-specific values before BrynQ starts a manual interface run. Requirements: - You need access to Interfaces. - You need permission to run the interface. - The interface must be Active and have a Live version. - The ...