/browse

Browse the wanted board for the user's wasteland.

Parse $ARGUMENTS as an optional filter (status, tag, or keyword).

Step 1: Load Config

cat ~/.hop/config.json

If no config, tell user to run /wasteland:join first. Extract handle, upstream, and local_dir from the first wasteland entry.

Step 2: Sync from Upstream

cd LOCAL_DIR
dolt pull upstream main 2>/dev/null || true

Step 3: Query the Wanted Board

cd LOCAL_DIR
dolt sql -r tabular -q "
  SELECT
    id,
    title,
    COALESCE(status, 'open') as status,
    COALESCE(effort_level, 'medium') as effort,
    COALESCE(posted_by, '—') as posted_by,
    COALESCE(claimed_by, '—') as claimed_by,
    COALESCE(JSON_EXTRACT(tags, '$'), '[]') as tags
  FROM wanted
  ORDER BY
    CASE status WHEN 'open' THEN 0 WHEN 'claimed' THEN 1 ELSE 2 END,
    priority ASC,
    created_at DESC
"

Step 4: Format Output

Present results grouped by status:

• Open — available to claim
• Claimed — someone is working on it
• In Review — completed, awaiting validation

If a filter argument was provided:

• If it matches a status (open/claimed/in_review), filter by status
• Otherwise, search title, tags, and project fields for the keyword

Step 5: Show Rig Registry (optional)

If the user asks or if the board is empty, show registered rigs:

cd LOCAL_DIR
dolt sql -r tabular -q "
  SELECT handle, display_name, trust_level, registered_at
  FROM rigs
  ORDER BY registered_at DESC
  LIMIT 20
"

Step 6: Show Character Sheet (optional)

If the user asks about their own profile, show their completions:

cd LOCAL_DIR
dolt sql -r tabular -q "
  SELECT c.id, c.wanted_id, w.title as task, c.completed_at
  FROM completions c
  LEFT JOIN wanted w ON c.wanted_id = w.id
  WHERE c.completed_by = 'USER_HANDLE'
  ORDER BY c.completed_at DESC
"

And their stamps:

cd LOCAL_DIR
dolt sql -r tabular -q "
  SELECT s.id, s.author, s.valence, s.confidence, s.severity, s.created_at
  FROM stamps s
  WHERE s.context_id IN (
    SELECT id FROM completions WHERE completed_by = 'USER_HANDLE'
  )
  ORDER BY s.created_at DESC
"