How to search for partial string?

hainesmatt

Sorry if this is really obvious, but I'm at a loss. How do I search for a string that is a subset of a value? For example, if:

{"_default": {"1": {"symbol": "GKOS", "strat": "strat01_mr", "id": "strat01_mr_2018-12-28T20:30:24.995541+00:00"}}}

How do I search to return any document that has a "id" value beginning with "strat01"?

msiemens

Hey hainesmatt ,

You could use a Regex ? For example:

db.search(where('id').matches('strat01.*'))

Cheers!

hainesmatt

msiemens Thank you, that did it!

msiemens

Glad I could help!

txoof

Can you give an example of how to search for a partial string using the lambda method? I clearly don't understand how to properly use lambda, but this looks exactly like what I need.

I borrowed this from a post on GitHub - perhaps you can point me in the right direction with it?
test_func = lambda value, search: s.contains(search) trackDB.search(Query().albumName.test(test_func, 'Downward') >>> NameError: name 's' is not defined

msiemens

txoof Hey! The example code has an error. You should be able to use:

>>>  test_func = lambda value, search: search in value
>>>  trackDB.search(Query().albumName.test(test_func, 'Downward')

Cheers!

txoof

thanks so much! this is perfect.