Sunday, June 3, 2012

Appcelerator Cloud Service Custom Object and Query

Recently Appcelerator integrated cloud services with Titanium, in this post I am going to explain about bacics of Appcelerator Cloud Service(ACS)

What is Mobile Cloud Computing?
Mobile cloud computing is the usage of cloud computing in combination with mobile devices.
Cloud computing exists when tasks and data are kept on the internet(data are stored on servers at a remote location) rather than on individual devices, providing on-demand here to know more

ACS Advantage
  • Create a server backed for your app instantly
  • Launch and scale your app automatically
  • No server coding or administration required
  • Scalability and Reliability
  • Flexibility
  • Reduced Cost
  • Increased Storage

What can we do with ACS?
Appcelerator provides around 15+ cloud services, among that few are

Standard(Tier 1)
  • Users
  • Files
  • Photos
  • Custom objects
  • Emails
  • Push notifications
Advanced(Tier 2)
  • Chats
  • Checkins
  • Events
  • Friends
  • Photo Collection
  • Places
  • Posts
  • Reviews
  • Message
  • Social integration

In this post I am going to explain how to 
  1. How to create cloud app?
  2. How to create cloud  user?
  3. How to create custom object?
  4. How to query custom object?
1. Create cloud App

Open your Titanium Studio and create a new ploject and make sure (Automatically cloud-enable this application should be checked)

After creating the project edit your tiapp.xml file you can see two(development, Production) set of cloud API keys. No need to worry about this it will be automatically mapped.

For example If run the App in simulator or Device it will use Development keys, If you create a signed pakage it will use Production keys.

Then login to Appcelerator cloud console and you can see yor newly created app

2.Create Cloud User

Include the module at top of your file then add below code to create a cloud User, Here I am creating a User with some sample data
   var Cloud = require('');
            username: "testuser1",
            password: "testuser1",
            password_confirmation: "testuser1",
            first_name: "test",
            last_name: "user1"
        }, function (e) {
            if (e.success) {
                var user = e.users[0];
                alert('Created! You are now logged in as ' +;
            else {
             if (e.error && e.message) {
                 alert('Error :' + e.message);   
after creating a cloud user, the user will logged in automatically 
click Manage -> Development -> App Management -> Users
Here you can see the list of users, also you can edit the user detail

3.Create Custom Object

Cloud user can definec their own Custom Objects and object types, add beolow code to create a cloud custom object, before creating a custom object user must be logged in
      login  : 'testuser1',
      password: 'testuser1',
    }, function(e) {
      if (e.success)   {

          classname : 'books',
          fields : {
            book_id : 1,
            title : 'Javascript',
            author : 'Peter'
        }, function(e) {
          if(e.success) {
          } else {
            alert('Error: ' + ((e.error && e.message) || JSON.stringify(e)));
      } else {
        alert('Login Error:' +((e.error && e.message) || JSON.stringify(e)));

click Manage -> Development -> App Management -> Custom Objects
Here you can see the list of custom objects, also you can edit the object

4. Query Custom Object

Here I am using three type of query
  if(e.index == 0){
   var params = {classname: "books",page: 1,per_page: 10}; // which is used for sellect object having classname = "books"
  }else if(e.index == 1){
   var params = {classname: "books",page: 1,per_page: 10, where: { author: "Peter"}};// which is used for sellect object WHERE author = 'Peter' and classname = "books"
  }else if(e.index == 2){
   var params = {classname: "books",page: 1,per_page: 10, where: { "book_id":{"$gte" : 2}}};// which is used for sellect object WHERE book_id > 2 and classname = "books"

    , function(e) {
      if (e.success) {
                opLabel.text = JSON.stringify(e.books);
      } else {
                alert('Error: ' +((e.error && e.message) || JSON.stringify(e)));        

Here you can download the complete working project from my Github account  Appcelerator Titanium Custom Object and Query


  1. Congratulations for the post! Helps me to better understand the Custom Objects integration =]
    Thank you and if you can post more tutorials we'll love it !

  2. Hi Karthi,

    Nice post.

    Can ACS perform 'LIKE' queries. So 'Select * from places where name LIKE bob'

    And results would return all matches that contain the string Bob.

    Please email me if you have an answer on

  3. where i need to keep this code in alloy(mvc)

  4. Apart from UI part, obviously you have to write all your code(ACS connection and parsing data) in controller.

  5. thanks for your reply , even though it's not working .i have wrote the code in alloy.js file

  6. Can u share u r project?, so that I can help you