Key word query in storage service

Question

I am trying to run a query against a collection that contains documents like this

{"Where":{"propertyName":"Where","propertyType":"Text","propertyValue":"where is the blackout?"},"DocumentType":{"propertyName":"DocumentType","propertyType":"Text","propertyValue":"DocumentTemplate"},"HomesAffected":{"propertyName":"HomesAffected","propertyType":"Text","propertyValue":"Number of homes affected"},"ComplaintType":{"propertyName":"ComplaintType","propertyType":"Text","propertyValue":"Blackout"},"Since":{"propertyName":"Since","propertyType":"Text","propertyValue":"since how many days"}}

I am t rying to get documents containing a keyword - say "blackout".

I have tried to do this programatically or through the dashboard with no luck - it always returns no document is in the colection. How can I do a keyword search in the jsonDocument?

Can I for instance use a query like 

builtQuery = QueryBuilder.build("propertyValue", "Blackout", Operator.LIKE) which is what i use and get no document found or should I use something else?

Comments

it seems the query will work if we have the key/value pair as "key":"value". And "value" is just a fixed string and not another json fragment. Still need to figure out how to do my query.

Answer 1

Hello James,

You can easily find your document by applying the below query and let me know if it helps:

builtQuery = QueryBuilder.build("Where.propertyValue", "blackout", Operator.LIKE);

Thanks,

Himanshu Sharma

 

Comments

Tried on the dashboard but it did not work.

---

Please make sure your spells are correct while you are searching your document from the dashboard as well as from API . Because the search is case sensitive, so please make sure your query is correct. If you still face an issue then please share the respective screenshots with us. It will help us to replicate the same at our end.

Thanks,
Himanshu Sharma