// 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>
Read the Docs
Get the Web SDK
// 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!) }
}
Read the Docs
Get the iOS SDK
// 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); }
}});
Read the Docs
Get the Android SDK
