UserActions: Discourse User Actions
read only REST
- Catalog:
Discourse - Schema:
Users - Label: User Actions
Get a list of user actions
Can only retrieve data.
Summary
Get a list of user actions
API Source
- Endpoint:
/user_actions.json - Operation:
get /user_actions.json
Performance Characteristics
| Characteristic | Value |
|---|---|
| Average access latency (ms) | 243 |
| Write rows per minute | 219 |
The result can be cached on the client.
Parameters
| Name | Data Type | Required | Default | Documentation |
|---|---|---|---|---|
filter |
`` | |||
offset |
`` | |||
username |
`` |
Table Columns
The columns of the table UserActions are shown below. Each column has an SQL data type. A new non-null value must be provided for every required column at all times during insert and update.
| Name | Data Type | Label | Required | Marks | Documentation |
|---|---|---|---|---|---|
acting_ |
varchar2 |
Acting Avatar Template | filters on the platform, writable, acting_ |
||
acting_ |
varchar2 |
Acting Name | filters on the platform, writable, acting_ |
||
acting_ |
int64 |
Acting User ID | filters on the platform, writable, acting_ |
||
acting_ |
varchar2 |
Acting User Name | filters on the platform, writable, acting_ |
||
action_ |
varchar2 |
Action Code | writable | The JSON text of the nested object. | |
action_ |
int64 |
Action Type | filters on the platform, writable, action_ |
||
archived |
char |
Archived | filters on the platform, writable, archived |
||
avatar_ |
varchar2 |
Avatar Template | filters on the platform, writable, avatar_ |
||
category_ |
int64 |
Category ID | filters on the platform, writable, category_ |
||
closed |
char |
Closed | filters on the platform, writable, closed |
||
created_ |
varchar2 |
Created at | filters on the platform, writable, created_ |
||
delete |
char |
Delete | filters on the platform, writable, delete |
||
exerpt |
varchar2 |
Exerpt | filters on the platform, writable, exerpt |
||
hidden |
char |
Hidden | filters on the platform, writable, hidden |
||
name |
varchar2 |
Name | filters on the platform, writable, name |
||
post_ |
int64 |
Post ID | filters on the platform, writable, post_ |
||
slug |
varchar2 |
Slug | filters on the platform, writable, slug |
||
target_ |
varchar2 |
Target Name | filters on the platform, writable, target_ |
||
target_ |
varchar2 |
Target User ID | filters on the platform, writable, target_ |
||
target_ |
varchar2 |
Target User Name | filters on the platform, writable, target_ |
||
title |
varchar2 |
Title | filters on the platform, writable, title |
||
topic_ |
int64 |
Topic ID | filters on the platform, writable, topic_ |
||
user_ |
int64 |
User ID | filters on the platform, writable, user_ |
||
username |
varchar2 |
User Name | filters on the platform, writable, username |
Release Notes
What changed per release in the tables, columns, attributes and capabilities of the driver:
Changes of This Table, 26.0 to 27.0
Parameter offset of Discourse.Users.UserActions: dotnet data type changes
Dotnet data type changes from string to int64.
What to Do
Check statements, views and scripts that use it before the upgrade.
- can break a statement
string→int64- importance 3
-delete-exerpt~hidden(database_data_type:char→varchar2)~hidden(dotnet_data_type:boolean→string)~post_id(database_data_type:int64→varchar2)~post_id(dotnet_data_type:int64→string)~target_user_id(database_data_type:varchar2→int64)~target_user_id(dotnet_data_type:string→int64)+deleted(char)+excerpt(varchar2)+post_number(int64)+post_type(varchar2)