Page History
...
Code Block |
---|
SELECT customerid FROM customers WHERE city = ? ORDER BY customerid ASC //Query params: ['Berlin']
|
Search Criteria with Logical AND
...
Code Block |
---|
// Find all customers in the city of Berlin AND in the postal code 12209 if(foundset.find()){ // Enter find mode city = 'Berlin'; // Assign city search criterion city = 'Berlin'; // Assign a search criteria postalcode = '12209' // Assign postal code criterion foundset.search(); // Execute the query and load the records } |
...
Code Block |
---|
SELECT customerid FROM customers WHERE city = ? AND postalcode = ? ORDER BY customerid ASC //Query params: ['Berlin','12209']
|
Multiple Find Records for Logical OR
...
Code Block |
---|
// Find customers in the city of Berlin AND in the postal code 12209... // OR customers in the city of San Francisco AND in the postal code 94117 if(foundset.find()){ // Enter find mode city = 'Berlin'; city = 'Berlin'; // Assign a search criteria postalcode = '12209'; foundset.newRecord(); // Create a new search record city = 'San Francisco' postalcode = '94117'; foundset.search(); // Execute the query and load the records } |
...
Code Block |
---|
SELECT customerid FROM customers WHERE (city = ? AND postalcode = ?) OR (city = ? AND postalcode = ?) ORDER BY customerid ASC //Query params: ['Berlin','12209','San Fransisco','94117']
|
Finding records through a relation
...
Overview
Content Tools
Activity