QBWhereCondition
Overview
The QBWhereCondition
class is an essential component for managing the WHERE clause in queries within the Servoy environment. It provides flexibility for dynamically adding, removing, and clearing conditions in a query, making it easier to build complex SQL conditions. Through methods such as js_add()
and add()
, conditions can be added to the logical condition list, allowing both unnamed and named conditions to be incorporated into the query. These conditions can be specified programmatically or by name, offering significant versatility in query construction.
The class offers robust functionality to handle the logical structure of conditions with methods like getQueryCondition()
, which retrieves or creates the AndOrCondition
for the query. The getQueryCondition(boolean create)
variant ensures that the condition is generated when needed, providing more control over the query construction process.
Additional methods like remove()
and clear()
allow for easy modification of the condition list. The remove()
method enables the removal of named conditions from the logical group, while clear()
resets all conditions in the WHERE clause, facilitating full control over the query structure.
Properties Summarized
Methods Summarized
Properties Detailed
conditionnames
Get the names for the conditions in the logical condition.
Type Array an array of strings representing the names of the conditions in the logical condition.
Sample
parent
Get query builder parent table clause, this may be a query or a join clause.
Type QBTableClause
Sample
root
Get query builder parent.
Type QBSelect
Sample
Methods Detailed
add(condition)
Add a condition to the AND or OR condition list.
Parameters
QBCondition condition the condition to add
Returns: QBLogicalCondition the updated logical condition with the added condition.
Sample
add(name, condition)
Add a named condition to the AND or OR condition list.
Parameters
String name the name of the condition
QBCondition condition the condition to add
Returns: QBLogicalCondition the current QBWhereCondition instance after adding the named condition.
Sample
clear()
Clear the conditions in the query where-clause.
Returns: QBLogicalCondition the current QBWhereCondition instance after clearing all conditions.
Sample
getCondition(name)
Get a named condition in the logical condition.
Parameters
String name The condition name.
Returns: QBLogicalCondition the named condition as a new logical condition, or null if the condition does not exist.
Sample
remove(name)
Remove a named condition from the AND or OR condition list.
Parameters
String name The condition name.
Returns: QBLogicalCondition the current QBWhereCondition instance after removing the specified condition.
Sample
Last updated
Was this helpful?