List waiting list entries for review

Retrieve artist applications awaiting action. Use this to build admin dashboards or batch-process applications through the review workflow. Results are ordered oldest-first (FIFO) to ensure fair processing. Call this repeatedly during admin review sessions to work through backlog.

Usage

get_pending_waitlist(
  status = c("pending", "reviewing"),
  limit = 100,
  cn = NULL
)

Arguments

status

Character vector. Statuses to include in results (default: c("pending", "reviewing")). Valid values: "pending", "reviewing", "invited", "converted", "rejected". Pass single value like status = "invited" or multiple like status = c("pending", "reviewing").

limit

Integer. Maximum number of entries to return (default: 100). Valid range: 1 to 1000. Use smaller limits for incremental processing, larger limits for analytics queries.

cn

DBI connection object or NULL. Database connection from artcore::dbc("artsite"). If NULL (default), creates and closes connection automatically. Pass existing connection for efficiency in repeated calls.

Value

Data frame with matching waitlist entries containing all fields (id, email, full_name, etc.). Ordered by created_at ascending (oldest first) for FIFO processing. Empty data frame if no matches found.

See also

Other waitlist: convert_waitlist_to_user(), create_waitlist_entry(), get_waitlist_entry(), update_waitlist_status(), waitlist

Examples

if (FALSE) { # \dontrun{
# Get all pending applications
pending <- get_pending_waitlist()
print(nrow(pending))

# Get applications under review
reviewing <- get_pending_waitlist(status = "reviewing")

# Get recently invited artists
invited <- get_pending_waitlist(status = "invited", limit = 50)
} # }