Terry Gilliver
Posts: 0
Joined: Fri Apr 18, 2014 8:45 pm

where clause

I have a service which returns the following:

pre
{
"id":"53fdd490e4b0f5ea491974ba",
"title":"Admirals Salmon Biraan",
"createdAt":"2014-08-27 12:52:32.322",
"updatedAt":"2014-08-29 11:54:45.241",
"description":"Pan fried salmon lightly spiced home style. Ask our Chef and Mr Botterill their favourite.",
"cost":5.95,
"category":{
"id":"5400699ae4b0f5ea49198941",
"category":"Speciality Starters",
"createdAt":"2014-08-29 11:52:58.190",
"updatedAt":"2014-08-29 11:52:58.190"
},
"image":{
"fileName":"6a43fd5f-f922-4766-9632-4d308d6e50c8.gallery12.jpg",
"originalFileName":"gallery12.jpg"
}
},
/pre

I want to add a where clause based on the category string 'Speciality Starters'.

I tried {'category':{'category':'Speciality Starters'}}, but this gave me an empty response '[ ]'.

What is the correct syntax?

Maryna Brodina
Posts: 0
Joined: Thu Apr 05, 2012 7:27 am

where clause

Hello!

Please take a look here http://devcenter.appery.io/documentat...

Terry Gilliver
Posts: 0
Joined: Fri Apr 18, 2014 8:45 pm

where clause

Thanks for pointing me in right direction, I needed:

{"category":{$inQuery:{"category":"Speciality Starters"}}

obullei
Posts: 0
Joined: Thu Jun 05, 2014 12:17 am

where clause

Hello!

Have you resolved your issue?

Terry Gilliver
Posts: 0
Joined: Fri Apr 18, 2014 8:45 pm

where clause

yes working now, thanks

Return to “Issues”