<p>Does anybody know a way to get the locked asset Ada/tAda information from db-sync? identical to the information displayed in Nami wallet?</p>
<p><a href="https://i.sstatic.net/B5Drw.png" rel="nofollow noreferrer"><img src="https://i.sstatic.net/B5Drw.png" alt="enter image description here" /></a></p>
<p>I've tried looking at all the tables, but nothing seems to hold this value.
could this value be calculated some other way by combining or summing? any help is very much appreciated.</p>

CC BY-SA 4.0
2022-07-19T06:21:26.420Z
All native asset transactions are associated with an ADA transaction. The ADA transaction has a transaction id, and it is probably a way to track locked asset by looking at the ADA transaction id.
Erik de Castro Lopo
CC BY-SA 4.0
2022-07-23T14:05:52.247Z
@ErikdeCastroLopo Thanks for your suggestion, although I'm sadly still stuck on this issue. I created a new question here https://cardano.stackexchange.com/questions/8703/can-anyone-explain-how-tada-locked-with-asset-is-calculated because a more confusing problem came up surrounding locked tAda with assets. thanks again!
FoxB
<native-assets><ada><cardano-db-sync>
Get Ada locked with asset from db-sync query?
# Get Ada locked with asset from db-sync query?

(Asked by: username_0 on 2022-07-15)

Does anybody know a way to get the locked asset Ada/tAda information from db-sync? identical to the information displayed in Nami wallet?

[![enter image description here](https://i.sstatic.net/B5Drw.png)](https://i.sstatic.net/B5Drw.png)

I've tried looking at all the tables, but nothing seems to hold this value.
could this value be calculated some other way by combining or summing? any help is very much appreciated.

**Tags:** native-assets, ada, cardano-db-sync
> **Comments:**
> **username_1**: All native asset transactions are associated with an ADA transaction. The ADA transaction has a transaction id, and it is probably a way to track locked asset by looking at the ADA transaction id.  
> **username_0**: @ErikdeCastroLopo Thanks for your suggestion, although I'm sadly still stuck on this issue. I created a new question here https://cardano.stackexchange.com/questions/8703/can-anyone-explain-how-tada-locked-with-asset-is-calculated because a more confusing problem came up surrounding locked tAda with assets. thanks again!  

---

## 0 answers

