# Struggling with Context Views **URL:** \ **Category:** Get Help\ **Created:** [January 5, 2024, 7:52am UTC](https://community.fibery.io/t/struggling-with-context-views/5636 "2024-01-05T07:52:29Z")\ **Posts on this page:** 16\ **Page:** 1
**Author:** ![interr0bangr](https://sea2.discourse-cdn.com/flex020/user_avatar/community.fibery.io/interr0bangr/32/8089_2.png) [@interr0bangr](https://community.fibery.io/u/interr0bangr)\ **Post date:** [January 5, 2024, 7:52am UTC](https://community.fibery.io/t/struggling-with-context-views/5636/1 "2024-01-05T07:52:29Z")
I’m trying to get a view inside of my Sprint entity to contextually display the following levels, but it’s not playing nice with the context filters. ![Week-2-Jan-8-14-2024-—-Sprint-Fibery](https://us1.discourse-cdn.com/flex020/uploads/fibery/original/2X/a/aedb302e97ff0204b9361a77fe6fc87896d7c923.png) The databases are related like this: Client (1-m) Programs (1-m) Releases (1-m) Iterations (m-m) Sprints So I was expecting to see an option like this in the context filter: “Clients from Programs from Releases from Iterations” but I’m getting nothing really close to that. Could anyone help tell me where I’ve gone wrong here? ---
**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:** [January 5, 2024, 2:54pm UTC](https://community.fibery.io/t/struggling-with-context-views/5636/2 "2024-01-05T14:54:07Z")
“Looking up” a related entity indirectly through multiple levels of relations must be done explicitly. Create the following [Lookup](https://the.fibery.io/@public/User_Guide/Guide/Email-Integration-(Gmail-IMAP)-66#Guide/Lookups-16) fields: - in Release, Lookup Client via Program - In Iteration, Lookup Client via Release You might also want: - in Iteration, Lookup Program via Release ---
**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:** [January 5, 2024, 3:01pm UTC](https://community.fibery.io/t/struggling-with-context-views/5636/3 "2024-01-05T15:01:44Z")
I would also just add that the info [here](https://the.fibery.io/@public/User_Guide/Guide/Context-View-20) may be useful, and in particular, a lot of people are tripped up by this: ![image](https://us1.discourse-cdn.com/flex020/uploads/fibery/original/2X/b/b2dd515fc7d2c1439ecc3c746ad18e361917c2af.png) ---
**Author:** ![interr0bangr](https://sea2.discourse-cdn.com/flex020/user_avatar/community.fibery.io/interr0bangr/32/8089_2.png) [@interr0bangr](https://community.fibery.io/u/interr0bangr)\ **Post date:** [January 5, 2024, 6:58pm UTC](https://community.fibery.io/t/struggling-with-context-views/5636/4 "2024-01-05T18:58:29Z")
> [@Matt\_Blais](#): > > “Looking up” a related entity indirectly through multiple levels of relations must be done explicitly. > > Create the following [Lookup](https://the.fibery.io/@public/User_Guide/Guide/Email-Integration-(Gmail-IMAP)-66#Guide/Lookups-16) fields: > > - in Release, Lookup Client via Program > - In Iteration, Lookup Client via Release > > You might also want: > > - in Iteration, Lookup Program via Release I appreciate the help, but that didn’t seem to do the trick, although maybe I didn’t articulate my struggles well enough. 😛 My issue isn’t about getting the context filter to show the hierarchy I want, but that it’s not handling the filtering of the entities that I am expecting it to have. When looking at a list view within a Sprint entity, **I only want to see Iterations that are linked to the Sprint** , but I want those Iterations to be visually nested underneath a Client → Program → Release → Iteration hierarchy. I’ve been assuming that with the power of Context Views, this would be possible, but no matter how I seem to set things up, **all Iterations that are linked to the Release are getting displayed, including ones that are not linked to the Sprint**. ![Test-Sprint-1-—-Sprint-Fibery](https://us1.discourse-cdn.com/flex020/uploads/fibery/original/2X/2/23893040c481cb5496d6ade21d4c3af105462033.jpeg) I created a completely fresh, test database to help show how things are setup: ![f1](https://us1.discourse-cdn.com/flex020/uploads/fibery/original/2X/f/f07410b35381b62b3475b1d76cae1a1d058048f1.jpeg) ![f2](https://us1.discourse-cdn.com/flex020/uploads/fibery/original/2X/0/02c5cf31a218d74206d8bde0456d1f76a0ff83d1.jpeg) ![f3](https://us1.discourse-cdn.com/flex020/uploads/fibery/original/2X/5/5f04db2ee330071e2bd2fb91bfb9cee17a7fb9eb.jpeg) ![f4](https://us1.discourse-cdn.com/flex020/uploads/fibery/original/2X/4/4283129ee20fae4156ce06fd104aee67637d71e4.jpeg) ![f5](https://us1.discourse-cdn.com/flex020/uploads/fibery/original/2X/2/2b7778784d41162b9588c6ae219900cd79c63967.jpeg) ---
**Author:** ![interr0bangr](https://sea2.discourse-cdn.com/flex020/user_avatar/community.fibery.io/interr0bangr/32/8089_2.png) [@interr0bangr](https://community.fibery.io/u/interr0bangr)\ **Post date:** [January 5, 2024, 8:44pm UTC](https://community.fibery.io/t/struggling-with-context-views/5636/5 "2024-01-05T20:44:28Z")
I will add that this behavior happens across all levels as well, not just Iterations. If the Client has multiple Programs or a Program has multiple releases linked to it, they all show up too. The context filter literally says: > On the List you **see** only [Entities] from [Test Sprint 1] But I “see” many entities that are not. Maybe what I ultimately need here is the “Formulas In Filters” feature, which is a wall I’ve been running into almost every single day in Fibery. ☹ ---
**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:** [January 5, 2024, 9:48pm UTC](https://community.fibery.io/t/struggling-with-context-views/5636/6 "2024-01-05T21:48:43Z")
I’m a bit confused here, because based on your initial description of the connections between databases: > [@interr0bangr](#): > > Client (1-m) Programs (1-m) Releases (1-m) Iterations (m-m) Sprints I don’t know how you have even reached the option to include the database levels in your relation view (in the Sprint entity view): ![Week-2-Jan-8-14-2024-—-Sprint-Fibery](https://us1.discourse-cdn.com/flex020/uploads/fibery/original/2X/a/aedb302e97ff0204b9361a77fe6fc87896d7c923.png) If I set up my database as you describe, the only options to choose for a list view are Iterations and Sprints, representing the only viable context paths: ![image](https://us1.discourse-cdn.com/flex020/uploads/fibery/original/2X/8/8a5efe4f69f317742743341b36c7d569b8032e0d.png) Prior to any playing with lookups etc, what other relationships existed (apart from those you initially mentioned)? ---
**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:** [January 5, 2024, 10:05pm UTC](https://community.fibery.io/t/struggling-with-context-views/5636/7 "2024-01-05T22:05:29Z")
Assuming that you do have the lookups in place (so that a Client has a lookup field that shows all related Sprints) then I think the issue is a misunderstanding of how the context filter works. When I set up like that, I have the option to create the hierarchy as you showed, and the context filter is as follows: ![image](https://us1.discourse-cdn.com/flex020/uploads/fibery/original/2X/7/7aaf64c683423d042636cc49cc743c845cd0d5cc.png) So what is happening is this: Imagine that the relationship is that of a tree: Client = trunk Program = branch Release = twig Iteration = leaf Sprint = insect visiting multiple leaves (!) Your context view is limited to only the tree trunk (Client) that the insect (Sprint) is on, and for that trunk, show **all** its branches, twigs and leaves irrespective of whether the insect has visited them all. The context filter does **not** just show the trunk + only its branches with twigs that have leaves the insect has visited + only the twigs that have leaves the insect has visited + only the leaves the insect has visited. ---
**Author:** ![interr0bangr](https://sea2.discourse-cdn.com/flex020/user_avatar/community.fibery.io/interr0bangr/32/8089_2.png) [@interr0bangr](https://community.fibery.io/u/interr0bangr)\ **Post date:** [January 5, 2024, 10:21pm UTC](https://community.fibery.io/t/struggling-with-context-views/5636/8 "2024-01-05T22:21:43Z")
Hey @Chr1sG , I already had lookup fields equivalent to what @Matt_Blais had mentioned, so displaying the levels in my screenshot was never the issue. Contextually filtering the entities that are actually displayed in each of those levels is what I’m trying to solve, does that make sense? The context filter seems to only filter out the top level, when I was expecting it to filter out all levels. I think any of these 3 things would solve my issue: **1. If the context filter was truly applied to “All Databases” like the UI implies it is.** ![Week-2-Jan-8-14-2024-—-Sprint-Fibery (1)](https://us1.discourse-cdn.com/flex020/uploads/fibery/original/2X/0/0247c77886e86cbc31115ab7e378599769783fea.jpeg) **2. If there were unique context filters available at each level** ![Test-Sprint-1-Growth-—-Sprint-Fibery](https://us1.discourse-cdn.com/flex020/uploads/fibery/original/2X/3/370e035711d88934c424df8f52bd4666c28d7dc2.jpeg) **3. If there was a way to add a formula to a filter so I could add it to each database layer.** i.e. Client: Sprint = [This Sprint] Program: Sprint = [This Sprint] Release: Sprint = [This Sprint] Iteration: Sprint = [This Sprint] If there’s any workarounds you can think of to get contextual filtering across each database level in a view, I would be eternally grateful! ---
**Author:** ![interr0bangr](https://sea2.discourse-cdn.com/flex020/user_avatar/community.fibery.io/interr0bangr/32/8089_2.png) [@interr0bangr](https://community.fibery.io/u/interr0bangr)\ **Post date:** [January 5, 2024, 10:30pm UTC](https://community.fibery.io/t/struggling-with-context-views/5636/9 "2024-01-05T22:30:23Z")
> [@Chr1sG](#): > > Your context view is limited to only the tree trunk (Client) that the insect (Sprint) is on, and for that trunk, show **all** its branches, twigs and leaves irrespective of whether the insect has visited them all. > > The context filter does **not** just show the trunk + only its branches with twigs that have leaves the insect has visited + only the twigs that have leaves the insect has visited + only the leaves the insect has visited. Not the answer I was hoping for, but it is what it is. Thanks for explaining it so clearly and definitively! That said, is there a workaround? 🙂 Or am I doomed to manually change multiple filters each sprint until the end of time? Appreciate your help as always! ---
**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:** [January 5, 2024, 10:34pm UTC](https://community.fibery.io/t/struggling-with-context-views/5636/10 "2024-01-05T22:34:14Z")
> [@interr0bangr](#): > > If the context filter was truly applied to “All Databases” like the UI implies it is. I think you are right to point out that displaying the context filter (which only applies to the root level) when the ‘All databases’ section is highlighted is misleading, however, it does say that it is filtering for ‘Clients via …’ not generically ‘Entities via …’. > [@interr0bangr](#): > > If there were unique context filters available at each level > … > If there was a way to add a formula to a filter so I could add it to each database layer. You are actually on to something that we have had in our backlog, which is to implement context filters as merely a specific case of ‘dynamic filters’ in the greater context of flexible filters including support for formulas. Unfortunately, we don’t know when we’ll get to it, and no guarantees that the first version will support multiple layers of querying (which I kinda think your case would need if lookups are to be avoided). ---
**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:** [January 5, 2024, 10:37pm UTC](https://community.fibery.io/t/struggling-with-context-views/5636/11 "2024-01-05T22:37:09Z")
> [@interr0bangr](#): > > If there’s any workarounds you can think of to get contextual filtering across each database level in a view, I would be eternally grateful! My suggestion would be to approach it from the other direction and add lookups to the Iteration db to show the parent Release, Program and Client, and then use a table view with these columns shown: ![image](https://us1.discourse-cdn.com/flex020/uploads/fibery/original/2X/c/cea2e8c3f16cd5b8f0402445442141b638b51e61.png) It’s not a nice hierarchical view, but if you add sorting by Client, then by Program, then by Release, you will get things in a somewhat logical order. ---
**Author:** ![interr0bangr](https://sea2.discourse-cdn.com/flex020/user_avatar/community.fibery.io/interr0bangr/32/8089_2.png) [@interr0bangr](https://community.fibery.io/u/interr0bangr)\ **Post date:** [January 5, 2024, 11:03pm UTC](https://community.fibery.io/t/struggling-with-context-views/5636/12 "2024-01-05T23:03:44Z")
> [@Chr1sG](#): > > I think you are right to point out that displaying the context filter (which only applies to the root level) when the ‘All databases’ section is highlighted is misleading, however, it does say that it is filtering for ‘Clients via …’ not generically ‘Entities via …’. Yeah, if the context filter was only displayed on the root database and not in the “All Databases” section I wouldn’t have assumed it would be applied globally. When you have a lot of databases and relationships, that filtering dropdown gets absolutely insanely full and is basically unusable (half of the options don’t even fit on the screen) so I kind of gave up trying to understand it. > [@Chr1sG](#): > > You are actually on to something that we have had in our backlog, which is to implement context filters as merely a specific case of ‘dynamic filters’ in the greater context of flexible filters including support for formulas. > Unfortunately, we don’t know when we’ll get to it, and no guarantees that the first version will support multiple layers of querying (which I kinda think your case would need if lookups are to be avoided). I don’t love having a lot of lookups that make entities look messy/unpure, but that’s just reality of Fibery without more advanced filtering options. If that’s what the first version of more dynamic filters would require, I’d have no problem doing it! Is there a specific feature request somewhere for this I could put a vote on? > [@Chr1sG](#): > > My suggestion would be to approach it from the other direction and add lookups to the Iteration db to show the parent Release, Program and Client, and then use a table view with these columns shown. > > It’s not a nice hierarchical view, but if you add sorting by Client, then by Program, then by Release, you will get things in a somewhat logical order. Looking at entities in context with other entities is very important to us and probably the biggest reason I’m trying to migrate away from ClickUp and into Fibery. That said, I feel the table view is the least flexible and contextual way to look at our data, which is why list view is so important. Once the “grouping by fields” feature is done (sounds like it’s a Q1 2024 thing) it will make all the views (especially table view) infinitely more flexible and mitigate our need to have everything displayed in a hierarchal fashion, so I’m really looking forward to that! ---
**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:** [January 5, 2024, 11:33pm UTC](https://community.fibery.io/t/struggling-with-context-views/5636/13 "2024-01-05T23:33:46Z")
> [@interr0bangr](#): > > Is there a specific feature request somewhere for this I could put a vote on? I’ll link this topic to the feature in our internal feedback handling, so that will effectively count as a vote 🙂 ---
**Author:** ![cannibalflea](https://sea2.discourse-cdn.com/flex020/user_avatar/community.fibery.io/cannibalflea/32/318_2.png) [@cannibalflea](https://community.fibery.io/u/cannibalflea)\ **Post date:** [January 9, 2024, 9:15pm UTC](https://community.fibery.io/t/struggling-with-context-views/5636/14 "2024-01-09T21:15:43Z")
@Chr1sG further to what @interr0bangr mentioned: > [@interr0bangr](#): > > **If there were unique context filters available at each level** > > ![Test-Sprint-1-Growth-—-Sprint-Fibery](https://us1.discourse-cdn.com/flex020/uploads/fibery/original/2X/3/370e035711d88934c424df8f52bd4666c28d7dc2.jpeg) Has there been any consideration of enabling something similar to the [Dynamic Relation Filters](https://the.fibery.io/@public/User_Guide/Guide/Relation-Filters-and-Sorts-177/anchor=Using-dynamic-values--63cb8e1d-2c01-4760-9a72-bef50ec94838) to allow lower levels of the hierarchy to access the filter? ![image](https://us1.discourse-cdn.com/flex020/uploads/fibery/original/2X/1/160750452e7830a7ad28f1fc4e97e2ca7cb08472.jpeg) This way, the context filtering doesn’t have to traverse up the full tree (and guess which field to filter against), but is available as a value for the creator to strategically apply to particular fields at particular levels just like normal filters. This is something I’m struggling with and would greatly benefit from as well. It is also something that I don’t think formulas in filters are going to address since they need the view context rather than working on any of the entity data. ---
**Author:** ![interr0bangr](https://sea2.discourse-cdn.com/flex020/user_avatar/community.fibery.io/interr0bangr/32/8089_2.png) [@interr0bangr](https://community.fibery.io/u/interr0bangr)\ **Post date:** [January 10, 2024, 7:02am UTC](https://community.fibery.io/t/struggling-with-context-views/5636/15 "2024-01-10T07:02:31Z")
> [@cannibalflea](#): > > Has there been any consideration of enabling something similar to the [Dynamic Relation Filters](https://the.fibery.io/@public/User_Guide/Guide/Relation-Filters-and-Sorts-177/anchor=Using-dynamic-values--63cb8e1d-2c01-4760-9a72-bef50ec94838) to allow lower levels of the hierarchy to access the filter? That would be a valid solution too! I’m not sure how hard these things are for the Fibery to implement but I can tell you that I just spent almost a full day building a crazy amount of ugly formulas and one-off administrative fields across all my databases to be able to solve this with a single filter on the “All Databases” level. It’s still a manual filter that needs to be changed every sprint until the end of time, but it’s better than nothing. ![New-list-Fibery](https://us1.discourse-cdn.com/flex020/uploads/fibery/original/2X/b/b8a483313241d3a302c294bab6e03308c0833c82.png) Formulas in fields would still be my #1 preference as a solution because it would help with way, way more than just filtering and I could see myself using it in many other situations. ---
**Author:** ![Yuri\_BC](https://sea2.discourse-cdn.com/flex020/user_avatar/community.fibery.io/yuri_bc/32/8803_2.png) [@Yuri\_BC](https://community.fibery.io/u/Yuri_BC)\ **Post date:** [January 10, 2024, 12:15pm UTC](https://community.fibery.io/t/struggling-with-context-views/5636/16 "2024-01-10T12:15:12Z")
I came across this limitation too, and maybe its useful to create a dedicated feature request topic in order to collect user ideas around it. Its useful to give a more descriptive title to this/that topic, such as “Enhanced Contextual Filtering for Hierarchical Entity Relationships in Views”.