Operator guideENreferralslistplayers

Referrals / List

Referral-focused player list with shared filters, a referrer column, CSV export, and profile links for both the referred user and the referrer.

Reader view

Clean portal guidance

This page keeps the operator explanation, field and action descriptions, and screenshots visible without exposing repo paths, raw sidecars, or editorial-only implementation details.

Narrative content

Page body

What this page shows

This page lists users whose user_id appears in public.user_referrals. Operators use it to review referred players, apply the shared player filters, and move into the right player profile.

How to read the filters

  • Search player filters by the standard player identity fields used on the shared players list.
  • Search ClickID or PID is affiliate-link lookup, not referral-id lookup.
  • Status, Country, Include tags, and Exclude tags behave like the main players list because this page reuses the same grid and backend service.
  • Date start and Date end filter player creation date.
  • Last Deposit Date filters on player KPI summary data, not on referral events.
  • The KYC quick tabs are a shortcut for the same kycStatus filter.

How to read the grid

  • Id, Email, and Name identify the referred player.
  • Status shows whether the referred player account is active.
  • Balance shows the current wallet amount and wallet currency of the referred player.
  • Referrer is the parent player id from public.user_referrals.referral_id.
  • KYC Status, Country, and Tags are inherited player attributes from the shared users list.

Main actions

  • Use the email button or the pencil action to open the referred player profile.
  • Use the Referrer button to open the parent referrer profile.
  • Use Apply Filters when you want to refresh the page with the current filter set.
  • Use the CSV button to export the current result slice.
  • Use the view controls to switch between table and card layouts.

Important caveats

  • Search ClickID or PID runs a dedicated affiliate-link SQL query and can return rows outside the strict referral subset that the default list uses.
  • There is no inline edit on this page. Any referral-copy update happens from Player / Referral Stats.
  • The list does not show referral performance metrics such as visits, registrations, or revenue. Those belong to the player-detail referral workflow.
Field dictionary

Fields

field

Id

Internal id of the referred player.

Data Type
integer
field

Email

Contact email of the referred player and a fast link into the player profile.

Data Type
string
field

Name

Display name of the referred player.

Data Type
string
field

Status

Account active or inactive state of the referred player.

Data Type
boolean
field

Balance

Current wallet balance of the referred player.

Data Type
money
field

Referrer

User id of the parent referrer linked to the referred player.

Data Type
integer
field

KYC Status

Verification state of the referred player account.

Data Type
badge
field

Country

Country code stored on the referred player account.

Data Type
string
field

Tags

Player tags attached to the referred player profile.

Data Type
string-list
Filter dictionary

Filters

field

Search player

Filters by the standard player identity fields used on the shared users list.

Type
text
field

Search ClickID or PID

Searches affiliate-link payload values such as `pid` or `click_id`.

Type
text
field

Status

Restricts the result set by KYC status.

Type
enum
field

Country

Restricts the result set to one country code.

Type
enum
field

Include tags

Keeps only players whose tags contain the selected values.

Type
string-list
field

Exclude tags

Removes players whose tags contain any of the selected values.

Type
string-list
field

Date start

Lower bound for the player creation date filter.

Type
date
field

Date end

Upper bound for the player creation date filter.

Type
date
field

Last Deposit Date

Applies a deposit-history filter using `nx.user_kpi_summary`.

Type
enum
field

Deposit from / Deposit date

Start or single-date input for the selected last-deposit filter mode.

Type
date
field

Deposit to

End date when the last-deposit mode is `Between`.

Type
date
field

KYC quick tabs

Shortcut tabs that update the same `kycStatus` filter used by the list.

Type
tab-filter
Operational notes

Notes

item

The page is a referral-focused variant of the shared players list and does not own its own CRUD backend.

item

Default referral-mode results come from `GET /api/admin/get-users` with `isReferrals=true`, which restricts rows to `user_id` values present in `public.user_referrals`.

item

When `searchAffiliate` is present, the backend switches to affiliate-link SQL and no longer applies the `isReferrals` subset filter.

item

The `Referrer` column comes from a scalar lookup against `public.user_referrals.referral_id`.

Related references

Related pages

pageReferrals Overview

Operator guide for the low-frequency referrals list that reuses the shared players grid to review referred users and jump into player profiles.

pageActivity Tag Rules / List

Main inventory for activity-driven tag rules, with search, activity and status filters, grouped rows, clone, edit, and run actions.

pageAffiliate Deals / List

Searchable table of affiliate deal rows with PID filter, create action, dashboard shortcut, and edit/delete row actions.

pageAffiliate Payment Settings / List

Affiliate payment settings inventory page for reviewing configured rows and opening saved records.

pageAffiliate Settings / List

Affiliate inventory list used to review saved affiliates and open detail or report flows.

pageAuto Tags Manager / List

Rule inventory with search, direct navigation to create or reorder, row-level run controls, and job history or recovery actions.