Querying records with logical filters

From DreamFactory
Jump to: navigation, search
DreamFactoryTutorialsQuerying records with logical filters
Line 5: Line 5:
 
### Supported SQL Databases
 
### Supported SQL Databases
  
 +
* PostgreSQL
 
* MySQL
 
* MySQL
 +
* SQLite
 +
* SQLite 2
 +
* MS SQL Server
 +
* Sybase
 +
* Oracle
 +
* IBM DB2
  
 
### Supported NoSQL Databases
 
### Supported NoSQL Databases
  
 
* MongoDB
 
* MongoDB
 +
* CouchDB
 +
* DynamoDB
 +
* Azure Tables
 +
 +
### Examples
 +
 +
1. Fetch Contact records whose last name starts with the letter 'Y'
 +
 +
Table name: contact
 +
Filter parameter in API call: last_name like Y%
 +
API call: http://your-url/api/v2/db/_table/contact?filter=last_name%20like%20Y%25

Revision as of 22:16, 16 September 2015

      1. Lesson

Learn how to query a SQL or NoSQL database by appending filter strings into a REST API call.

      1. Supported SQL Databases
  • PostgreSQL
  • MySQL
  • SQLite
  • SQLite 2
  • MS SQL Server
  • Sybase
  • Oracle
  • IBM DB2
      1. Supported NoSQL Databases
  • MongoDB
  • CouchDB
  • DynamoDB
  • Azure Tables
      1. Examples

1. Fetch Contact records whose last name starts with the letter 'Y'

Table name: contact Filter parameter in API call: last_name like Y% API call: http://your-url/api/v2/db/_table/contact?filter=last_name%20like%20Y%25