api: obtain an account's history for a specific asset and operation

[derofim]

Can we please have a call that returns asset activity history for account.

Example:

get_account_history_asset_operations(account_id, asset_id, operation_id, start, stop, limit)

where:
start, stop, limit are for pagination
account_id identifies an account
asset_id identifies an asset
operation_id filters the account history for only operations of this paticular type (e.g. transfer, limit_order_create but also virtual operations like order_filled)

[oxarbitrage]

similar to what was requested initially here: #358

i had made the api call to get history by date several using different approaches, the last can be found at: #405

but it has been hard to get developer community approbation to include it. i will have no problem on make the exact call you need but the approach in bitshares is more generic and it will not include new calls that can be made by other ways.

in your case you can use get_relative_account_history and filter client side. get_history_by_date will probably be added and the operation_type filter can be included but we are probably going to find resistance to add a filter by asset as it only applies to a few operations, this was discarded.

the last proposition i made to include get_history_by_date is to have a separated explorer_api with this and other calls like yours disabled by default so only the nodes that want this calls will allow them.

if i get enough support for that i will be happy to make your calls, i have the conviction that more api calls is better but other devs think the opposite so is hard to get consensus.

[abitmore]

@derofim: technically this is not hard to implement. Just make a new plugin by copying the account_history plugin and add asset_id and perhaps op_id everywhere. You can try to write one. I can help review.

[oxarbitrage]

@derofim if you want to hold a bit i am working on a plugin that will move history into a database(elasticsearch). plugin purpose is to reduce ram while having all the history available and also be a general solution for this and other relational issues that are hard to do right now. stay tuned, i'll update on this on the next days.

[abitmore]

I guess it can be done with ES now. Won't implement it in core.

[oxarbitrage]

Absolutely. The following is the transfers the committee-account made in the last 90 days where the asset was USD:
https://bitshares-kibana.info/app/kibana#/discover?_g=(refreshInterval:(display:Off,pause:!f,value:0),time:(from:now-90d,mode:quick,to:now))&_a=(columns:!(_source),index:d133a430-20b6-11e9-82af-8dfbd16c55a9,interval:auto,query:(language:kuery,query:'operation_type:0%20AND%20account_history.account:1.2.0%20AND%20operation_history.op_object.amount_.asset_id:1.3.121'),sort:!(block_data.block_time,desc))