Email: support@essaywriterpros.com
Call Us: US - +1 845 478 5244 | UK - +44 20 7193 7850 | AUS - +61 2 8005 4826

Join operation Vs nested query

Xor

Spec:

Xor(<ROW_CALL>, [ROW_CALL ...])

Description:

Xor performs a logical XOR on the results of each ROW_CALL query passed to it.

Result Type: object with attrs and columns

attrs will always be empty

Examples:

Query columns with a bit set in exactly one of two rows (repositories that are starred by only one of two users):

Xor(Row(stargazer=2), Row(stargazer=1))
{"results":[{"attrs":{},"columns":[20,30]}]}
  • columns are repositories that were starred by user 1 XOR user 2 (user 1 or user 2, but not both)

Not

Spec:

Not(<ROW_CALL>)

Description:

Not returns the inverse of all of the bits from the ROW_CALL argument. The Not query requires that trackExistence has been enabled on the Index.

Result Type: object with attrs and columns

attrs will always be empty

Examples:

Query existing columns that do not have a bit set in the given row.

Not(Row(stargazer=1))
{"results":[{"attrs":{},"columns":[30]}]}
  • columns are repositories that were not starred by user 1