Querying records with logical filters

From DreamFactory
Jump to: navigation, search
DreamFactoryTutorialsQuerying records with logical filters
Line 38: Line 38:
 
* Filter parameter in API call: first_name = Jon and last_name = Yang
 
* Filter parameter in API call: first_name = Jon and last_name = Yang
 
* Request URL: https://your-url/api/v2/db/_table/contact?filter=first_name%20%3D%20Jon%20and%20last_name%20%3D%20Yang
 
* Request URL: https://your-url/api/v2/db/_table/contact?filter=first_name%20%3D%20Jon%20and%20last_name%20%3D%20Yang
 +
 +
### Example - Query contact records whose first name starts with 'J' and last name starts with 'Y'
 +
 +
* Table name: contact
 +
* Filter parameter in API call: first_name like J% and last_name like Y%
 +
* Request URL: https://your-url/api/v2/db/_table/contact?filter=first_name%20like%20J%25%20and%20last_name%20like%20Y%25
 +
 +
### Example - Query contact records whose Twitter handle contains 'jon' or whose Skype handle contains 'jon'
 +
 +
* Table name: contact
 +
* Filter parameter in API call: twitter like %jon% or skype like %jon%
 +
* Request URL: https://your-url/api/v2/db/_table/contact?filter=twitter%20like%20%25jon%25%20or%20skype%20like%20%25jon%25

Revision as of 22:43, 16 September 2015

      1. Tutorial

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 - Fetch contact records whose last name starts with 'Y'
      1. Example - Query contact records whose last name is 'Yang'
      1. Example - Query contact records whose first name is 'Jon' and last name is 'Yang'
      1. Example - Query contact records whose first name starts with 'J' and last name starts with 'Y'
      1. Example - Query contact records whose Twitter handle contains 'jon' or whose Skype handle contains 'jon'