whereIn() / whereNotIn()

whereIn<K extends keyof T>(key: K, values: any[]): QueryBuilder<T>

// Get comments for specific posts
const comments = await Comment
  .whereIn('postId', ['post1', 'post2', 'post3'])
  .get()

// Users in specific departments
const teamMembers = await User
  .whereIn('department', ['Engineering', 'Design', 'Product'])
  .get()

// Products with specific tags
const electronics = await Product
  .whereIn('category', ['phones', 'laptops', 'tablets'])
  .get()

// Orders with specific statuses
const activeOrders = await Order
  .whereIn('status', ['pending', 'processing', 'shipped'])
  .get()

// Recent comments on featured posts
const recentComments = await Comment
  .whereIn('postId', featuredPostIds)
  .where('createdAt', '>', Date.now() - 604800000) // Last 7 days
  .orderBy('createdAt', 'desc')
  .limit(20)
  .get()

// Active users in specific roles
const activeAdmins = await User
  .whereIn('role', ['admin', 'moderator'])
  .where('status', 'active')
  .get()

whereNotIn<K extends keyof T>(key: K, values: any[]): QueryBuilder<T>

// Exclude specific users
const otherUsers = await User
  .whereNotIn('id', ['user1', 'user2', 'user3'])
  .get()

// Products excluding certain categories
const nonElectronics = await Product
  .whereNotIn('category', ['phones', 'laptops', 'computers'])
  .get()

// Users not in banned or suspended status
const activeUsers = await User
  .whereNotIn('status', ['banned', 'suspended', 'deleted'])
  .get()

// Posts excluding draft and archived
const visiblePosts = await BlogPost
  .whereNotIn('status', ['draft', 'archived', 'deleted'])
  .get()

// Recent posts excluding certain authors
const posts = await BlogPost
  .whereNotIn('authorId', blockedAuthorIds)
  .where('status', 'published')
  .where('publishedAt', '>', Date.now() - 2592000000) // Last 30 days
  .orderBy('publishedAt', 'desc')
  .get()

// Available products excluding out of stock categories
const available = await Product
  .whereNotIn('category', outOfStockCategories)
  .where('quantity', '>', 0)
  .orderBy('name')
  .get()

class User extends BaseModel {
  email!: string
  role!: 'admin' | 'user' | 'guest'
  status!: string
}

// TypeScript ensures 'role' is a valid User property
const admins = await User.whereIn('role', ['admin', 'user']).get()

// TypeScript error: 'invalidField' is not a property of User
// const invalid = await User.whereIn('invalidField', ['value']).get()