summaryrefslogtreecommitdiffstats
diff options
context:
space:
mode:
-rw-r--r--user_guide_src/source/database/query_builder.rst52
1 files changed, 48 insertions, 4 deletions
diff --git a/user_guide_src/source/database/query_builder.rst b/user_guide_src/source/database/query_builder.rst
index a33c7073b..3bc9ad8fb 100644
--- a/user_guide_src/source/database/query_builder.rst
+++ b/user_guide_src/source/database/query_builder.rst
@@ -1281,7 +1281,7 @@ Class Reference
Generates the WHERE portion of the query.
Separates multiple calls with 'OR'.
- .. php:method:: or_where_in([$key = NULL[, $values = NULL[, $escape = NULL]]])
+ .. php:method:: or_where_in([$key[, array $values[, $escape = NULL]]])
:param string $key: The field to search
:param array $values: The values searched on
@@ -1292,7 +1292,7 @@ Class Reference
Generates a WHERE field IN('item', 'item') SQL query,
joined with 'OR' if appropriate.
- .. php:method:: or_where_not_in([$key = NULL[, $values = NULL[, $escape = NULL]]])
+ .. php:method:: or_where_not_in([$key[, array $values[, $escape = NULL]]])
:param string $key: The field to search
:param array $values: The values searched on
@@ -1303,7 +1303,7 @@ Class Reference
Generates a WHERE field NOT IN('item', 'item') SQL query,
joined with 'OR' if appropriate.
- .. php:method:: where_in([$key = NULL[, $values = NULL[, $escape = NULL]]])
+ .. php:method:: where_in([$key[, array $values[, $escape = NULL]]])
:param string $key: Name of field to examine
:param array $values: Array of target values
@@ -1314,7 +1314,7 @@ Class Reference
Generates a WHERE field IN('item', 'item') SQL query,
joined with 'AND' if appropriate.
- .. php:method:: where_not_in([$key = NULL[, $values = NULL[, $escape = NULL]]])
+ .. php:method:: where_not_in([$key[, array $values[, $escape = NULL]]])
:param string $key: Name of field to examine
:param array $values: Array of target values
@@ -1424,6 +1424,50 @@ Class Reference
Adds a HAVING clause to a query, separating multiple calls with OR.
+ .. php:method:: or_having_in([$key[, array $values[, $escape = NULL]]])
+
+ :param string $key: The field to search
+ :param array $values: The values searched on
+ :param bool $escape: Whether to escape values and identifiers
+ :returns: DB_query_builder instance
+ :rtype: object
+
+ Generates a HAVING field IN('item', 'item') SQL query,
+ joined with 'OR' if appropriate.
+
+ .. php:method:: or_having_not_in([$key[, array $values[, $escape = NULL]]])
+
+ :param string $key: The field to search
+ :param array $values: The values searched on
+ :param bool $escape: Whether to escape values and identifiers
+ :returns: DB_query_builder instance
+ :rtype: object
+
+ Generates a HAVING field NOT IN('item', 'item') SQL query,
+ joined with 'OR' if appropriate.
+
+ .. php:method:: having_in([$key[, array $values[, $escape = NULL]]])
+
+ :param string $key: Name of field to examine
+ :param array $values: Array of target values
+ :param bool $escape: Whether to escape values and identifiers
+ :returns: DB_query_builder instance
+ :rtype: object
+
+ Generates a HAVING field IN('item', 'item') SQL query,
+ joined with 'AND' if appropriate.
+
+ .. php:method:: having_not_in([$key[, array $values[, $escape = NULL]]])
+
+ :param string $key: Name of field to examine
+ :param array $values: Array of target values
+ :param bool $escape: Whether to escape values and identifiers
+ :returns: DB_query_builder instance
+ :rtype: object
+
+ Generates a HAVING field NOT IN('item', 'item') SQL query,
+ joined with 'AND' if appropriate.
+
.. php:method:: group_by($by[, $escape = NULL])
:param mixed $by: Field(s) to group by; string or array