invantive documentation
Invantive Support ForumsLog In / Sign Up

DirectoryItems_Directory_items: Discourse Directory Item Entries

read only REST

  • Catalog: Discourse
  • Schema: Users
  • Label: Directory Item Entries

Get a public list of users

Can only retrieve data.

Summary

Get a public list of users

API Source

  • Endpoint: /directory_items.json?period={period}
  • Operation: get /directory_items.json?period={period}

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
asc `` Values: True.
order `` Values: likes_received, likes_given, topic_count, post_count, topics_entered, posts_read, days_visited.
period `` Values: daily, weekly, monthly, quarterly, yearly, all.

Table Columns

The columns of the table DirectoryItems_Directory_items 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
days_visited decimal Days Visited writable, days_visited
id decimal ID writable, id
likes_given decimal Likes Given writable, likes_given
likes_received decimal Likes Received writable, likes_received
load_more_directory_items varchar2 Load More Directory Items filters on the platform, writable, ::ancestor.load_more_directory_items
post_count decimal #Posts writable, post_count
posts_read decimal Posts Read writable, posts_read
topic_count decimal #Topics writable, topic_count
topics_entered decimal Topics Entered writable, topics_entered
total_rows_directory_items decimal Total Rows Directory Items filters on the platform, writable, ::ancestor.total_rows_directory_items
user_avatar_template varchar2 User Avatar Template writable, user.avatar_template
user_id decimal User ID writable, user.id
user_name varchar2 User Name writable, user.name
user_title varchar2 User Title writable The JSON text of the nested object.
user_username varchar2 User Name writable, user.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

  • ~ days_visited (database_data_type: decimal → int64)
  • ~ days_visited (dotnet_data_type: decimal → int64)
  • ~ id (database_data_type: decimal → int64)
  • ~ id (dotnet_data_type: decimal → int64)
  • ~ likes_given (database_data_type: decimal → int64)
  • ~ likes_given (dotnet_data_type: decimal → int64)
  • ~ likes_received (database_data_type: decimal → int64)
  • ~ likes_received (dotnet_data_type: decimal → int64)
  • - load_more_directory_items
  • ~ post_count (database_data_type: decimal → int64)
  • ~ post_count (dotnet_data_type: decimal → int64)
  • ~ posts_read (database_data_type: decimal → int64)
  • ~ posts_read (dotnet_data_type: decimal → int64)
  • ~ topic_count (database_data_type: decimal → int64)
  • ~ topic_count (dotnet_data_type: decimal → int64)

10 more changes

Parameter asc of Discourse.Users.DirectoryItems_Directory_items: dotnet data type changes

Dotnet data type changes from boolean to string.

What to Do

Check statements, views and scripts that use it before the upgrade.

  • can break a statement
  • boolean → string
  • importance 3
Parameter order of Discourse.Users.DirectoryItems_Directory_items: presence required changes

Presence required changes from false to true.

What to Do

Check statements, views and scripts that use it before the upgrade.

  • can break a statement
  • false → true
  • importance 3

  • ~ topics_entered (database_data_type: decimal → int64)
  • ~ topics_entered (dotnet_data_type: decimal → int64)
  • - total_rows_directory_items
  • ~ user_id (database_data_type: decimal → int64)
  • ~ user_id (dotnet_data_type: decimal → int64)
  • + meta_last_updated_at (varchar2)
  • + meta_load_more_directory_items (varchar2)
  • + meta_total_rows_directory_items (int64)

All changes of the driver, 26.0 to 27.0