Community Questions & Answers

ALTER COMMAND

Hi, I need to a new column in existing table. Please suggest idea. If you already use Alter Command . Please share the sample code with me. Thanks in Advance

Get image from ACS post query

When doing a query for posts I can only get the photo_id, which is just a ACS id and makes no sense in the context of my app:/ In the ACS web panel all the post photos is stores under "Photos" but I can't find any image Url there...

Query for "Nearby" users in ACS

Is there any approach i should take if i want to be able to query for nearby users? I do have a latitude and longitude value of my current position. And i want to find users within a certain radius. Currently i save lat and lon values into every User...

ACS Query Posts where show_user_like:true

I'm trying to Query Posts where the current User Liked the Posts. I have 4 Posts on ACS; 2 of which the Current User has **liked**. I've tried ~~~ Cloud.Posts.query({ limit:10, show_user_like: true, where:...

ACS way to find out a max number?

I have a number field in one of my ACS objects that gets incremented. How do I query to find out of the objects which one has the highest value? ~~~ $lt Less than $lte Less than or equal to $gt Greater than $gte Greater than or equal to $ne Not equal...

ACS Query tags_array

So My Custom Object Query Looks like this: ~~~ var str = "hello,blue" Alloy.Globals.Cloud.Objects.query({ classname: 'myObj', where: { tags_array: str.toLowerCase(), // all tags are stored in lower case. ~~~ I have a...

Custom Fields Query Error

Hi, on Appcelerator Cloud I have some place data with custom_fields of 'category' Im trying to be able to query places with specific 'category'(which are custom_field) and show it as a list. I read through the documentations on query and custom_fields...

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.

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...

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 =...

Showing 1-50 of 135 1 2 3