Get by filter

The Get Records by Filter operation allows you to retrieve multiple records from a dictionary table based on custom criteria.

🎯 What does this operation do?

This operation allows searching records within a dictionary table using custom filters.

✅ Main features:

• Retrieves multiple records based on specific criteria.

• Allows applying filters to refine the search.

• Can be used to load dynamic lists or validate information.

📂 How to Configure the "Search by Filter" Operation

1️⃣ Access the Component

1. In Hablla Studio, open the automation flow where you want to search records in the dictionary.

2. Add the block "Dictionary".

3. In the right side panel, select the operation "Search by Filter".

2️⃣ Fill in the Required Fields

Field	Data Type	Required?	Description
Workspace ID	string	✅ Yes	Workspace ID where the dictionary table is located.
Table Name	string	✅ Yes	Name of the dictionary table where the records are stored.

3️⃣ Add Filters (Optional)

In addition to the required fields, you can set filters to refine the search.

Filter	Data Type	Description
Custom Fields	collection	Allows selecting which dictionary fields should be used as filters.
Filter Method	string (fields or query)	Defines whether the search will be based on specific fields or on a query string.
Sorting	string (asc or desc)	Defines ascending order (asc) or descending order (desc) of the results.
Page	number	Allows defining the search page for result pagination.
Limit	number	Defines how many records should be returned at a time.

⚠️ Attention!

• If no filter is applied, the search will return all records from the table.

• Use pagination to avoid excessive return of records.

4️⃣ Save the Configuration

After filling in the fields and setting the filters, click the "Save" ✅.

Now, whenever this automation is triggered, the filtered records will be returned automatically.

📌 Usage Example in an Automation Flow

📊 Scenario: You want to fetch all customers registered in the table "Customers" of the dictionary who are in the status "Active".

🔹 Automation flow:

1️⃣ Block 1 → Trigger an automation whenever a customer performs an action. 2️⃣ Block 2 → Search the dictionary for all customers with status "Active". 3️⃣ Block 3 → Send a personalized message to those customers.

🚀 Result: The automation filters and returns only the relevant records, allowing targeted and segmented communications.

🎉 Conclusion

The operation Search Records by Filter in the Dictionary is ideal for finding specific information in a dynamic and personalized way. With this feature, you can optimize searches and make your automations even smarter in Hablla Studio.

If you need more support, contact our team! 🚀