Where clause on Custom Object returns 'Internal Server Error'

[brian blankenship]

I get 'Internal Server Error - the Cocoafish team has been notified of this error' when adding a where clause to query a custom object.

Example of my where clause that I send in my xhr:

'where={"title":"Generic Content Title"}'

In Appclerator Titanium, this is: xhr.send('where={"title":"Generic Content Title"}');

When excluding this param, it returns results successfully.

Thanks,

Brian

[Pratik Patel]

Make sure you encode the where clause.

-----------------------------------------------------------

CTO, TripLingo (http://www.triplingo.com)

Twitter: prpatel

Skype: prpatel

[brian blankenship]

Thanks, Pratik.  I get the same results when encoding the where clause, trying various approaches of doing that (below is one).  Is the encoded where clause rather to be appended to the url itself after the API key?

var encodedData = Ti.Network.encodeURIComponent('where={"title":"Generic Content Title"}');

xhr.send(encodedData);

[Wei Kong]

Hi Brian,

You did a post, can you please try get instead? query.json should be HTTP GEt

Thanks,

Wei

___________________

Wei Kong

Co-Founder | Cocoafish

mobile: 415-533-1853

cocoafish.com

@baobeimm

[brian blankenship]

Wei,
Actually, no, I've had "GET" the whole time since it's a query only. There still could be something else I'm doing wrong for sure though. Thanks.

[brian blankenship]

I got it to work.  I just wasn't properly encoding the right portions of the url when appending to the base url.

Thanks.

[Juan Bermudez]

Brian, just had the same issue, any  advice on what you did to fix it?

[brian blankenship]

Juan,

    I just had to construct the url as follows...

'https://api.cocoafish.com/v1/objects/' + class_name + "/query.json?key=" + YOUCFAPPKEY +'&'+'where=’ + Ti.Network.encodeURIComponent('{"title":"Generic Content Title"}');

--
Brian Blankenship, PMP

Senior Solutions Provider

Clearly Innovative, Inc.

http://www.clearlyinnovative.com

An Appcelerator Titanium Gold Partner

O: 202.683.7495

M: 703.408.1211

[Juan Bermudez]

Thanks Brian,

I think I ran into a bug. I have other queries for predefined object and they work perfect when using  the contained in operator $in.

But on a custom object it gives back an internal server error when i try to search $in a field that is a string:

https://api.cocoafish.com/v1/objects/customer/query.json?key=MY_API_KEY&where=URLEncoded({"user_id":"4f74d5d2356f4e75ac001c47", "first_name": {"$in": "p" } })

Let me know if you have encountered this.

Thanks,

Juan

[Wei Kong]

Hi Juan, I wil ltake a look.

Wei

___________________

Wei Kong

Co-Founder | Cocoafish

mobile: 415-533-1853

cocoafish.com

@baobeimm