... | ... | @@ -67,12 +67,26 @@ To select (firstname, lastname) record fields of Module for matching email (=[te |
|
|
<field name="lastname"> </field>
|
|
|
</record>
|
|
|
<where>
|
|
|
<field name="email" value="[email protected]"> </field>
|
|
|
<field name="email" condition="eq" value="[email protected]"> </field>
|
|
|
</where>
|
|
|
<limit max="1"></limit>
|
|
|
</select>
|
|
|
</api>
|
|
|
```
|
|
|
|
|
|
Condition in where clause supports below options
|
|
|
|
|
|
| Condition | Description |
|
|
|
| -------- | -------- |
|
|
|
| eq | Equals (=) |
|
|
|
| neq | Not Equals (!=) |
|
|
|
| gt | Greater Than (>) |
|
|
|
| lt | Less Than (<) |
|
|
|
| gte | Greater Than OR Equal To (>=) |
|
|
|
| lte | Less Than OR Equal To (>=) |
|
|
|
| in | Select in Multiple VALUES (IN) |
|
|
|
| like | Like (%VALUE%) |
|
|
|
|
|
|
|
|
|
#### Select Records With Value Binding {#select-records-with-value-binding}
|
|
|
|
... | ... | |