Skip to content

logical.md

Latest commit

 

History

History
119 lines (86 loc) · 6.68 KB

logical.md

File metadata and controls

119 lines (86 loc) · 6.68 KB

Logical Functions

AND

Signature: AND(argument...)
Returns: boolean
Description: Returns true if all arguments are true

Arguments:

  • argument (boolean): Boolean conditions to check (variadic)
Test References (15 found)

  • boolean-literals.test.js (1 reference)

    • Line 30: const result = evaluateFormula('AND(TRUE, FALSE)', testContext);

  • if-function.test.js (1 reference)

    • Line 42: const result = evaluateFormula('IF(AND(revenue > 1000, cost < 500), "Good Deal", "Check Again")', testContext);

  • logical-operators-functions.test.js (13 references)

    • Line 12: const result = evaluateFormula('AND(revenue > 1000, cost < 500)', testContext);
    • Line 17: const result = evaluateFormula('AND(revenue > 1000, cost < 500, amount > 0)', testContext);
    • Line 22: const result = evaluateFormula('AND(closed, syndication)', testContext);
    • Line 27: const result = evaluateFormula('AND(TRUE, FALSE)', testContext);
    • Line 70: const result = evaluateFormula('AND(OR(revenue > 1000, cost < 100), revenue < 10000)', testContext);
    • Line 75: const result = evaluateFormula('NOT(AND(revenue > 1000, cost < 100))', testContext);
    • Line 80: const result = evaluateFormula('OR(AND(revenue > 1000, NOT(closed)), amount = 0)', testContext);
    • Line 86: const result = evaluateFormula('AND(revenue > 0, cost > 0, amount > 0, closed)', testContext);
    • Line 97: const result = evaluateFormula('AND(ISNULL(revenue), ISBLANK(note))', testContext);
    • Line 109: () => evaluateFormula('AND()', testContext),
    • Line 117: () => evaluateFormula('AND(TRUE)', testContext),
    • Line 157: () => evaluateFormula('AND(revenue, cost)', testContext),
    • Line 181: () => evaluateFormula('AND(revenue > 1000, cost, closed)', testContext),
Usage Examples (0 found)

No usage examples found for this function.

OR

Signature: OR(argument...)
Returns: boolean
Description: Returns true if any argument is true

Arguments:

  • argument (boolean): Boolean conditions to check (variadic)
Test References (12 found)

  • boolean-literals.test.js (1 reference)

    • Line 36: const result = evaluateFormula('OR(TRUE, FALSE)', testContext);

  • logical-operators-functions.test.js (11 references)

    • Line 33: const result = evaluateFormula('OR(revenue > 5000, cost < 100)', testContext);
    • Line 38: const result = evaluateFormula('OR(revenue > 5000, cost < 100, amount = 0)', testContext);
    • Line 43: const result = evaluateFormula('OR(closed, open_approval)', testContext);
    • Line 48: const result = evaluateFormula('OR(TRUE, FALSE)', testContext);
    • Line 70: const result = evaluateFormula('AND(OR(revenue > 1000, cost < 100), revenue < 10000)', testContext);
    • Line 80: const result = evaluateFormula('OR(AND(revenue > 1000, NOT(closed)), amount = 0)', testContext);
    • Line 91: const result = evaluateFormula('OR(revenue > 5000, cost < 100, amount = 0, closed, syndication)', testContext);
    • Line 102: const result = evaluateFormula('OR(ISNULL(revenue), revenue > 1000)', testContext);
    • Line 125: () => evaluateFormula('OR()', testContext),
    • Line 133: () => evaluateFormula('OR(FALSE)', testContext),
    • Line 165: () => evaluateFormula('OR(revenue > 1000, "text")', testContext),
Usage Examples (0 found)

No usage examples found for this function.

NOT

Signature: NOT(requires boolean argument)
Returns: boolean
Description: Returns the opposite of a boolean value

Arguments:

  • requires boolean argument (boolean): Boolean condition to negate
Test References (9 found)

  • boolean-literals.test.js (1 reference)

    • Line 24: const result = evaluateFormula('NOT(FALSE)', testContext);

  • logical-operators-functions.test.js (8 references)

    • Line 54: const result = evaluateFormula('NOT(revenue > 1000)', testContext);
    • Line 59: const result = evaluateFormula('NOT(closed)', testContext);
    • Line 64: const result = evaluateFormula('NOT(TRUE)', testContext);
    • Line 75: const result = evaluateFormula('NOT(AND(revenue > 1000, cost < 100))', testContext);
    • Line 80: const result = evaluateFormula('OR(AND(revenue > 1000, NOT(closed)), amount = 0)', testContext);
    • Line 141: () => evaluateFormula('NOT()', testContext),
    • Line 149: () => evaluateFormula('NOT(TRUE, FALSE)', testContext),
    • Line 173: () => evaluateFormula('NOT(revenue)', testContext),
Usage Examples (0 found)

No usage examples found for this function.

Documentation generated on 2025-06-27T07:39:53.178Z