# Asset and Sequence Filter

**URL:** <https://community.shotgridsoftware.com/t/asset-and-sequence-filter/8172>\
**Category:** Flow Production Tracking\
**Created:** [April 14, 2020, 12:55pm UTC](https://community.shotgridsoftware.com/t/asset-and-sequence-filter/8172 "2020-04-14T12:55:08Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![barbaraB](https://avatars.discourse-cdn.com/v4/letter/b/48db29/32.png) [@barbaraB](https://community.shotgridsoftware.com/u/barbaraB)\
**Post date:** [April 14, 2020, 12:55pm UTC](https://community.shotgridsoftware.com/t/asset-and-sequence-filter/8172/1 "2020-04-14T12:55:08Z")

</div>

Hello everybody,

I`m new in this forum so I hope that my post will be correct 🙂

I`m looking for a way to make a filter in SG with an association 1 to 1 between an asset and a sequence.  
For exemple:  
Sequence1 Asset1  
Sequence1 Asset2  
Sequence2 Asset1  
Sequence3 Asset2  
etc  
Right now I have a field Sequence in Asset (and a field Asset in Sequence) but inside the cell there is a list of elements.

Second question: is there an automatic way to connect assets, shots and sequences? If I know which assets are in a shot and which shots are in a sequence, can SG update the link ‘Asset-Sequence’?

Can you help me, please?

Thanks

---

<div class="post-metadata">

**Author:** ![Ben\_xzj](https://sea1.discourse-cdn.com/shotgunsoftware/user_avatar/community.shotgridsoftware.com/ben_xzj/32/289_2.png) [@Ben\_xzj](https://community.shotgridsoftware.com/u/Ben_xzj)\
**Post date:** [April 15, 2020, 2:06am UTC](https://community.shotgridsoftware.com/t/asset-and-sequence-filter/8172/2 "2020-04-15T02:06:01Z")

</div>

Hi @barbaraB,

Welcome to the forum and thanks for posting here!

To see the association of two entities, you have to expose the connection entities between, for example, asset and sequence, from the `Site Preferences > Advanced > Enable List Pages for Connection Entity Types` site preference. An example of `Asset_Shot_Connection` entity:

 ![Screenshot_2020_4_15__10_04_AM](https://global.discourse-cdn.com/shotgunsoftware/original/2X/5/52dff4148feeb8319af1547d33b1393cfb6cf743.png)

Check the doc [here](https://support.shotgunsoftware.com/hc/en-us/articles/114094036254-Using-connection-entities) for more information.

To answer your second question, while linking an asset to a shot, even though the shot is associated to a sequence, Shotgun will not automatically fill in the `Assets` field on `Sequences` entity. You probably need to script a bit here and write an Shotgun event trigger. See the doc [here](https://support.shotgunsoftware.com/hc/en-us/articles/219031298-Writing-event-driven-triggers).

---

<div class="post-metadata">

**Author:** ![barbaraB](https://avatars.discourse-cdn.com/v4/letter/b/48db29/32.png) [@barbaraB](https://community.shotgridsoftware.com/u/barbaraB)\
**Post date:** [April 15, 2020, 9:28am UTC](https://community.shotgridsoftware.com/t/asset-and-sequence-filter/8172/3 "2020-04-15T09:28:32Z")

</div>

Thanks Ben\_xzj! It`s very useful 🙂

I still have a question though: I`m able to see the Asset\_shot\_Connection but when I go to

`Site Preferences > Advanced > Enable List Pages for Connection Entity Types`

and I try to create Asset Sequence connection I see a page with data that don`t belong to my database (even though I have filled the Multi entity in the Sequence page).

---

<div class="post-metadata">

**Author:** ![brandon.foster](https://sea1.discourse-cdn.com/shotgunsoftware/user_avatar/community.shotgridsoftware.com/brandon.foster/32/91_2.png) [@brandon.foster](https://community.shotgridsoftware.com/u/brandon.foster)\
**Post date:** [April 15, 2020, 11:47am UTC](https://community.shotgridsoftware.com/t/asset-and-sequence-filter/8172/4 "2020-04-15T11:47:05Z")

</div>

Hi Barbara!

The `Asset <-> Shot` relationship is separate from the `Asset <-> Sequence` relationship, so updating one does not populate the other automatically. It sounds like you just want to link your Assets to Shots, and then be able to see a roll-up at the Sequence level of all the Assets which appear in all the Shots which belong to that Sequence, is that correct?

If the answer is “yes”, you can accomplish this by tweaking the filter on your Sequence detail page, Assets tab like this:

 ![image](https://global.discourse-cdn.com/shotgunsoftware/original/2X/c/c284df1bd8d80fdc24ff32185e76b726bd43dcbc.jpeg)

This way, the tab will display any Assets linked directly to the Sequence, OR any Assets, linked to Shots, linked to this Sequence. Let us know if that gets you the sort of visibility you’re after!