# CHANGELOG: Dec 2 / Entity finder for automation formulas, Prevent infinite loops in formulas

**URL:** <https://community.fibery.io/t/changelog-dec-2-entity-finder-for-automation-formulas-prevent-infinite-loops-in-formulas/2288>\
**Category:** Changelog\
**Created:** [December 2, 2021, 6:50am UTC](https://community.fibery.io/t/changelog-dec-2-entity-finder-for-automation-formulas-prevent-infinite-loops-in-formulas/2288 "2021-12-02T06:50:35Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![mdubakov](https://sea2.discourse-cdn.com/flex020/user_avatar/community.fibery.io/mdubakov/32/10_2.png) [@mdubakov](https://community.fibery.io/u/mdubakov)\
**Post date:** [December 2, 2021, 6:50am UTC](https://community.fibery.io/t/changelog-dec-2-entity-finder-for-automation-formulas-prevent-infinite-loops-in-formulas/2288/1 "2021-12-02T06:50:35Z")

</div>

## 👀 Entity query finder for automation formulas

Now you can use queries to find entities from **any** database in **automation rules or action buttons**. It is very useful when the value should be set dynamically. For example, current sprint or next sprint can be found and set for a user story sprint field.

For example, you can move all open stories to the next sprint with a single click:

 ![finder](https://us1.discourse-cdn.com/flex020/uploads/fibery/original/2X/f/f771c0077ecaab2d04ce0ea1431201f8cbbc714e.png)

This query finds the next sprint:

```auto
Sprints.Filter((Dates.Start() > Today()) and ([Step 1 Sprint].Dates.End() < Dates.Start())).Sort(Dates.Start(), false).First()

```

Do not forget to use **Sort** and **First** at the end of the query to select one value for setting one-to-one relations.

More queries examples:

```auto
Sprints.Filter(Dates.Start() <= Today() and Dates.End() >= Today()).Sort().First()

Sprints.Filter([Step 1 Sprint].StartDate < StartDate).Sort(StartDate).First()

Users.Filter(Role=`QA`)

```

## 🐉 Prevent infinite loops in Formulas

We’ve improved incorrect and broken formulas identification. Now Fibery:

- Disables broken and looping Formulas
- Shows that Formula is disabled in editor
- Notifies Admins when Formula is disabled

## 🦐 Fixed Bugs

- Rich edit: Undo doesn’t work correctly in table
- Rich edit: Focus is getting lost when a user adds or deletes a column or a row in the table, so undo doesn’t work
- Rich edit: An error if a user deletes a point in the list in some case
- Table View: Non-creators are able to Hide columns
- Automations: Misleading counter in activity log
- Automations: Error when an action doesn’t return any object in the conditions
- Sometimes Space import fails by timeout
- Board View: empty string in text field is not filtered with “IsEmpty” filter

---

<div class="post-metadata">

**Author:** ![mdubakov](https://sea2.discourse-cdn.com/flex020/user_avatar/community.fibery.io/mdubakov/32/10_2.png) [@mdubakov](https://community.fibery.io/u/mdubakov)\
**Post date:** [December 2, 2021, 7:04am UTC](https://community.fibery.io/t/changelog-dec-2-entity-finder-for-automation-formulas-prevent-infinite-loops-in-formulas/2288/2 "2021-12-02T07:04:27Z")

</div>