searchUsers method

Future<List<Map<String, dynamic>>> searchUsers(
  1. String query
)

Search users by email or display_name (platform admin only). Uses the backoffice_search_users SECURITY DEFINER RPC to bypass RLS.

Implementation

Future<List<Map<String, dynamic>>> searchUsers(String query) async {
  if (query.trim().isEmpty) return [];
  final response = await _client.rpc(
    'backoffice_search_users',
    params: {'p_query': query.trim()},
  );
  return (response as List<dynamic>)
      .map((row) => Map<String, dynamic>.from(row as Map))
      .toList();
}