prorm API Reference
    Preparing search index...

    Class SubqueryBuilder

    Builder for creating subqueries programmatically

    Index
    constructor
    select exists notExists count sum avg max min correlated

    • Create an IN subquery

      Parameters

      Returns string

      // Find users with posts using model class
      User.findAll({
        where: {
          id: { [Op.in]: SubqueryBuilder.select('userId', { model: Post }) }
        }
      })

      // Using table name string
      SubqueryBuilder.select('userId', { model: 'posts' })

    • Create an EXISTS subquery

      Parameters

      Returns object

      // Find users who have posts using model class
      User.findAll({
        where: {
          [Op.exists]: SubqueryBuilder.exists({
            model: Post,
            where: { userId: { [Op.col]: 'User.id' } }
          })
        }
      })

      // Using table name string
      SubqueryBuilder.exists({ model: 'posts', where: {...} })

    • Create a correlated subquery using column reference

      Parameters

      • options: {
            outerModel: string | { tableName?: string; name?: string };
            outerColumn: string;
            innerModel: string | { tableName?: string; name?: string };
            innerColumn: string;
        }

      Returns object

      SubqueryBuilder.correlated({ outerModel: User, outerColumn: 'id', innerModel: Post, innerColumn: 'userId' })

    Settings
    Member Visibility

    On This Page
    Constructors
    Methods