For AI agents: the complete documentation index is available at /en/llms.txt, the full documentation bundle is available at /en/llms-full.txt, and this page is available as Markdown at /en/reference/sdk/sapi/db/type-aliases/WhereExpr.md.
SFMC
  • English

      • Type Alias: WhereExpr 

      type WhereExpr = 
  | {
  eq: [string, Primitive];
}
  | {
  ne: [string, Primitive];
}
  | {
  gt: [string, Primitive];
}
  | {
  gte: [string, Primitive];
}
  | {
  lt: [string, Primitive];
}
  | {
  lte: [string, Primitive];
}
  | {
  like: [string, string];
}
  | {
  in: [string, Primitive[]];
}
  | {
  isNull: [string];
}
  | {
  isNotNull: [string];
}
  | {
  and: WhereExpr[];
}
  | {
  or: WhereExpr[];
}
  | {
  not: WhereExpr;
};

      Defined in: sapi/db/types.ts:34

      白名单 WHERE 表达式树（平台翻译为 SQL，禁止手写 SQL）。