Smart query builder for your Parse Server-powered app.
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
include
--More operators to come soon--
Data types supported in this version:
Boolean
String
Number
Pointer
Date
--More data types to come soon--
Notes:
1. We do not store any master key or password in our servers. They are kept secure in your device´s keychain for convenience.
2. This app offers in-app purchases in the form of auto-renewable subscription to the service (price vary from country to country.) Currently, we are offering:
(i) 1 Month period - $5.99. Unlimited queries. Unlimited apps.
(ii) 3-Month period - $17.49. Unlimited queries. Unlimited apps.
(iii) 6-Month period - $34.99. Unlimited queries. Unlimited apps.
(iv) 1-year period - $71.99. Unlimited queries. Unlimited apps.
3. Visit our terms & privacy policy sheet for further information: http://192.184.85.134/privacy_policy.html