# Listing subassets

**URL:** <https://community.shotgridsoftware.com/t/listing-subassets/10977>\
**Category:** Flow Production Tracking\
**Created:** [December 9, 2020, 11:19pm UTC](https://community.shotgridsoftware.com/t/listing-subassets/10977 "2020-12-09T23:19:07Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![bonosmo](https://sea1.discourse-cdn.com/shotgunsoftware/user_avatar/community.shotgridsoftware.com/bonosmo/32/2622_2.png) [@bonosmo](https://community.shotgridsoftware.com/u/bonosmo)\
**Post date:** [December 9, 2020, 11:19pm UTC](https://community.shotgridsoftware.com/t/listing-subassets/10977/1 "2020-12-09T23:19:07Z")

</div>

Hi,  
I’d like to create an asset list for a sequence.

My sequences are simple, just a collection of assets. I can get those to show up easily, but is there a way to display those assets’s subassets as well without having to link them to the sequence entity?

For instance, I have “Sequence\_001” that contains an asset “Char\_001”, which contains “Sword\_001” and “Hat\_001”. How can I display a “Sequence \_001” asset list that contains “Char\_001”, “Sword\_001” and “Hat\_001” without linking every subasset to the “Sequence\_001”?

Thanks,  
Bonnie

---

<div class="post-metadata">

**Author:** ![matt.welker](https://sea1.discourse-cdn.com/shotgunsoftware/user_avatar/community.shotgridsoftware.com/matt.welker/32/287_2.png) [@matt.welker](https://community.shotgridsoftware.com/u/matt.welker)\
**Post date:** [December 14, 2020, 5:18pm UTC](https://community.shotgridsoftware.com/t/listing-subassets/10977/2 "2020-12-14T17:18:14Z")

</div>

Hi Bonnie,

There is a way to do this with a Query Field. It will display the count of Sub Assets. You can click the count to display a popup grid with the contents.

The Query Field would look like this (and it is a little confusing):

 ![Screen Shot 2020-12-14 at 9.02.20 AM](https://global.discourse-cdn.com/shotgunsoftware/original/2X/7/7eeb4866b89612dd27ee199f7f7577dfe3d09b95.png)

you need to scroll to the bottom and select the Linked Fields -\> Parent Assets/(linked)Sub Assets/(linked) Parent Assets/Sequence):

 ![Screen Shot 2020-12-14 at 9.13.12 AM](https://global.discourse-cdn.com/shotgunsoftware/original/2X/3/31f5222d1acac659773e687bf3e051afb28d8a81.png)

The Sequence Page would then display the count of Sub Assets like this:

 ![Screen Shot 2020-12-14 at 9.07.05 AM](https://global.discourse-cdn.com/shotgunsoftware/original/2X/e/ed085a751f06ebf4d77a1a8749cb2393a1f83aeb.png)

If you click on the ‘6’, you get a popup grid like this:

 ![Screen Shot 2020-12-14 at 9.06.47 AM](https://global.discourse-cdn.com/shotgunsoftware/original/2X/e/e4f425470e17268cf1bf9b7e0498ea39dda04451.png)

Hopefully that makes sense and will work for you.

Thanks,  
Matt

---

<div class="post-metadata">

**Author:** ![bonosmo](https://sea1.discourse-cdn.com/shotgunsoftware/user_avatar/community.shotgridsoftware.com/bonosmo/32/2622_2.png) [@bonosmo](https://community.shotgridsoftware.com/u/bonosmo)\
**Post date:** [December 14, 2020, 6:40pm UTC](https://community.shotgridsoftware.com/t/listing-subassets/10977/3 "2020-12-14T18:40:53Z")

</div>

Yup, that makes sense. But there’s an extra step of having to click on the count that my producer hates.

Is there a way to have “Display” option of the query to simply be the spreadsheet of the assets?