invantive documentation
Invantive Support ForumsLog In / Sign Up

Admin_BadgesByBadges: Discourse Admin Badges by Badges

read only REST

  • Catalog: Discourse
  • Schema: Badges
  • Label: Admin Badges by Badges

get a list of badges

Can only retrieve data.

Summary

get a list of badges

API Source

  • Endpoint: /admin/badges.json
  • Operation: get /admin/badges.json

Performance Characteristics

Characteristic Value
Average access latency (ms) 243
Write rows per minute 219

The result can be cached on the client.

Table Columns

The columns of the table Admin_BadgesByBadges 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
allow_title char Allow Title writable, allow_title
auto_revoke char Auto Revoke writable, auto_revoke
badge_grouping_id decimal Badge Grouping ID writable, badge_grouping_id
badge_type_id decimal Badge Type ID writable, badge_type_id
description varchar2 Description writable, description
enabled char Enabled writable, enabled
grant_count decimal Grant Count writable, grant_count
i18n_name varchar2 I18N Name filters on the platform, writable, i18n_name
icon varchar2 Icon writable, icon
id decimal ID writable, id
image varchar2 Image writable, image
listable char Listable writable, listable
long_description varchar2 Long Description writable, long_description
manually_grantable char Manually Grantable filters on the platform, writable, manually_grantable
multiple_grant char Multiple Grant writable, multiple_grant
name varchar2 Name writable, name
query varchar2 Query writable, query
show_posts char Show Posts writable, show_posts
slug varchar2 Slug writable, slug
system char System writable, system
target_posts char Target Posts writable, target_posts
trigger decimal Trigger writable, trigger
triggers_none decimal Triggers None filters on the platform, writable, ::ancestor.triggers.none
triggers_post_action decimal Triggers Post Action filters on the platform, writable, ::ancestor.triggers.post_action
triggers_post_processed decimal Triggers Post Processed filters on the platform, writable, ::ancestor.triggers.post_processed
triggers_post_revision decimal Triggers Post Revision filters on the platform, writable, ::ancestor.triggers.post_revision
triggers_trust_level_change decimal Triggers Trust Level Change filters on the platform, writable, ::ancestor.triggers.trust_level_change
triggers_user_change decimal Triggers User Change filters on the platform, writable, ::ancestor.triggers.user_change

Keys

Key Column Refers to Kind Description
Admin_BadgesByBadges_badge_grouping_id_fk badge_grouping_id Admin_Badge_groupingsByBadges.id Key
Admin_BadgesByBadges_badge_type_id_fk badge_type_id Admin_Badge_typesByBadges.id Key

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

  • ~ badge_grouping_id (database_data_type: decimal → int64)
  • ~ badge_grouping_id (dotnet_data_type: decimal → int64)
  • ~ badge_type_id (database_data_type: decimal → int64)
  • ~ badge_type_id (dotnet_data_type: decimal → int64)
  • ~ grant_count (database_data_type: decimal → int64)
  • ~ grant_count (dotnet_data_type: decimal → int64)
  • ~ id (database_data_type: decimal → int64)
  • ~ id (dotnet_data_type: decimal → int64)
  • - image
  • ~ trigger (database_data_type: decimal → int64)
  • ~ trigger (dotnet_data_type: decimal → int64)
  • - triggers_none
  • - triggers_post_action
  • - triggers_post_processed
  • - triggers_post_revision

10 more changes

  • - triggers_trust_level_change
  • - triggers_user_change
  • + admin_badges_triggers_none (int64)
  • + admin_badges_triggers_post_action (int64)
  • + admin_badges_triggers_post_revision (int64)
  • + admin_badges_triggers_trust_level_change (int64)
  • + admin_badges_triggers_user_change (int64)
  • + image_upload_id (int64)
  • + image_url (varchar2)
  • + show_in_post_header (char)

All changes of the driver, 26.0 to 27.0