Less Than or Equal

• Expression: <value1> <= <value2>
• Operand: string, number, time

Constant

Example: Judge whether "2020-01-04" is less than or equal to "2020-04-27"

UQL
return "2020-01-04" <= "2020-04-27"

Result
1

Function

Example: Judge whether PI is less than or equal to 3

UQL
return pi() <= 3

Result
0

Alias

Example: Judge each row of an alias whether it is less than or equal to 3

UQL
uncollect [1,2,3,2,2] as a
return a <= 2

Result
1
1
0
1
1

Sample graph: (to be used for the following examples)

Run below UQLs one by one in an empty graphset to create graph data: ```customlang___fold__lang_uql create().node_schema("professor").node_schema("student") create().node_property(@*, "age", int32).node_property(@*, "email", string) insert().into(@professor).nodes([{_id:"P001",_uuid:1,age:53,email:"[email protected]"},{_id:"P002",_uuid:2,age:27,email:"[email protected]"}]) insert().into(@student).nodes([{_id:"S001",_uuid:3,age:27,email:"[email protected]"},{_id:"S002",_uuid:4,age:20,email:"[email protected]"},{_id:"S003",_uuid:5,age:25,email:"[email protected]"}]) ```

Property

Example: Find nodes whose age is less than or equal to 27

UQL
find().nodes({age <= 27}) as n
return n{*} 

Result
|--------------- @professor --------------|
|  _id  | _uuid |  age  |       email     |
|-------|-------|-------|-----------------|
| P002  |   2   |  27   | [email protected] |

|---------------- @student ---------------|
|  _id  | _uuid |  age  |       email     |
|-------|-------|-------|-----------------|
| S001  |   3   |  27   | [email protected]   |
| S002  |   4   |  20   | [email protected]     |
| S003  |   5   |  25   | [email protected]  |

Example: Find nodes of @professor, whose age is less than or equal to 27

UQL
find().nodes({@professor.age <= 27}) as n
return n{*} 

Result
|--------------- @professor --------------|
|  _id  | _uuid |  age  |       email     |
|-------|-------|-------|-----------------|
| P002  |   2   |  27   | [email protected] |