Operator	Description
~	bitNot
&	bitAnd
|	bitOr
^	bitXor
<<	leftShift
>>	rightShift

Examples

Example	Result
Countries.filter(p=> p.iso3=="BRA").first(p=> {result: p.longitude & 1 })	[{"result":1}]
Countries.filter(p=> p.iso3=="BRA").first(p=> {result: p.longitude	1 })
Countries.filter(p=> p.iso3=="BRA").first(p=> {result: ~ p.longitude })	[{"result":54}]
Countries.filter(p=> p.iso3=="BRA").first(p=> {result: p.longitude << 1 })	[{"result":18446744073709552000}]
Countries.filter(p=> p.iso3=="BRA").first(p=> {result: p.longitude ^ 1 })	[{"result":18446744073709552000}]
Countries.filter(p=> p.iso3=="BRA").first(p=> {result: p.longitude >> 1 })	[{"result":9223372036854776000}]

Sentences

Lambda:

Query to select the first record from the Countries entity where the iso3 is equal to "BRA" and the result is the bitwise AND operation between the longitude and 1.

Countries.filter(p=> p.iso3=="BRA").first(p=> {result: p.longitude & 1 })

SQL Result:

SELECT c.longitude & 1 AS result 
FROM Countries c 
WHERE c.iso3 = 'BRA' 
ORDER BY result asc 
LIMIT 0,1 

Lambda:

Query to select the first record from the Countries entity where the iso3 is equal to "BRA" and the result is the bitwise OR operation between the longitude and 1.

Countries.filter(p=> p.iso3=="BRA").first(p=> {result: p.longitude | 1 })

SQL Result:

SELECT c.longitude | 1 AS result 
FROM Countries c  
WHERE c.iso3 = 'BRA' 
ORDER BY result asc  
LIMIT 0,1 

Lambda:

Query to select the first record from the Countries entity where the iso3 is equal to "BRA" and the result is the bitwise NOT operation of the longitude.

Countries.filter(p=> p.iso3=="BRA").first(p=> {result: ~ p.longitude })

SQL Result:

SELECT ~ c.longitude AS result 
FROM Countries c  
WHERE c.iso3 = 'BRA' 
ORDER BY result asc  
LIMIT 0,1 

Lambda:

Query to select the first record from the Countries entity where the iso3 is equal to "BRA" and the result is the bitwise left shift operation between the longitude and 1.

Countries.filter(p=> p.iso3=="BRA").first(p=> {result: p.longitude << 1 })

SQL Result:

SELECT c.longitude << 1 AS result 
FROM Countries c  
WHERE c.iso3 = 'BRA' 
ORDER BY result asc  
LIMIT 0,1 

Lambda:

Query to select the first record from the Countries entity where the iso3 is equal to "BRA" and the result is the bitwise XOR operation between the longitude and 1.

Countries.filter(p=> p.iso3=="BRA").first(p=> {result: p.longitude ^ 1 })

SQL Result:

SELECT c.longitude ^ 1 AS result 
FROM Countries c  
WHERE c.iso3 = 'BRA' 
ORDER BY result asc  
LIMIT 0,1 

Lambda:

Query to select the first record from the Countries entity where the iso3 is equal to "BRA" and the result is the bitwise right shift operation between the longitude and 1.

Countries.filter(p=> p.iso3=="BRA").first(p=> {result: p.longitude >> 1 })

SQL Result:

SELECT c.longitude >> 1 AS result 
FROM Countries c  
WHERE c.iso3 = 'BRA' 
ORDER BY result asc  
LIMIT 0,1 

Definition

Operator ~

• description: bitNot
• return: boolean
• params:
  • value: boolean

Operator &

• description: bitAnd
• return: number
• params:
  • a: number
  • b: number

Operator |

• description: bitOr
• return: number
• params:
  • a: number
  • b: number

Operator ^

• description: bitXor
• return: number
• params:
  • a: number
  • b: number

Operator <<

• description: leftShift
• return: number
• params:
  • a: number
  • b: number

Operator >>

• description: rightShift
• return: number
• params:
  • a: number
  • b: number