# \[✔️DONE\] Find Entity for Automation Rules

**URL:** <https://community.fibery.io/t/done-find-entity-for-automation-rules/2212>\
**Category:** Ideas & Features\
**Tags:** automations\
**Created:** [November 11, 2021, 12:14pm UTC](https://community.fibery.io/t/done-find-entity-for-automation-rules/2212 "2021-11-11T12:14:24Z")\
**Posts on this page:** 5\
**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:** [November 11, 2021, 12:14pm UTC](https://community.fibery.io/t/done-find-entity-for-automation-rules/2212/1 "2021-11-11T12:14:24Z")

</div>

Entity Find Query Examples:

```auto
Users.Sort([Count of Open Assignments]).First()

Iterations.Filter(StartDate <= Today() and EndDate >= Today()).First()

Iterations.Filter([Step 1 Iteration].StartDate < StartDate).Sort(StartDate).First()

Users.Filter(Role=`QA`) //for multi-assignment should work as well

```

---

<div class="post-metadata">

**Author:** ![Matt\_Blais](https://sea2.discourse-cdn.com/flex020/user_avatar/community.fibery.io/matt_blais/32/1464_2.png) [@Matt\_Blais](https://community.fibery.io/u/Matt_Blais)\
**Post date:** [November 11, 2021, 8:44pm UTC](https://community.fibery.io/t/done-find-entity-for-automation-rules/2212/2 "2021-11-11T20:44:20Z")

</div>

Great! 💪

What is “Iterations” – just an example field name, or a new operator/function?

---

<div class="post-metadata">

**Author:** ![Chr1sG](https://sea2.discourse-cdn.com/flex020/user_avatar/community.fibery.io/chr1sg/32/3941_2.png) [@Chr1sG](https://community.fibery.io/u/Chr1sG)\
**Post date:** [November 11, 2021, 9:38pm UTC](https://community.fibery.io/t/done-find-entity-for-automation-rules/2212/3 "2021-11-11T21:38:30Z")

</div>

I think Iterations is supposed to be an example name of a ~~type~~ database 😉

---

<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:18am UTC](https://community.fibery.io/t/done-find-entity-for-automation-rules/2212/4 "2021-12-02T07:18:49Z")

</div>

Implemented [CHANGELOG: Dec 2 / Entity finder for automation formulas, Prevent infinite loops in formulas](https://community.fibery.io/t/changelog-dec-2-entity-finder-for-automation-formulas-prevent-infinite-loops-in-formulas/2288)

---

<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 19, 2021, 6:30am UTC](https://community.fibery.io/t/done-find-entity-for-automation-rules/2212/5 "2021-12-19T06:30:00Z")

</div>


