Query Keyword
| Usage | Arguments | Explanation |
|---|---|---|
| size | @param integer: key eg 3 | The size parameter makes it possible to get a limited number of records |
| where | @param string: key eg id @param mixed: value eg 2 | The where parameter allows for querying data where a key contains a specific value. In this case where the id is 2. |
| orWhere | @param string: key eg id @param mixed: value eg 2 | The orWhere parameter is mostly used together with the where parameter. This allows one to query for data where the column contains a value orWhere another column matches a certain value |
| greaterThan | @param string: key eg id @param mixed: value eg 1 | The greaterThan parameter will get all records where the key is greater than the given value. In this case all products with ids greater than 1 |
| lessThan | @param string: key eg id @param mixed: value eg 2 | The lessThan parameter will get all records where the key is greater than the given value. In this case all products with ids less than 2 |
| offset | @param integer: key eg 2 | An offset of 2 will ignore the first two records in the database , returning data from the third record in the database. Combining the offset with size gives pagination |
| search | @param string: key eg name @param mixed: value eg mark | The search parameter allows to search a table column that contains a keyword. The match may be an exact one or a partial match |
| randomize | @param any: polar eg 1 | This parameter allows records to be populated in a more random form |
| orderBy | @param string: key age | This allows for records to be ordered in descending order based on a particular field |
| asc | @param mixed: key age | Orders records in ascending order based on the age field |
| desc | @param mixed: key age | Orders records in descending order based on the age field |
| notEqual | @param string: key age @param mixed: value 23 | Get all records whose age is not equal to 22 |