SELECT WHERE request

Question

Hi,

I've had a look at the MultiChain JSON-RPC API commands, and I wanted to know if there was any way to request items in a defined stream+key which data would contain a defined byte array passed as a parameter, much like a SELECT WHERE DATA CONTAINS ... SQL request.

Something like liststreamkeyitemscontains stream_id key_id 0x48656C6C6F2C20576F726C6421

Thanks in advance.

Answer 1

Unfortunately this kind of general database-style querying is not yet possible, but there's a lot on the MultiChain roadmap relating to it. For now you would need to write code to synchronize an external database to the node, and then query against that external database. There are many ways to do this including the walletnotify runtime parameter, or just polling against liststreamitems.

Comments

Thanks, that's what I was expecting.