Liststreamkeyitems as SQL like command

Question

Hi all,

Can someone please explain me if it's possible to search the items from a key, using part of key text?

Ex.:

data 1:
key: ThisIsMyKey1
data: ThisIsDataOfKey1
---------------------------------

data 2:
key: ThisIsMyKey2
data: DataOfKey2
------------------------------

data 3:
key: Key3
data: DataOfKey3

 

If I try to use this 'liststreamkeyitems MyKey', this command returns

data 1:
key: ThisIsMyKey1
data: ThisIsDataOfKey1
---------------------------------

data 2:
key: ThisIsMyKey2
data: DataOfKey2

 

I don't know if did this question understandable, but can I do this way?

 

Thanks,

 

Diego

Answer 1

There is no SQL-like syntax. * is used but more as "Any" in some parameters. There isnt a wildcard operator equivalent.

You would get all the keys with liststreamkeys, do a select with your code (in a wildcard fashion), and then query liststreamkeyitems with an array of keys previously discovered.

 

You could also have a database which already has SQL syntax - query it and then get the actual items from the actual keys stored in your db.

Comments

Thanks for your comment. It's helped me a lot.