MngGetPropChallangesByFilter

Returns prop trading challenges in the standard BackOffice table format.

The command name keeps the existing requested spelling Challanges. The server also accepts the alias MngGetPropChallengesByFilter.

Access

SESSION_MANAGER, SESSION_ADMIN, SESSION_DEALER, SESSION_CRM_MANAGER, SESSION_CRM_ADMIN.

Request Parameters

Name	Type	Required	Description
limit	int	Yes	Maximum number of rows, 1..50000
offset	int	Yes	Pagination offset
where	array	No	AND filters, for example [["status", "=", 1]]
whereNot	array	No	Negative filters
whereIn	array	No	IN filters
whereNotIn	array	No	NOT IN filters
whereBetween	array	No	Range filters
whereNotBetween	array	No	Negative range filters
orderBy	array	No	Sort expression, for example [["id", "desc"]]

Supported Filter Fields

Field	Type
id	int
purchase_id	int
program_id	int
customer_id	int
account_login	int
current_phase_index	int
status	int
start_time	int64
end_time	int64
created_time	int64
updated_time	int64

Response Structure

Rows follow this structure order:

[
  "id",
  "purchase_id",
  "program_id",
  "program_name",
  "customer_id",
  "account_login",
  "current_phase_index",
  "status",
  "start_time",
  "end_time",
  "created_time",
  "updated_time"
]

program_name is calculated by the server for BackOffice display.

Request

{
  "command": "MngGetPropChallangesByFilter",
  "extID": "1",
  "data": {
    "limit": 50,
    "offset": 0,
    "where": [
      ["status", "=", 1]
    ],
    "orderBy": [
      ["id", "desc"]
    ]
  }
}

Response Data

{
  "structure": [
    "id",
    "purchase_id",
    "program_id",
    "program_name",
    "customer_id",
    "account_login",
    "current_phase_index",
    "status",
    "start_time",
    "end_time",
    "created_time",
    "updated_time"
  ],
  "rows": [
    [
      12,
      10,
      1,
      "Evaluation 100K",
      5,
      2000100,
      1,
      1,
      1778160000,
      0,
      1778160000,
      1778160000
    ]
  ],
  "count": 1
}