Query Parse1.0.1 - App Store

Build and run SQL-liked queries to Parse Server (and parse.com) easily.

Save your time with this guided query builder that checks and prompts automatically:

-data types

-operators

-table and field names

Hassle no more on writing either those long, cumbersome and prone-to-error URI strings or code to query your app s data.

No more of this...

########################################

"https://api.parse.com/1/classes/Employee?keys=firstName,benefitsLevel,isManager,lastName,salary&limit=100&where={"isManager":true,"department":{"$inQuery":{"where":{"division":{"$inQuery":{"where":{"createdAt":{"$lt":{"iso":"2011-11-22T13:47:15.000Z","__type":"Date"}}},"className":"Division"}},"name":{"$regex":"^engineering"}},"className":"Department"}}}

########################################

...or this to query your app s data:

########################################

let innerQuery = PFQuery(className: "Department")

innerQuery.whereKey("name", equalTo:"engineering")

let query = PFQuery(className: "Employee")

query.whereKey("department", matchesQuery: innerQuery)

query.findObjectsInBackgroundWithBlock {

(employees: [PFObject]?, error: NSError?) -> Void in

if err = error

{ //error occurred

}else { //treat employees

}

}

########################################

It also allows you:

*Exporting the query string (rest API-ready) to be executed elsewhere.

*Exporting query result in .csv format to further treatment.

Operators available in this version:

where

and

from

select

order by Ascending

order by Descending

greater than

greater or equal than

less than

less or equal than

equal than

not equal

before

after

exists

not exist

not in values"

in values"

like

in subquery

not in subquery

limit

count

skip

--More operators to come soon--

Data types supported in this version:

Boolean

String

Number

Pointer

Date

--More data types to come soon--

Note: We do not store any master key or password in our servers. They are kept secure in your device s keychain for convenience.

Requires iOS 8.1 or later. Compatible with iPhone, iPad, and iPod touch.