XServer

// Query data
<script>
function queryObjects() {
  var objects = XSQuery(
    'tableName=' + 'Posts'  // Set the Table name
     + '&columnName=' + 'DT_createdAt'  // Get the createdAt Date column
     + '&orderBy=' + 'descending'  // OR 'ascending' 
  );

  // Array of objects
  var objectsArray = [];
  for (var i = 0; i < objects.length; i++) {
    // JSON Object
    var obj = objects[i];

    // Query filters
    if( obj['ST_category'] == 'Fun' || obj['NU_likes'] == 101 ){ objectsArray.push(obj); }

    // Finalize array of objects by removing duplicates (if any)
    if (i == objects.length-1) { objectsArray = XSRemoveDuplicatesFromArray(objectsArray);
     
      // Get data to show
      console.log(obj['ID_id']);
      console.log(obj['ST_text']);
  } // ./ For
}
</script>

// Query data
XSQuery(tableName: "Posts", columnName: "DT_createdAt", orderBy: "") { (objects, e) in
  if e == nil {
    // For
    for i in 0..<objects!.count {
      let obj = objects![i]

      // Query filters
      if obj["ST_text"].string! == "Some text"
      { self.objectsArray.append(obj) }
    
      // [Finalize array of objects]
      if i == objects!.count-1 { self.objectsArray.XSRemoveDuplicatesFromArray() }
    } // ./ For

    if self.objectsArray.count != 0 {
      print(objectsArray)

    } else { print("No results!") }

  // error on query
  } else { print(e!) }
}

// Query data
XSQuery((Activity)ctx, "Posts", "DT_createdAt", "", new XSQueryHandler() {
  @Override public void done(JSON objects, String error) {
    if (error == null) {
      for (int i = 0; i < objects.count(); i++) {
        JSON obj = objects.index(i);

        if ( obj.key("ST_category").stringValue().matches("Fun") 
          || obj.key("NU_likes").intValue() == 123
        ){ objectsArray.add(obj); }

        // [Finalize array of objects]
        if (i == objects.count()-1) { objectsArray = XSRemoveDuplicatesFromArray(objectsArray); }
      } // ./ For

      if (objectsArray.size() != 0) {
        Log.i("xs", objectsArray);
      // No results
      } else { Log.i("xs", "No results!"); }

    // error
    } else { Log.i("xs", error); }
}});

 // Query data
 List objectsArray = new List();
 var objects = XServerSDK.XSQuery("Posts", "DT_createdAt", "");
 
 for(int i=0; i<objects.Count; i++){
   var obj = objects[i];

   // [Query Filters]
   if (obj["NU_likes"] == 123
     || obj["ST_category"] == "Game"
   ){ objectsArray.Add(obj); }
 } //./ for
 
 // Show data
 if (objectsArray.Count != 0){
   for (int i = 0; i < objectsArray.Count; i++){
     var obj = objectsArray[i];

     Debug.Log(obj["ST_text"]);
     Debug.Log(obj["BL_aBool"]);

   } //./ For
 
 // No results
 } else { Debug.Log("No results!"); }