Timeline for How to get all assets of a certain addresss using SQL on Cexplorer
Current License: CC BY-SA 4.0
5 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Sep 7, 2022 at 6:50 | comment | added | Erik de Castro Lopo |
That seems correct, but I would suggest that you create a view (ie something like the utxo_view) and submit that via GH so I can add that as to the default db-sync distribution.
|
|
| Sep 1, 2022 at 14:05 | comment | added | cdt |
I guess something like this, right? select multi_asset.name::text, ma_tx_out.*, tx_out.* from public.multi_asset, public.tx_out, public.ma_tx_out where multi_asset.id = ma_tx_out.ident and tx_out.id = ma_tx_out.tx_out_id and tx_out.address ='addr1w9742z4fewans7ry6cjp95pc4ecv7y54cx298lp5qfw7s9gv8ukrj'
|
|
| Aug 31, 2022 at 22:26 | comment | added | Erik de Castro Lopo |
You will need to create a new SQL view (call it say ma_utxo_view) that uses the multi asset tables rather than the main tables.
|
|
| Aug 31, 2022 at 22:08 | comment | added | cdt | Thanks for your question. I understand that the utxo_view is for querying the number of ADA. But I still do not get how to get other assets. Could you please provide a rough idea of how to get other assets? | |
| Aug 22, 2022 at 0:55 | history | answered | Erik de Castro Lopo | CC BY-SA 4.0 |