user7239: It seems like a simple question, but I was struggling to find the answer.
I am trying to get information of Cardano blockchain from cexplorer database.
Given an address such as 'addr1w9742z4fewans7ry6cjp95pc4ecv7y54cx298lp5qfw7s9gv8ukrj'
How can I get all the assets currently belonging to this address.
(the assets are minted tokens, nfts, amount of ADA, etc)
Thank you very much.

user5926: For ADA balance, you can use the utxo_view table like this:
select * from utxo_view where
  address = 'addr1w9742z4fewans7ry6cjp95pc4ecv7y54cx298lp5qfw7s9gv8ukrj' ; 

If you look at how utxo_view is defined, you can probably copy and tweak it so you are looking at the relevant multi_asset tables instead.

7239: <p>It seems like a simple question, but I was struggling to find the answer.</p>
<p>I am trying to get information of Cardano blockchain from cexplorer database.</p>
<p>Given an address such as 'addr1w9742z4fewans7ry6cjp95pc4ecv7y54cx298lp5qfw7s9gv8ukrj'
How can I get all the assets currently belonging to this address.
(the assets are minted tokens, nfts, amount of ADA, etc)</p>
<p>Thank you very much.</p>
 5926: <p>For ADA balance, you can use the <code>utxo_view</code> table like this:</p>
<pre class="lang-sql prettyprint-override"><code>select * from utxo_view where
  address = 'addr1w9742z4fewans7ry6cjp95pc4ecv7y54cx298lp5qfw7s9gv8ukrj' ; 
</code></pre>
<p>If you look at how <code>utxo_view</code> is defined, you can probably copy and tweak it so you are looking at the relevant multi_asset tables instead.</p>
