# December 29, 2022 / SOC 2 Type II compliance, \[This ...\] in Formulas

**URL:** <https://community.fibery.io/t/december-29-2022-soc-2-type-ii-compliance-this-in-formulas/3751>\
**Category:** Changelog\
**Created:** [December 29, 2022, 2:48pm UTC](https://community.fibery.io/t/december-29-2022-soc-2-type-ii-compliance-this-in-formulas/3751 "2022-12-29T14:48:47Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![antoniokov](https://sea2.discourse-cdn.com/flex020/user_avatar/community.fibery.io/antoniokov/32/201_2.png) [@antoniokov](https://community.fibery.io/u/antoniokov)\
**Post date:** [December 29, 2022, 2:48pm UTC](https://community.fibery.io/t/december-29-2022-soc-2-type-ii-compliance-this-in-formulas/3751/1 "2022-12-29T14:48:47Z")

</div>

## 🔒 SOC 2 Type II certification

Last week, our company achieved a major milestone: the SOC 2 Type II certification.

This isn’t just any old certification you can buy off the internet for $9.99 (although we did consider it after 7 months in the process). No, this is the real deal - a rigorous audit of our controls and processes to ensure the security and privacy of our customers’ data.

So raise a glass (or a coffee mug, if it’s early) and join us in celebrating this achievement. Contact us via [new@fibery.io](mailto:new@fibery.io) to request a copy of our most recent report.

 ![image](https://us1.discourse-cdn.com/flex020/uploads/fibery/original/2X/6/6cab4e355a79ae204e9f6ebd89b6b61e3203405b.png)

## 👉 [This …] in Formulas

Now you can use the current Entity’s Field values within the `.Filter(…)` Formula function. For example, link Public Holidays to a Vacation to calculate the number of working days:

```plaintext
Employee.Location.[Public Holidays].Filter([This Vacation].Dates.Start() <= Date and [This Vacation].Dates.End() >= Date)

```

_(note the `[This Vacation]` syntax)_

This might look like a minor addition to Formulas but, in fact, this is a huge game-changer for advanced scenarios. Some of the use cases have previously required complex workaround with multiple Rules or auto-linking relations (Set relations automatically). Other scenarios have not been feasible altogether.

Here’s another example inspired by our customers. Find a Feature that the Team should be doing instead of the current one:

```plaintext
Team.Features.Filter([Public Id] != [This Feature].[Public Id] and RICE > [This Feature].RICE).Sort(Rice).Last()

```

And another one for good measure. Indicate if there is a dependency with a due date past the current Task’s due date:

```plaintext
[Depends On].Filter(State.Final = false and [Due Date] > [This Task].[Due Date]).Count() > 0

```

## 🦋 Minor Improvements

- Search by Database description, not just name
- Add new Entities via `+` Button in the relation View toolbar

## 🦐 Fixed Bugs

- Duplicated view don’t get selected in the left menu
- Cannot navigate to a related Entity in Entity History using alt+click
- There is no way to add a new Entity to the relation Feed View
- Duplicated entity appears in the relation Feed View only after page refresh
- Search should not look for description tags
- ‘Undefined’ in title for recurring, not all day events if they have no title
- Rename from left menu doesn’t work

---

<div class="post-metadata">

**Author:** ![antoniokov](https://sea2.discourse-cdn.com/flex020/user_avatar/community.fibery.io/antoniokov/32/201_2.png) [@antoniokov](https://community.fibery.io/u/antoniokov)\
**Post date:** [December 29, 2022, 2:53pm UTC](https://community.fibery.io/t/december-29-2022-soc-2-type-ii-compliance-this-in-formulas/3751/2 "2022-12-29T14:53:56Z")

</div>



---

<div class="post-metadata">

**Author:** ![ESGdataBoi](https://sea2.discourse-cdn.com/flex020/user_avatar/community.fibery.io/esgdataboi/32/11960_2.png) [@ESGdataBoi](https://community.fibery.io/u/ESGdataBoi)\
**Post date:** [December 29, 2022, 11:30pm UTC](https://community.fibery.io/t/december-29-2022-soc-2-type-ii-compliance-this-in-formulas/3751/3 "2022-12-29T23:30:13Z")

</div>

SOC II is here! This corporate boi is very happy.

---

<div class="post-metadata">

**Author:** ![didier](https://avatars.discourse-cdn.com/v4/letter/d/41988e/32.png) [@didier](https://community.fibery.io/u/didier)\
**Post date:** [December 30, 2022, 10:47am UTC](https://community.fibery.io/t/december-29-2022-soc-2-type-ii-compliance-this-in-formulas/3751/4 "2022-12-30T10:47:27Z")

</div>

Hi, wondering why SOC 2 and not ISO 27001? thanks

---

<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 30, 2022, 11:14am UTC](https://community.fibery.io/t/december-29-2022-soc-2-type-ii-compliance-this-in-formulas/3751/5 "2022-12-30T11:14:44Z")

</div>

Hm, SOC 2 was requested much more often by larger leads.

---

<div class="post-metadata">

**Author:** ![ChrisSparkT](https://sea2.discourse-cdn.com/flex020/user_avatar/community.fibery.io/chrissparkt/32/597_2.png) [@ChrisSparkT](https://community.fibery.io/u/ChrisSparkT)\
**Post date:** [January 4, 2023, 3:51pm UTC](https://community.fibery.io/t/december-29-2022-soc-2-type-ii-compliance-this-in-formulas/3751/6 "2023-01-04T15:51:05Z")

</div>

Thank you Fibery team. I don’t understand half of it but the SOC 2 compliance really is the thing to make our customers’ InfoSec and Privacy teams go away.