Question

Optimal way to filter list of objects in Microflows

1

Hi All, I have requirement to filter objects matching a text from a list. Filter should be case-insensitive. For this I am using below code, but the problem with this code is it is causing performance issue. Can any one recommend an optimal solution for this problem The reason I am doing list operation above instead of XPATH is Item objects are retrieved as part of different operation My domain model is as below

asked 2024-01-05

Mohan Reddy Kathireddy

1 answers

Mike Kumpf · Answer 1 · 2024-01-05

Because you are filtering on an associated entity, the database server already has indexed these two tables and the relationship between them. For this reason, the fastest way to get this information is with a database retrieve. When you have a large number of records, database retrieves are always faster than list operations.

If you want to do this with a list operation, I would recommend finding the Status object that meets your search criteria and then filter on the association using that object (if you find a number of status objects, you may get better performance by doing individual filters and using a Union actions to get a final list.