Querying records with logical filters

From DreamFactory
Jump to: navigation, search
DreamFactoryTutorialsQuerying records with logical filters
Line 21: Line 21:
 
* Azure Tables
 
* Azure Tables
  
### Examples
+
### Example 1 - Query contact records with a last name that starts with the letter 'Y'
  
1. Fetch Contact records whose last name starts with the letter 'Y'
+
* Table name: contact
 
+
* Filter parameter in API call: last_name like Y%
Table name: contact
+
* API call: http://your-url/api/v2/db/_table/contact?filter=last_name%20like%20Y%25
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:17, 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. Example 1 - Query contact records with a last name that starts with the letter 'Y'