Querying records with logical filters

From DreamFactory
Jump to: navigation, search
DreamFactoryTutorialsQuerying records with logical filters
      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'