Community Questions & Answers

ACS - Query Users by user ids

Titanium SDK: 3.0.0 GA, **Cloud version: 2.3.0**, Mac OSX 10.8.2 I've been trying to query users by id, I've tried: ~~~ Cloud.Users.query({ page: 1, per_page: 1000, //id:{'$in': contactsArray.join()}, where: { user_ids: {'$in' :...

Alloy SQLite DB

Hello, I am just trying to select only one field from table. Below code works and it returns whole row. ~~~ var subscribers = Alloy.Collections.subscriber; subscribers.fetch({query:'SELECT * from subscriber where id="' + args.id +...

ACS query invalid object Id

Hi, when I tried to query for a user by its object id I got an exception (400) because one of the object Ids passed was not found. ~~~ cloud.Users.query({ where:{ id:{"$in": usersArray} } }, function(e) { // }); ~~~ Can't the...

User Query Error

~~~ if(Ti.App.currentLat != 'None'){ // Ti.App.fireEvent('FillMyInfo'); var tempL =[Ti.App.currentLong,Ti.App.currentLat]; var miles30 = 0.00758; var miles60 = 0.01516; var miles90 = 0.02273; Ti.API.info(miles30); //to convert max distance formula...

How to download data from remote database.

Hi, I have a webpage, and in it, a database. I want to download some data from my webpage to an app. Is it possible? How can I achieve this? What im trying to do, is download the information, and populate a TableView with it, I know how to populate it with...

ACS internal server error

I recently rolled back some code changes in git to a known functioning point. Now when the app executes an ACS query, all I get is ~~~ [INFO] : Error: [ERROR] : : Internal Server Error ~~~ even though I have error message output set to display like...

ACS "group by" query operations?

Does anyone know if ACS supports "group by" operations? If so, can you provide an example. Can't find anything in the doc, but the doc often has stale info. I would think that it's a common query operation.

Cloud objects query problems

Hello, I am using android, I just want to ask if there is any possibility that I am able to allow 2 different username to query information among other many more username? I want to ask if there is any ways to use to allow 2 or 3 username only. Like making...

Collection Fetch Where

Hello, I am storing GPS data on intervals to SQL Lite. Towards the end, I'd like to fetch that data to do some processing. For some reason, when I do, I keep getting empty collections. I'm storing the data using the following: ~~~ var m =...

ACS Places Query takes very long to return result

In the Appcelerator Cloud, in my ACS App in the Development environment, I have populated the Places Collection in MongoDB with 2476 records. In my Node.js application, I have a Web Service request that queries all the data from this...

Cancel ACS query when window closes

I was just wondering if it is possible to cancel an ACS query when a user closes the window. I ask this because if I open a window that fetches some data, close the window before the data is loaded, then open the window again, I receive a null object...

How does one query Android's market?

Is this the proper way to query the android market? Testing on device. ~~~ xhr.open("GET", 'https://market.android.com/search?q=artistname&c=music'); ~~~ artistname is replaced with an actual name. Does not return an error nor load.

getting count of tags

can we search for tags usng tags_array for example record1 has tags A, B, C, D record2 has tags D, S, X, M record 3 has tags A, B, F,G i can get the list of records which have tag A using where and regex. but suppose i want a list of records which have...

ACS Query By UserID

All, I am trying to query posts by user_id. I get a 200 response, but it is including all my posts instead of only those that don't include the current user. Below is my AJAX call: ~~~ var request = $.ajax({ async:false, beforeSend:...

Cloud Query Order Syntax

I want to query images in descending order (I want the newest first). What I have below is not working, they come back randomly every time. ~~~ Cloud.Photos.query({ order: "-created_at", limit: 3, skip: currentQueries*3 } ~~~ What should the...

String matching in ACS

Hi Community, Is there a way of string pattern matching in ACS, e.g ~~~ SELECT * FROM suppliers WHERE supplier_name like '%bob%'; ~~~ In the example above , the query is looking for all suppliers whose name contains the characters 'bob'.

Showing 1-50 of 116 1 2 3