# Db8 substring query

**URL:** <https://forum.webosose.org/t/db8-substring-query/1520>\
**Category:** Univ Colllab - Christ Univ\
**Created:** [July 29, 2021, 8:45pm UTC](https://forum.webosose.org/t/db8-substring-query/1520 "2021-07-29T20:45:24Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![Pritam-CU](https://avatars.discourse-cdn.com/v4/letter/p/aca169/32.png) [@Pritam-CU](https://forum.webosose.org/u/Pritam-CU)\
**Post date:** [July 29, 2021, 8:45pm UTC](https://forum.webosose.org/t/db8-substring-query/1520/1 "2021-07-29T20:45:24Z")

</div>

how to use the %% (substring finder) operator in db8 as a query.

while using the command

luna-send -n 1 -f -m com.palm.configurator luna://com.webos.service.db/find '{"query": {"from":"com.webos.chef:1" ,"where":[{"prop":"ingredients","op":"%%","val":"egg"}]}}'

we got the error

"errorCode": 22,  
"errorText": "invalid parameters: caller='com.palm.configurator' error='invalid enum value for property 'op' for property 'where' for property 'query''",  
"returnValue": false

---

<div class="post-metadata">

**Author:** ![Bhaskar](https://yyz1.discourse-cdn.com/flex031/user_avatar/forum.webosose.org/bhaskar/32/560_2.png) [@Bhaskar](https://forum.webosose.org/u/Bhaskar)\
**Post date:** [August 2, 2021, 11:10am UTC](https://forum.webosose.org/t/db8-substring-query/1520/2 "2021-08-02T11:10:36Z")

</div>

@Pritam-CU  
Use search method with filter clause for sub string matching.

example:  
luna-send -n 1 -f -m com.palm.configurator luna://com.webos.service.db/search '{"query": {"from":"com.webos.chef:1" ,"filter":[{"prop":"ingredients","op":"%%","val":"egg"}]}}'