Type Alias Expression

Filter expression for querying objects in Lime CRM.

An Expression defines filtering criteria to limit which objects are returned from queries. Expressions support complex logic with AND/OR/NOT operators, comparison operators, and IN operators for checking multiple values or filter results.

Expression types:

BasicExpression - Simple property comparisons (equals, greater than, like, etc.)
AndOrExpression - Combine multiple expressions with AND/OR logic
NotExpression - Negate an expression
InExpression - Check if property matches any value in a list
InFilterExpression - Check if property matches results from another filter

Used in:

Query.filter for QueryService
LoadOptions.filter for LimeObjectRepository
Filter.filter for saved filter definitions

Example: Simple expression, status equals 'active'

import { BasicExpression, Operator } from '@limetech/lime-web-components';

const statusIsActive: BasicExpression = {
    key: 'status',
    op: Operator.EQUALS,
    exp: 'active',
};

Example: AND expression, active deals worth over $50k

import { AndOrExpression, Operator } from '@limetech/lime-web-components';

const activeAndWorthOver50k: AndOrExpression = {
    op: Operator.AND,
    exp: [
        { key: 'status', op: Operator.EQUALS, exp: 'active' },
        { key: 'value', op: Operator.GREATER, exp: 50_000 },
    ],
};

Example: Complex nested expression, high priority open tickets

import { Expression, Operator } from '@limetech/lime-web-components';

const highPriorityOpenTickets: Expression = {
    op: Operator.AND,
    exp: [
        {
            key: 'status',
            op: Operator.IN,
            exp: ['open', 'in_progress', 'waiting'],
        },
        {
            op: Operator.OR,
            exp: [
                { key: 'priority', op: Operator.EQUALS, exp: 'urgent' },
                { key: 'priority', op: Operator.EQUALS, exp: 'high' },
            ],
        },
    ],
};

Example: NOT expression, exclude closed deals

import { NotExpression, Operator } from '@limetech/lime-web-components';

const notClosed: NotExpression = {
    op: Operator.NOT,
    exp: { key: 'status', op: Operator.EQUALS, exp: 'closed' },
};

Example: IN filter expression, deals owned by users matching a filter

import { InFilterExpression, Operator } from '@limetech/lime-web-components';

const ownedBySalesTeam: InFilterExpression = {
    type: 'filter',
    key: 'owner',
    op: Operator.IN,
    exp: 'sales_team',
};

See

LoadOptions for using expressions with LimeObjectRepository
Query for using expressions with QueryService
Filter for saved filter definitions